Archives of the TeradataForum
Message Posted: Thu, 15 Apr 2010 @ 13:57:07 GMT
| Re: Calling a Procedure with Dynamic SQL
There are several ways to do this. One way is to write a file or trigger an event using the procedure you are writing.
I assume you are using Bteq, then in that case call that procedure and use Bteq built in procedural commands say (.GOTO/ .IF etc) and use those
to call the other procedure. You can also use the process to write to the database itself. Next use the next step to check the resultsets in the
Database and then based on that you can decide to call the other process. Hope this helps.