Focal Point
build a &variable

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

June 06, 2008, 05:48 PM
Tomsweb
build a &variable
I am reading values from a hold file.

TABLE FILE CAR
PRINT COUNTRY
ON TABLE HOLD FORMAT ALPHA
END
-RUN
-*
-SET &LIMIT=&LINES;
-SET &I=1;
-*
-REPEAT ENDLOOP &LIMIT TIMES
-READ HOLD NOCLOSE &COUNTRY.10.
-SET &COUNTRY.&I=&COUNTRY;
-*
-TYPE &COUNTRY.&I
-*
-SET &I=&I+1;
-*
-ENDLOOP

I am trying to brush off the rust, and I'd like a little help...

How do I build a variable to hold each of the values from the -read loop to use elsewhere (maybe a where statement).

Any ideas?

Thanks very much! Big Grin


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
June 06, 2008, 06:27 PM
susannah
tom..you don't look rusty to me...looks like you did just what you wanted to do.

do you want a single WHERE ?
if that's it, then
DEFINE FILE CAR
COUNTRY2/A12='''' | COUNTRY | '''';
END
TABLE FILE CAR PRINT COUNTRY2 ON TABLE HOLD FORMAT ALPHA
END
-*
TABLE FILE somethingelse
WHERE COUNTRY IN FILE HOLD
or this used to work
WHERE COUNTRY IS (HOLD)

Here's a tech link..




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID