emergingbytes.com Technology blog for data warehousing, business intelligence, iPhone Apps Development, Android Apps development and facebook applications

Teradata Calling A Procedure Within A Procedure

Yes! Teradata allows you to call a stored procedure within a stored procedure. One way of doing it is as follows:

CALL DBC.SYSEXECSQL('CALL PROC_A(''VALUE'',OUTPUT)');

It might be required for many reasons, for example writing a sub routine to process data or to recursively call same procedure until some criteria is met.  For me, it was used in a case where WAP source system was sending data usage for specific events only and for rest of the events data usage was only included in session summary. Therefore, to process session summary information, a separate routine was written which was called to process session summary.