|
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: 1209
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: 6248
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: 19243
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: 1248
Location: Richfield, MN, USA
|
|
|
|
| esaccy, please see expat's post. |
|
| Back to top |
|
|
|
|
