Originally posted by George Patton:
First of all, thanks for all the suggestions! It took me a while to get back to this and here are the results.
Krish: I'm not using Managed Reporting so your solution is out, unfortunately.
All 3 of the solutions from Jack, Tom and Waz worked beautifully.
Jack's:
FILEDEF * CLEAR
FILEDEF PEOPLE DISK './people.txt'
? FILEDEF
-GOTO DONE
Gives:
Lname Device Lrecl Recfm Append Filename
============================================================
PEOPLE DISK 0 V ./people.txt
The ? FILEDEF doesn't say where the physical file is stored, but it turns out to be in the expected temp directory.
Tom's:
FILEDEF * CLEAR
FILEDEF PEOPLE DISK 'FOCCACHE/people3.txt'
? FILEDEF
-GOTO DONE
Gives:
Lname Device Lrecl Recfm Append Filename
============================================================
PEOPLE DISK 0 V FOCCACHE/people3.txt
This turns out to be physically in: /home/iadmin/ibi/srv77/wfm/edatemp/foccache/ip000626010>
Waz's:
This is the most complex programatically, but does have one advantage in that the location is obvious without digging around on the server:
-SET &TEMPPATH = TEMPPATH(80,'A80') || 'people2.txt';
FILEDEF * CLEAR
FILEDEF PEOPLE DISK &TEMPPATH
? FILEDEF
-GOTO DONE
Gives:
Lname Device Lrecl Recfm Append Filename
============================================================
PEOPLE DISK 0 V /home/iadmin/ibi/srv77/wfm/edatemp/ts000013/people2.txt
Thanks again everyone!