Is there any way in teradata by which I can insert the result set of the another Store procedure into a table.
Something like below (Syntax is wrong here)
insert INTO VT_invalidFilesTable
(FileName, Description, FileContent)
CALL "LOG".usp_DailySalesReportGetFiles(1, forInvalidFiles);
If you need to access the result outside of the SP you should use an Insert/Select into a Global Temporary Table instead of returning a Dynamic Result Set.