View previous topic :: View next topic
|
Author |
Message |
Vignesh Sid
New User
Joined: 04 Sep 2017 Posts: 43 Location: India
|
|
|
|
Hi all,
I a trying to convert a VBA file to FB by extracting only selective records.
Input file: RECFM=VBA;LRECL= 125;
Code: |
NONVSAM ------- XX.W.TOTALS.OUTPUT
|
Output file: RECFM=FB;LRECL= 26;
XX.W.TOTALS.OUTPUT
I used the below sort card:
Code: |
SORT FIELDS=COPY
OUTFIL FNAMES=SORTOUT,INCLUDE=(5,7,CH,EQ,C'NONVSAM'),VTOF,
BUILD=(1:18,26)
|
But I get an empty output file. Could anyone let me know for your thoughts!
Thanks, |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Why not show the sysout and give us a clue ? - - - No info = less help
But as your control statements look OK I would guess that the location of the selection may be off |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello Viky,
It should work.. I did not see any issue here ...unless file is not variable length.
Let us know your findings. |
|
Back to top |
|
|
Vignesh Sid
New User
Joined: 04 Sep 2017 Posts: 43 Location: India
|
|
|
|
Thank you expat and Guptae. Yes the location for the selection did not give me results.
I changed the code as follows and got the desired result.
Code: |
SORT FIELDS=COPY
OUTFIL FNAMES=SORTOUT,INCLUDE=(6,7,CH,EQ,C'NONVSAM'),VTOF,
BUILD=(1:22,26)
|
Thanks again for confirming that the syntax is correct!
Regards,
Viky. |
|
Back to top |
|
|
Garry Carroll
Senior Member
Joined: 08 May 2006 Posts: 1193 Location: Dublin, Ireland
|
|
|
|
I suspect the offset is not allowing for the "A" in VBA - which is the ANSI control character in the first column of the report. Try offset 6 rather than 5 (RDW + ANSI control = 5) for the 'NONVSAM'.
Garry. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
If you are attempting to process the LISTCAT output to extract a data set name, you could also override the output RECFM/LRECL in the LISTCAT step to DCB=(LRECL=80,RECFM=FB..., so you dont have to convert it later on, and you have the required data within those positions. |
|
Back to top |
|
|
|