I am not quite sure what I am doing wrong. I am trying to create my own saved file that I can then access when I want to create a report. I have tried different variations but I cannot get KFR to show up in the Table list. What is wrong with my code?

TABLE FILE WEBFOCUS_REPORT_AGENCY_DATA
BY AGENCYID
BY INDUSTRYID
BY MEMBERSHIPSTATUS
BY AGENCYNAME
BY TERRITORY
BY AGENCYTYPE
BY address1
BY CityStateZip
BY Inner
BY Engagement
BY JVP
WHERE PARENTAGENCYID EQ MISSING;
ON TABLE NOTOTAL
ON TABLE SAVE FILENAME
'compass/KFR.ftm'
END									    

This message has been edited. Last edited by: kfr104,

Save files do not create master file and there nothing appears on the list. Try a hold file.

Fernando

Fernando is quite right You have to use HOLD.

However if you want to use it in a subsequent request then you need to hold both the data
and the master to a location on the APP PATH. lookup APPHOLD

kf..
do you want to use this extract file now (in the current fex)? or later in a subsequent fex?
(a)if you want to use it now,
its quite sufficient to say
ON TABLE HOLD AS myfilename
END
-RUN
TABLE FILE myfilename
...and write your report.
(b) if you want to use it later,
you need to park it somewhere on your server.
Here we'll park in in the baseapp..

APP HOLD baseapp
TABLE FILE source
...
ON TABLE HOLD AS myfilename {FORMAT ALPHA}
END
...then later
APP PATH baseapp {or whatever you need}
FILEDEF MYFILENAME DISK baseapp/myfilename.ftm
TABLE FILE MYFILENAME
....
END

Thanks for the info