[Closed] Holding specific file in the procedure by using app hold

Hi All,

I have procedure with more than 20 hold files, but I want to hold the last hold file for reusing in the another procedure. When I use APP HOLD Apppath its holding all the files. Please suggest me is there any way to do this.

Example:

TABLE FILE CAR
PRINT CAR COUNTRY RETAIL_COST
ON TABLE HOLD AS HLD1
END
-RUN
TABLE FILE HLD1
SUM RETAIL_COST
BY CAR
BY COUNTRY
ON TABLE HOLD AS HLD2
END
-RUN
APP HOLD APPPATH
-RUN
TABLE FILE HLD2
PRINT RETAIL_COST
BY COUNTRY
ON TABLE HOLD AS HLD3 FORMAT FOCUS
END
-RUN

I am using the last file HLD3 in another program.

Thanks,
Koti,
WF7703, Windows 7.

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

WebFOCUS 8104/7703/769/764, Windows 7, Oracle 11g, DB2, QAD

Posts: 49 | Location: Chennai | Registered: May 20, 2008

TexasStingray

Master

posted

Hide Post

If you want to hold the files for each user so the files do not get mixed up then use the following

ON TABLE HOLD AS FOCCACHE/<NAME>

When the users session has no longer active the files will get deleted automatically.

Scott

Posts: 865 | Registered: May 24, 2004

Ignored post by TexasStingray posted

Show Post

susannah

Expert

posted

Hide Post

This works.
i'm specifying the actual directory where i want the final file held. The first APP HOLD
is just precautionary, to clear any other APP holding command that may have existed earlier in the same procedure.
APP HOLD
TABLE FILE IBISAMP/CAR
BY CAR
ON TABLE HOLD AS HCAR1
END
TABLE FILE IBISAMP/CAR
BY MODEL
ON TABLE HOLD AS HCAR2
END
APP HOLD xsusantest
TABLE FILE IBISAMP/CAR
BY COUNTRY
ON TABLE HOLD AS HCAR3
END
APP HOLD

i've never seen APP HOLD APPPATH before.
I've only ever seen/used specific references to a directory