Problem while putting condition in a VB file using SORT

nivedita.mukherjee16 · New User Joined: 10 Jun 2011 Posts: 13 Location: Kolkata

Hi All,

I am trying to write a SORT where I need to select few records depending on record type and name from a VB file into a FB file

The record layout of my file is:
1 FILE1,
3 RECTYP CHAR (03),
3 FILLER1 CHAR (37),
3 NAME CHAR (04);

If I first convert the file to FB then try to inculde the condition it is wrorking fine

//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(5,3,CH,EQ,C'XYZ'),
OUTREC FILEDS=(5,1496,1500:X),CONVERT
//
and then use

//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(41,4,CH,EQ,C'ABCD')
//

But if I try to put the NAME condition while converting the VB to FB it is giving me error as

SORTOUT INCLUDE/OMIT FIELD BEYOND RECORD

//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(5,3,CH,EQ,C'XYZ',AND,45,4,CH,EQ,C'ABCD'),
OUTREC FILEDS=(5,1496,1500:X),CONVERT
//

Please suggest how can I solve this problem.

Thanks,
Nivi

Bill Woodger · Posted: Mon Dec 05, 2011 7:07 pm

The INCLUDE is processed before the OUTREC.

You have records shorter than your key (presumably the second element).

Your OUTREC is extending all records to a fixed length, your INCLUDE seperately after that does not cause you a problem.

The curious thing is that it would imply you have short XYZ record(s), of which you are presumably unaware.

gylbharat · Posted: Mon Dec 05, 2011 8:14 pm

Please post the error message.

Nic Clouston · Posted: Mon Dec 05, 2011 9:19 pm

Gylbharat posted:

gcicchet · Posted: Tue Dec 06, 2011 7:46 am

Hi,

it would help if you cut and paste your job and use Code so it becomes readable.

This statement has a comma at the end which would give an error

nivedita.mukherjee16 · New User Joined: 10 Jun 2011 Posts: 13 Location: Kolkata

Hi,

Thanks a lot Gerry!!
It is working now.
It will really be helpful if you can explain what does this parm field do or
suggest any manual where I can get informations like this.

Thanks again
Nivi

gcicchet · Posted: Tue Dec 06, 2011 10:46 am

Hi,

a search would have given plenty of hits

ibmmainframes.com/viewtopic.php?t=49970&highlight=vltesti

If you have SYNCSORT installed then you should obtain a copy of the manual.

Gerry

nivedita.mukherjee16 · New User Joined: 10 Jun 2011 Posts: 13 Location: Kolkata

Thanks again Gerry!!!!!
I went through them

What I obtained is:

dick scherrer · Posted: Tue Dec 06, 2011 11:33 am

Hello,

Now that you have the info, suggest you run a few experiments and learn what really happens.

What you have posted looks rather clear. Where are you stuck?

nivedita.mukherjee16 · New User Joined: 10 Jun 2011 Posts: 13 Location: Kolkata

Hi,

I have got another query:
I am trying to create a trailer record using the following SORT CARD

nivedita.mukherjee16 · New User Joined: 10 Jun 2011 Posts: 13 Location: Kolkata

sorry to all,

I got my fault

I have missed to mention the OUTFIL

dick scherrer · Posted: Wed Dec 07, 2011 10:32 am

Good to hear you found it - thank you for letting us know

d

rakesha.hg · Posted: Mon Jan 02, 2012 5:10 pm

This is my personal opinion, suggest we put information regarding VLTESTI = 1 & 2 in sticky part of this forum .... from the posts i read about syncsort involving VB files, Parm option VLTESTI seems to be the answer most of the times.

Moderators out there take your call.

dick scherrer · Posted: Tue Jan 03, 2012 11:52 am

Hello,

If you post what you would like to see as the content of this sticky, we would review this and split your contribution to a new Sticky.