Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to convert VB to FB file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
varalakshmi.G

New User


Joined: 04 Jun 2007
Posts: 55
Location: Hyderabad

PostPosted: Fri Mar 07, 2008 3:22 am    Post subject: How to convert VB to FB file
Reply with quote

Could you please tell me how to convert VB to FB file.
I have one FB input file of length 256. I need to convert this to VB file.

Is there any way to convert VB to VB file. I want to take only specific fields from VB input file.

Lakshmi.G
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri Mar 07, 2008 3:28 am    Post subject:
Reply with quote

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:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

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. 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?

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:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
Back to top
View user's profile Send private message
varalakshmi.G

New User


Joined: 04 Jun 2007
Posts: 55
Location: Hyderabad

PostPosted: Fri Mar 07, 2008 2:02 pm    Post subject:
Reply with quote

While I am converting VB to FB it is giving LRECL/BLKSIZE invalid.

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
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Fri Mar 07, 2008 9:39 pm    Post subject: Re: How to convert VB to FB file
Reply with quote

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.
Back to top
View user's profile Send private message
varalakshmi.G

New User


Joined: 04 Jun 2007
Posts: 55
Location: Hyderabad

PostPosted: Fri Mar 07, 2008 10:11 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Fri Mar 07, 2008 10:25 pm    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Mon Mar 10, 2008 10:23 am    Post subject:
Reply with quote

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).
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Mar 10, 2008 8:32 pm    Post subject:
Reply with quote

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).
Back to top
View user's profile Send private message
varalakshmi.G

New User


Joined: 04 Jun 2007
Posts: 55
Location: Hyderabad

PostPosted: Mon Mar 10, 2008 8:54 pm    Post subject:
Reply with quote

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.

Thank u all for your help.

Thanks,
Lakshmi
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Split file based on comparsion to 2 f... Div Grad DFSORT/ICETOOL 3 Thu Jul 27, 2017 9:16 pm
No new posts Extra character appears in file when ... Balu5491 All Other Mainframe Topics 1 Wed Jul 26, 2017 2:39 pm
No new posts SSH - known_hosts file configuration vasanthz All Other Mainframe Topics 2 Wed Jul 26, 2017 2:10 am
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us