I need to execute a set of PROCs (lets say A, B & C in sequence) using QMF for Windows. These procs contain INS/UPD SQL statements that operate on Teradata via an ODBC.
User uses QMF for Windows to execute these PROCS. They will sequence A, B & C in the QMF window and execute it at one go. However, these get executed in an Interactive mode, meaning once Proc A gets executed, it prompts the User with the status of INS/UPD and until the User hits the "ok" prompt, system will not proceed with the execution of the next Proc.
We would like to get rid of this Interactive mode and have all the PROCS executed in batch in strict sequence. Is there a way to go about this ?