Focal Point
Assign a variable with a number value coming from a hold file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3181066262

December 21, 2007, 02:49 PM
Trina
Assign a variable with a number value coming from a hold file
How to assign a variable with a number value coming from a hold file?

Pls help...

Trina


WebFOCUS 7.6.10
Windows/XP
Database: Oracle
Output: Excel
December 21, 2007, 03:25 PM
jbement
This sample shows how I have been able to get this to work:

SET ASNAMES=ON
SET HOLDLIST=PRINTONLY

DEFINE FILE EMPDATA
NHIREDATE/MDY = HIREDATE;
NHIREMY/MY =NHIREDATE;
NEWSAL/D12.2 = SALARY * 1.5;
END
TABLE FILE EMPDATA
SUM
CNT.SALARY/I5C AS 'SCOUNT'
SALARY/D12.2C AS 'SALARY'0
ON TABLE HOLD AS SAL_STUFF
END

TABLE FILE SAL_STUFF
SUM
COMPUTE AVG/D12.2=SALARY/SCOUNT;
ON TABLE SAVE AS SAL_AVG
END
-RUN

-READ SAL_AVG &SAL_READ.12
-TYPE &SAL_READ

TABLE FILE EMPDATA
PRINT
COMPUTE SDIF/D12.2 = SALARY- &SAL_READ;
SALARY
END
December 21, 2007, 04:13 PM
FrankDutch
Trina

I would ask you to upgrade your signature so we know what version you have.

The example given is ok, the only addition I would give is.

-READ SAL_AVG &SAL_READ.I12

I added the "I" because you want a numeric value.

It's all described in the wf761appslang.pdf file




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

December 28, 2007, 10:49 AM
Trina
Thanks a lot to both of you.

Frank thanks for mentioning to add I before the length.

Trina


WebFOCUS 7.6.10
Windows/XP
Database: Oracle
Output: Excel