IBM Mainframe Forum

Hi,

We are using SYNCSORT FOR Z/OS 1.2.2.1R. I am running below given job to pull the generations from a GDG after listing them using the IDCAMS. I am using SORT with include condition but it fails.........



After running the above job it fails with the below error:



I have really NOT understood few things here.....I don't know why it shows 125 as LRECL for SORTIN, whereas I used 80 in STEP01. Also, it shows VBA as Record Format whereas it should have been FB.

Please help.

Thanks.

Hello,

I believe idcams does what it wants with the sysprint - it ignores your parameters because it "knows" how it wants to format the printout.

It may help if you change the &temp1 dataset to a "real" dataset so that you can view the content.

You should see some "short" records in the printout which are the cause of the "WER250A INCLUDE/OMIT FIELD BEYOND RECORD " error. There will also be a "carriage control" byte as the first byte in the file that you will need to allow for.

Alissa, would you please provide me a solution to this problem?

Thanks.

ranga_subham wrote:Alissa, would you please provide me a solution to this problem?

Thanks.

Sorry for the delayed response - I was out of the office last week.

I am assuming that your default option is VLTESTI=0, which instructs SyncSort to terminate if a record does not completely contain all INCLUDE or OMIT fields... hence, the WER250A.

You can override this value at runtime by specifying PARM='VLTESTI=1' or PARM='VLTESTI=2' on the EXEC statement.

As documented in the SyncSort for z/OS Programmer's Guide:

When VLTESTI=1 is specified, a record that does not completely contain all INCLUDE/OMIT fields is treated as having failed the comparison. SyncSort will omit the record if INCLUDE is being used or include the record if OMIT has been specified.

When VLTESTI=2 is specified, SyncSort will treat comparisons to fields not completely
contained within the record as false and decide a record’s status for inclusion or omission
from fields that are available. If all fields are not present, the record will be processed as
having failed the comparison. SyncSort will omit the record if INCLUDE is being used or
include the record if OMIT has been specified.

Hope this helps. Let me know if you have any further questions regarding ths issue.

Hi, Alissa.

Excellent tip.....I was able to copy the input to output after using PARM='VLTESTI=1' or PARM='VLTESTI=2'. It worked.

Now, I have only one complaint. Though PARM='VLTESTI=1' was specified, It does not allow me to write the output to a 80 byte output file with record format of FB. So, I had to change the output file as follows:



I think, will have to use some mechanism to convert this VBA file to FB file of 80 bytes

Any tips please?

Thanks.

So you want to truncate the end of each record, only writing out the first 80 bytes of data?
If this is correct, then you can specify the following:


Also, do not code the DCB in the JCL for SORTOUT.

Give this a try and let me know if you run into any problems.

Alissa, thank you very much for your quick reply.

It produced FBA file but maintained LRECL of 80. Shouldn't it be FB file?

Thanks.

Since SORTIN was VBA, your converted SORTOUT will be FBA. If you want SORTOUT to be FB, then code DCB=(RECFM=FB) on the SORTOUT DD statement. That should give you the desired results. Let me know if you still have any questions about this.

Wow.

The coding of DCB with RECFM of FB has solved the problem. Thank you very much Alissa.

Bye.