I'm converting a bunch of mainframe VM batch jobs to WebFocus using ReportCaster and I have a few questions.

1) If I execute multiple macros in a Focexec supplying -RUN after each, will the program wait until the completion of the macro before moving to the next one?

Example:

SQL SQLDBC EXEC MACRO1;
END
-RUN
SQL SQLDBC EXEC MACRO2;
END
-RUN

2) Is there a way to turn the Teradata messaging on so I can see what's going on? When I run the macros using the Teradata utility on the mainframe I get # of records deleted, inserted, updated, etc. With the ECHO and MSG ON I don't get those messages. I think the best I can do is test for a return code.

Thanks,
Mark

This message has been edited. Last edited by: <Kathryn Henning>,

quote:

1) If I execute multiple macros in a Focexec supplying -RUN after each, will the program wait until the completion of the macro before moving to the next one?Example:SQL SQLDBC EXEC MACRO1;END-RUNSQL SQLDBC EXEC MACRO2;END-RUN

With or without the -RUN's, execution in a FEX is serial. The second SQL request will not be reached until the first gets back control from the relational db server.

Thanks Jack...