You might investigate if DSNTEP2 or DSNTEP4 will accept input records
longer than 80 characters. Executable code for both is provided with
DB2. You can check the provided source code for both to determine if the
program uses the input file DCB parameters or requires a fixed 80
character record. If you ave the PL/I compiler available, you could
easily alter (if necessary) the program to handle longer input records.
Phil Sherman
al**********@btinternet.com wrote:
Hi - I would be grateful for advice regarding the following.
Via SPUFI, I am using an SQL member to generate further SQL Statements.
Unfortunately, the generating output SQL statements are longer than 80
bytes in length.
SPUFU will only accept statements that are <= 80 bytes.
Therefore, do you know of an automatic method of splitting each
generated output statement over 2 lines.
I dont think this can be done via SPUFI.
How about a SORT step?
Thanks