You haven't said how the EDIPF.xls file was created. Being in QTEMP, this is a physical file and not an xls file. Maybe you have created a flat file with the necessary data to make it an xls file, but I would think that is unlikely. Xls files would normally be created in the /Root file system as they're not database files.
It seems like that may be a better option to send the email as it will automatically convert a PF to a csv file for emailing which I'm guessing is what you are really trying to do. The ID sending the email though will still need to be enrolled in the system distribution directory via e.g. WRKDIRE.
following RDKells instructions, I have:
Then you need a file with data in, i.e; RAREPUSRW2: for me this would be EDIPF?
Next you need a location on the IFS to copy this file to, earlier in the program I build an IFS location/File Name (&IFSP), i.e; \reports\userreports\inactiveusers201708.csv: not sure how I "build" a location. Do I just set a variable equal to a path?
Copy the iSeries file to the IFS; this part is where you indicate the stream file? TOSTMF()
any help would be very appreciated!!!
Comment