0 NUMBER OF ERRORS= 0 NUMBER OF SEGMENTS= 1 ( REAL= 1 VIRTUAL= 0 ) NUMBER OF FIELDS= 14 INDEXES= 0 FILES= 1 TOTAL LENGTH OF ALL FIELDS= 154 ?FF AGEGRP_99_A -RUN
In stead of -TYPE &JNZ.EVAL do a &JNZ.EVAL (without the -type in front of it). I do see you building the join command, but I have not seen in your code that you actually execute the join command.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
November 04, 2010, 04:15 PM
Tomsweb
Gamp,
Thank you. I did that and I do see fields from both of the files.
BY &CMPL_FN.EVAL.AGEGRP BY &CMPL_FN.EVAL._TYPE_ END -RUN -EXIT
That is very cool if all my fields are from the same file. If not then I will have to change the value of &CMPL_FN to retrieve data from the 2nd (xref) file.
I apologize if I did not state what may be obvious...I am trying to print a calendar year report as the table I am forced to report from contains only a Fiscal Year of data.
Sorry!This message has been edited. Last edited by: Tomsweb,
Check the syntax of "CHECK FILE" ... no need for the left paren in 'CHECK FILE AGEGRP_99_A (PICT", is there?...
November 05, 2010, 09:50 AM
Tomsweb
In my post yesterday, I used the CHECK FILE command incorrectly:
quote:
CHECK FILE AGEGRP_99_A (PICT -RUN
(FOC1517) UNRECOGNIZED COMMAND CHEC 0 NUMBER OF ERRORS= 0 NUMBER OF SEGMENTS= 2 ( REAL= 1 VIRTUAL= 1 ) NUMBER OF FIELDS= 28 INDEXES= 0 FILES= 2 TOTAL LENGTH OF ALL FIELDS= 308 -EXIT
The correct syntax of the command is captioned below:
quote:
CHECK FILE AGEGRP_99_A PICT -RUN 0 NUMBER OF ERRORS= 0 NUMBER OF SEGMENTS= 2 ( REAL= 1 VIRTUAL= 1 ) NUMBER OF FIELDS= 28 INDEXES= 0 FILES= 2 TOTAL LENGTH OF ALL FIELDS= 308 1SECTION 01 STRUCTURE OF GNTINT FILE AGEGRP_9 ON 11/05/10 AT 09.45.40 AGEGRP_> 01 S0 ************** *AGEGRP ** *_TYPE_ ** *JUL98 ** *AUG98 ** * ** *************** ************** I I I I AGEGRP_> 02 I KM .............. :AGEGRP ::K :_TYPE_ :: :JUL99 :: :AUG99 :: : :: :............:: .............: JOINED AGEGRP_00_A -EXIT