Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 15 Apr 2010 @ 13:57:07 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Calling a Procedure with Dynamic SQL
From:   Mohommod.Khan

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023