MVSFORUMS.com

abracadabra · Posted: Fri Feb 20, 2004 2:04 am Post subject: FB to VB

Does anybody have the batch job to convert a FB tape dataset to a VB dataset?

Thanks
_________________
Cheers!

mfjin · Beginner Joined: 26 Apr 2003 Posts: 94 Topics: 17

DFSORT can. Check out the FTOV feature of DFSOrt.

abracadabra · Posted: Fri Feb 20, 2004 2:40 am Post subject:

Hi,

Thanks for you response. Can you give me some link for reference? I have never used this before.

Thanks
_________________
Cheers!

abracadabra · Posted: Fri Feb 20, 2004 3:09 am Post subject:

I found some info. Thought I would sgare with all of you

Converting Fixed Length Records to Variable Length Records

A new feature to convert Fixed Length records to Variable Length records is now available in DFSort. To use the feature you must be using Release 14 of DFSort with PTF UQ99331. To convert Fixed to Variable length you need to specify FTOV on the OUTFIL statement. There is also an equivalent new option VTOF, which converts variable to fxed length - this is just an alias for the CONVERT option described above.

Otherwise you will need to find another way. You could try using IDCAMS REPRO or IEBGENER, or some file utility like FileAid, or Easitrieve.
_________________
Cheers!

Frank Yaeger · Posted: Fri Feb 20, 2004 11:13 am Post subject:

You can use DFSORT's FTOV feature to convert FB to VB. The FTOV feature has been available in DFSORT since March, 2002 (PTF UQ99331). For more information on this feature, see the "FB to VB conversion" Smart DFSORT Trick at:

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

You can use DFSORT's VTOF (or CONVERT) feature to convert VB to FB. For more information on this feature, see the "VB to FB conversion" Smart DFSORT Trick at:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

Mike Chantrey · Posted: Tue Feb 24, 2004 10:20 am Post subject:

Compuware's FILEAID product generally does a good job copying between different file formats.

kolusu · Posted: Mon Mar 01, 2004 2:05 pm Post subject:

abracadabra,

You can also use IEBGENER and IDCAMS which are standard IBM utilities for creating an VB output from FB Input.

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu