Archives of the TeradataForum
Message Posted: Wed, 18 Aug 2004 @ 16:08:27 GMT
| Subj: || || Re: PP2 to DB2 to Cobol Process |
| From: || || Fred Pluebell |
No, the two preprocessors won't be able to tell which EXEC SQL belongs to which database. You could use separately compiled subprograms.
But unless the number of rows is very small, using a COBOL program to fetch the information a row at a time will be significantly slower than a
two-step approach using Teradata utilities to create a "flat file" as input to the COBOL program.