Convert VBA file to FB!

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;

expat · Posted: Mon Dec 03, 2018 2:02 pm

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

guptae · Posted: Mon Dec 03, 2018 2:05 pm

Hello Viky,

It should work.. I did not see any issue here ...unless file is not variable length.

Let us know your findings.

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.

Garry Carroll · Posted: Mon Dec 03, 2018 3:12 pm

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.

Arun Raj · Posted: Mon Dec 03, 2018 6:46 pm

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.