I am new to the CL (Command Language) used by the as/400. I need to generate a spreadsheet of data from the as400. I would like to have all the data stored in one excel file instead of multiple excel files.
Can someone show me how to use the various sheets in excel to store the data and how to create additional sheets?
* Create Spreadsheet of all Numbers by branch*/
* EXECUTE VIEW (CUSIGQ1)PCFMT(*XLS) TOFLR(&FOLDER) +
TODOC(CUSIG.XLS) REPLACE(*YES) +
TEXT('Program lists all Numbers +
March 2, 2009 8:14 PM
March 13, 2009 11:32 PM