|
View previous topic :: View next topic
|
| Author |
Message |
shie_aguas
New User
Joined: 17 Aug 2006
Posts: 4
Location: Dalian China
|
|
|
|
Hello,
Am new here.
Just wanna seek out some help.
Can anyone pls tell me how to convert RECFM=FB to VB ???
Thanks in advance.
Shie |
|
| Back to top |
|
 |
chiranjeevi_mca
New User
Joined: 19 Feb 2006
Posts: 27
|
|
|
|
Hi,
Its not possible to change FB to VB directly.
for that just create a new file with VB and pass the data to that file.
this is the only option.
bye..
have a nice day |
|
| Back to top |
|
|
shie_aguas
New User
Joined: 17 Aug 2006
Posts: 4
Location: Dalian China
|
|
|
|
Thanks,
A follow up question though, if I have a comma seperated file, which i have defined with a VB record format. Will converting it to FB result to a major impact on the records? |
|
| Back to top |
|
|
shreevamsi
Active User
Joined: 23 Feb 2006
Posts: 305
Location: Hyderabad,India
|
|
|
|
hi,
Your requirement is to convert a FB dataset to VB.
Y don't u copy the dataset thru jcl using SORT and OUTFIL FNAMES=DDname,FTOV
~Vamsi |
|
| Back to top |
|
|
shie_aguas
New User
Joined: 17 Aug 2006
Posts: 4
Location: Dalian China
|
|
|
|
OK, I will try that one.
Thanks so much Shreevamsi....  |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| Can anyone pls tell me how to convert RECFM=FB to VB ??? |
See the "FB to VB conversion" Smart DFSORT Trick at:
www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
| Quote: |
| if I have a comma seperated file, which i have defined with a VB record format. Will converting it to FB result to a major impact on the records? |
It's not clear what you're asking. "Major impact" in terms of what? Please explain in more detail what you want to know. |
|
| Back to top |
|
|
shie_aguas
New User
Joined: 17 Aug 2006
Posts: 4
Location: Dalian China
|
|
|
|
Hi Frank,
My problem is solved now, and I used SORT to convert FB to VB recfm.
Though Im still curious with the CSV record format conversion.
What I meant about "Major Impact" is that, would it affect the alignment, re-align the fields or something like that?
Thanks in advance,
Shie |
|
| Back to top |
|
|
SBMF390
New User
Joined: 27 Jul 2006
Posts: 9
|
|
|
|
Hi,
we have one more method,
Sysut1 -> old file VB
Sysut2 -> New file FB
Use iebgener,
//SYSIN DD *
GENERATE MAXFLDS=1
RECORD FIELD=(Record length)
/* |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| What I meant about "Major Impact" is that, would it affect the alignment, re-align the fields or something like that? |
An RDW would be added to each record, so the data would start at position 5 instead of at position 1. If you used VLFILL, the records could also have different lengths. |
|
| Back to top |
|
|
cheetz007
New User
Joined: 10 Aug 2006
Posts: 23
|
|
|
|
On a similar subject, I'm trying to "merge" 2 files together. It's not really a merge, what I want to do is create a file which has fileA followed by fileB always in that order. The trouble is, fileA is FB 1691 and fileB is VB 833. I need the output to be FB 1691.
Is DFSORT a candidate for doing this? I have been trying to figure out how to do it with IEBGENER, but I can't seem to get it working, possibly because of the RDW you mentioned in your last post. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
cheetz007,
Here's a DFSORT/ICETOOL job that will do what you asked for. Be sure to use MOD for the //OUT data set.
| Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN1 DD DSN=... input file1 (FB/1691)
//IN2 DD DSN=... input file2 (VB/833)
//OUT DD DISP=MOD,DSN=... output file (FB/1691)
//TOOLIN DD *
COPY FROM(IN1) TO(OUT)
COPY FROM(IN2) USING(CTL1)
/*
//CTL1CNTL DD *
OUTFIL FNAMES=OUT,VTOF,OUTREC=(5,829,1691:X)
/*
|
|
|
| Back to top |
|
|
cheetz007
New User
Joined: 10 Aug 2006
Posts: 23
|
|
|
|
| Thanks Frank, that's exactly what I was looking for - you truly are a Guru! |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Glad I could help. |
|
| Back to top |
|
|
BODART_THIERRY
New User
Joined: 20 Mar 2006
Posts: 2
|
|
|
|
Hello,
I have successfully used the FTOV parameter in this way
| Code: |
//ULBA1S1 EXEC PPSORT
//SORTIN DD DISP=SHR,
// DSN=L.G42661.BMCUNLD.ULPY09T.FXOPL
//SORTOUT DD DSN=L.G42661.BMCUNLD.ULPY09T.TESTL,
// DISP=(,CATLG,DELETE),UNIT=SYSDA,
// DCB=(LRECL=5000,RECFM=V),
// SPACE=(350,(46,9),RLSE),AVGREC=K
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FNAMES=SORTOUT,FTOV
/*
|
|
|
| Back to top |
|
|
|
|
