Include cond for VB file.

passion_sujesh · Posted: Sun Sep 30, 2012 12:00 am

Hi,
I am trying to extract records from a VB file which has different record type. I need to extract the reference number, if the product code is 'xxxx'. The product code is in different position for each record type.

The file has three record types.
If record type is 'A', the reference number starts from 26 and is 5 byte long. The product code starts from 31 and is 4 bytes.
If record type is 'B', the reference number starts from 40 and is 5 byte long. The product code starts from 45 and is 4 bytes.
I need not reffer other record types.

the record type is in position 25 and is 1 byte.
The output should be a FB file and record length should be 9 bytes.

I tried the following sort card, but the include condition does not work properly. If i remove the include condition, i get the formated records for all the records in file. If i have the include condition i get empty file.

dick scherrer · Posted: Sun Sep 30, 2012 12:14 am

Hello,

Did you remember to increase the positions by 4 to allow for the RDW?

passion_sujesh · Posted: Sun Sep 30, 2012 12:19 am

Yes. I had added +4 bytes, for all the positions.

dick scherrer · Posted: Sun Sep 30, 2012 12:29 am

Hello,

Suggest you post a few of the records using HEX ON.

Bill Woodger · Posted: Sun Sep 30, 2012 3:05 am

passion_sujesh,

Have a look at this, which describes DFSort order of processing.

It does not matter where you locate your INCLUDE statement, DFSort will process it where it always does.

So, at the time your INCLUDE was processed, the position/length you are using contained completely different data.

Try with INCLUDE= on OUTFIL instead.

dick scherrer · Posted: Sun Sep 30, 2012 7:35 am

Hi Bill,

Good catch

After checking the data, i was going to work thru the code

d

passion_sujesh · Posted: Sun Sep 30, 2012 8:16 am

Thanks bill.
I shall try this and will let you know if it works.

passion_sujesh · Posted: Tue Oct 02, 2012 2:11 am

Thanks Bill.
I used include in OUTFIL, and it works fine. :-)

dick scherrer · Posted: Tue Oct 02, 2012 7:17 pm

Good to hear it is working - thank you for letting us know

d

Skolusu · Posted: Tue Oct 02, 2012 10:06 pm

A better approach would be to filter the records with an INCLUDE cond and build only required fields.