Frank Yaeger DFSORT Moderator Joined: 15 Feb 2005 Location: San Jose, CA Posted: Fri Mar 07, 2008 3:28 am Post subject: Quote: Could you please tell me how to convert VB to FB file. You can use the technique discussed in the 'VB to FB conversion' Smart DFSORT Trick at: Quote: Is there any way to convert VB t VB file.I want to take only specific fields from VB input file. You can do it with a DFSORT INREC, OUTREC or OUTFIL statement.

1. Upload Audio File To Fb

The following JCL and DFSORT control statements convert a VB data set with LRECL=104 to an FB data set with LRECL=100: //VBFB JOB A92,PROGRAMMER. The following JCL and DFSORT control statements convert a VB data set with LRECL=104 to an FB data set with LRECL=100: //VBFB JOB A92,PROGRAMMER.

Describe what you want to do in more detail and I'll tell you how. What is the LRECL of your input file? Which fields do you want in the output file?

JCL & VSAM: While converting the VB (input) file to FB file,the SUM FIELDS=NONE is not working(ie Duplicates aren't removed) The Sysin card goes.

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through 'z/OS DFSORT: Getting Started'. It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from: varalakshmi.G New User Joined: 04 Jun 2007 Location: Hyderabad Posted: Fri Mar 07, 2008 2:02 pm Post subject: While I am converting VB to FB it is giving LRECL/BLKSIZE invalid.

Upload Audio File To Fb

I am using SYNCSORT and my Control card is like OPTION COPY,VLSHRT OUTFIL FNAMES=FBFILE,VTOF,OUTREC=(5,252). Could somebody tell me the problem. Thanks in advance Lakshmi Alissa Margulies SYNCSORT Support Joined: 25 Jul 2007 Location: USA Posted: Fri Mar 07, 2008 9:39 pm Post subject: Re: How to convert VB to FB file Quote: I have one FB input file of length 256. I need to convert this to VB file. Quote: While I am converting VB to FB it is giving LRECL/BLKSIZE invalid. I am using SYNCSORT and my Control card is like Code: OPTION COPY,VLSHRT OUTFIL FNAMES=FBFILE,VTOF,OUTREC=(5,252).

Are you sure you have the correct RECFM of the input data. These statements seem to conflict.

Please verify you are converting VB data to FB and not FB data to VB. Varalakshmi.G New User Joined: 04 Jun 2007 Location: Hyderabad Posted: Fri Mar 07, 2008 10:11 pm Post subject: Hi I am converting VB to FB file.My input file is VB and length 256. Could you tell me how to solve this. Thanks, Lakshmi Alissa Margulies SYNCSORT Support Joined: 25 Jul 2007 Location: USA Posted: Fri Mar 07, 2008 10:25 pm Post subject: At first glance, your control cards appear fine.

Are you getting WER197A, WER200A, or some other error message? Please post your JCL (not just the control cards) along with the complete text of the error message produced. Also, which release of SyncSort are you running? Mkk157 Active User Joined: 17 May 2006 Posted: Mon Mar 10, 2008 10:23 am Post subject: Change the OUTREC field from OUTREC=(5,252). To OUTREC=(5,256) As the LRECL of your file is 256.

Now the sort card is like this: OPTION COPY,VLSHRT OUTFIL FNAMES=FBFILE,VTOF,OUTREC=(5,256). Alissa Margulies SYNCSORT Support Joined: 25 Jul 2007 Location: USA Posted: Mon Mar 10, 2008 8:32 pm Post subject: mkk157 wrote: Change the OUTREC field from OUTREC=(5,252). To OUTREC=(5,256) As the LRECL of your file is 256.

This will cause the following error: Code: WER230A OUTREC FIELD OUTSIDE RANGE The original LRECL of 256 includes the 4 byte RDW of the VB file. When converting to FB, and stripping off the 1st 4 bytes, you need to subtract that from the LRECL.

Hence, the output LRECL is 252. If the OP wanted to include the RDW in the output, then it would be OUTREC=(1,256) not (5,252). Varalakshmi.G New User Joined: 04 Jun 2007 Location: Hyderabad Posted: Mon Mar 10, 2008 8:54 pm Post subject: Hi All, Now it is working fine by giving control card as OPTION COPY,VLSHRT OUTFIL FNAMES=FBFILE,VTOF,OUTREC=(5,252) END The problem is the output file is already existed one.Just I gave DISP as (OLD,CATLG,CATLG),but the attributes of this file is different that's y it is giving problem.

Serial key for Office 2003 Standard (Basic) Edition can be found and viewed here. We have the largest serial numbers data base. Nov 10, 2013 I purchased a new OEM copy of MS Office Professional 2003. And activate without entering product key?

Thank u all for your help. Thanks, Lakshmi:::: - All times are GMT + 6 Hours Page 1 of 1 Search our Forum.

IBM MAINFRAME: Converting VB to FB using SYNCSORT -:::: Author Message kirthika New User Joined: 27 Apr 2006 Posted: Tue Mar 06, 2007 8:09 pm Post subject: Converting VB to FB using SYNCSORT While converting the VB (input) file to FB file,the SUM FIELDS=NONE is not working(ie Duplicates aren't removed) The Sysin card goes like this SORT FIELDS=COPY INCLUDE COND=(60,2,CH,EQ,C'AN', OR,60,3,CH,EQ,C'ANI') SUM FIELDS=NONE OUTFIL FNAMES=FB1, VTOF,OUTREC=(31,19) SUM FIELDS=NONE works for FB to FB /VB to VB. Can anyone suggest a way to do this? (I want this to work in the same step).

Cpuhawg Active User Joined: 14 Jun 2006 Location: Jacksonville, FL Posted: Tue Mar 06, 2007 8:33 pm Post subject: Re: VB to FB using SYNCSORT Here are some same JCL for converting VB to FB using SYNCSORT: In SYNCSORT, you can convert variable to fixed by coding the CONVERT parameter on the OUTREC control cards: Code: //S4SORT EXEC PGM=SORT //SORTIN DD DSN=INPUT.VARIABLE.FILE,DISP=SHR All times are GMT + 6 Hours Page 1 of 1 Search our Forum.