View previous topic :: View next topic
|
Author |
Message |
royalchm
New User
Joined: 15 Nov 2007 Posts: 29 Location: Bangalore
|
|
|
|
How to change the record format of a file from VB to FB?. Please let me know the TSO commands otherwise please explain the possible ways.
Thanks,
HKR |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello Hari,
I am nt sure abt TSO command but it can be done by Sort, iebcopy etc. |
|
Back to top |
|
|
royalchm
New User
Joined: 15 Nov 2007 Posts: 29 Location: Bangalore
|
|
|
|
Hi guptae,
Please let me know the codes. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
royalchm wrote: |
Hi guptae,
Please let me know the codes. |
WRONG The idea of interview questions is for you to give your answer NOT to demand code.
Topic moved to relevant forum. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
If you'r not sure, search the JCL or DFSORT/ICETOOL part of the Forum on "VTOF" -- you'll get enough examples to work with. |
|
Back to top |
|
|
deepthimadhu
New User
Joined: 03 Mar 2009 Posts: 12 Location: Trivandrum
|
|
|
|
VTOF option of OUTFIL helps you to convert VB records to FB records |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
How to change the record format of a file from VB to FB?. |
If i understand the question (and i may misunderstand), you can make a copy with a different format, but you won't change the format of the original file. |
|
Back to top |
|
|
esaccy Currently Banned New User
Joined: 19 Feb 2005 Posts: 22
|
|
|
|
Here is the answer with an example.
SORT FIELDS = (7,8,CH,A)
OUTFIL FNAMES= FB1,VTOF,OUTREC=(5,76),VLFILL=C'*'
By default space will be padded for records that is short of LRECL 80.Since VLFILL=C'*' is given ,in this case * will be padded. |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
esaccy, please see expat's post. |
|
Back to top |
|
|
|