I have encountered a code in the existing applications where in after several Match, More , Computes. The HOLD file was used by infoassist to create a graph for example:

TABLE FILE RX_VOLUME_CHART
SUM
COMPUTE BNO_NOGAP/D18=IF BNO EQ MISSING OR BNO EQ 0 THEN LAST BNO_NOGAP ELSE BNO;
COMPUTE CNO_NOGAP/D18=IF CNO EQ MISSING OR CNO EQ 0 THEN LAST CNO_NOGAP ELSE CNO;
COMPUTE FNO_NOGAP/D18=IF FNO EQ MISSING OR FNO EQ 0 THEN LAST FNO_NOGAP ELSE FNO;
COMPUTE JNO_NOGAP/D18=IF JNO EQ MISSING OR JNO EQ 0 THEN LAST JNO_NOGAP ELSE JNO;
COMPUTE RNO_NOGAP/D18=IF RNO EQ MISSING OR RNO EQ 0 THEN LAST RNO_NOGAP ELSE RNO;
COMPUTE PLOT_CYP/D10=IF PERIOD EQ '06' THEN PLOT_CYP+150 ELSE PLOT_CYP;
PLOT_VOL
YEO_DEC_PLOT
CYP_DEC_PLOT
BY PERIOD
BY Month
ON TABLE HOLD AS RX_VOLUME_CHART_AMM
END

-RUN
-TYPE ***Chart 1 - Ammonia***
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$PD94bWwgdmVyc2lvbj
*-INTERNAL_COMMENT LINE#1$b3BlcnR5Pg0KICAgIC
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='205.0';
-DEFAULTH &WF_STYLE_WIDTH='600.0';
-DEFAULTH &WF_TITLE='Ammonia Production Volume';
GRAPH FILE RX_VOLUME_CHART_AMM
-* Created by Info Assist for Graph
SUM
BNO_NOGAP AS '&AS_BNO'
CNO_NOGAP AS '&AS_CNO'
FNO_NOGAP AS '&AS_FNO'
JNO_NOGAP AS '&AS_JNO'
RNO_NOGAP AS '&AS_RNO'
PLOT_CYP AS 'Target'
PLOT_VOL NOPRINT
YEO_DEC_PLOT NOPRINT
CYP_DEC_PLOT NOPRINT
BY PERIOD NOPRINT
BY Month AS ''
HEADING
.
.
END

How Can we invoke Infoassist for creating a Graph on a Hold file.

Regards,
Kumar

This message has been edited. Last edited by: FP Mod Chuck,

Hi iBenny

The fex that creates the HOLD file would need to have the APP HOLD statement which saves the file to a specified application folder. Once that is there you would have to modify the associated master file to add the DATASET statement so the data file can be read. Once this is done the hold file will show up in the list of master files to use with InfoAsssist. If this hold file needs to be re-created on a regular basis ReportCaster can be used to trigger that event.

Hi Chuck,

I had the same idea of doing an apphold on the hold file, Can you please detail the steps which am I supposed to do after an APP HOLD to make the file appear in the List of master files.

Hi iBeny

You want to do the APP HOLD into an app folder that is in the APP PATH. If you use

ON TABLE HOLD AS somename FORMAT ALPHA


The master file will be whatever name you substitute for somename in my example above. Then the easiest way to provide access to the data is to use this commeand in the server profile (edasprof.prf)


FILEDEF somename DISK appfoldername/somename.ftm


Where appfoldername is the name of the application directory you used in the APP HOLD command and somename.ftm will match the name of the master file.