Flexible Input, Dazzling Output with IBM i by Victória-Pereira Rafael;

Author:Victória-Pereira, Rafael;
Language: eng
Format: epub
Publisher: MC Press
Published: 2014-08-15T00:00:00+00:00

The Even Easier Way

For situations in which there’s already an output file, it makes no sense to develop code to read it again and write it line by line. So, this section provides another procedure to help you. It’s quite simple to use, actually. You just add the USROPN keyword to the output file, close it once it’s ready to transfer, and include these lines of code:

Sound simple enough?

Let’s look at the parameters:

OUTF is the name of the physical file.

XLS, MyTemplate.xls, and MySheet indicate the IFS folder, workbook, and sheet to use as templates, respectively.

1 indicates that there’s only one header row.

4 indicates that the template has four columns.

“§” is the separator character.

The second XLS indicates the output IFS folder.

MyOutputFile.xls indicates the name of the output file.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.