Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Converting Record Format FB to VB

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
shie_aguas

New User


Joined: 17 Aug 2006
Posts: 4
Location: Dalian China

PostPosted: Thu Aug 17, 2006 9:25 am    Post subject: Converting Record Format FB to VB
Reply with quote

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
View user's profile Send private message

chiranjeevi_mca

New User


Joined: 19 Feb 2006
Posts: 27

PostPosted: Thu Aug 17, 2006 9:45 am    Post subject:
Reply with quote

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
View user's profile Send private message
shie_aguas

New User


Joined: 17 Aug 2006
Posts: 4
Location: Dalian China

PostPosted: Thu Aug 17, 2006 9:51 am    Post subject:
Reply with quote

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
View user's profile Send private message
shreevamsi

Active User


Joined: 23 Feb 2006
Posts: 305
Location: Hyderabad,India

PostPosted: Thu Aug 17, 2006 10:13 am    Post subject: Re: F1 Pls... Converting Record Format FB to VB
Reply with quote

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
View user's profile Send private message
shie_aguas

New User


Joined: 17 Aug 2006
Posts: 4
Location: Dalian China

PostPosted: Thu Aug 17, 2006 10:16 am    Post subject:
Reply with quote

OK, I will try that one.

Thanks so much Shreevamsi.... icon_biggrin.gif
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: Thu Aug 17, 2006 8:45 pm    Post subject:
Reply with quote

Quote:
Can anyone pls tell me how to convert RECFM=FB to VB ???


See the "FB to VB conversion" Smart DFSORT Trick at:

http://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
View user's profile Send private message
shie_aguas

New User


Joined: 17 Aug 2006
Posts: 4
Location: Dalian China

PostPosted: Fri Aug 18, 2006 8:41 am    Post subject:
Reply with quote

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
View user's profile Send private message
SBMF390

New User


Joined: 27 Jul 2006
Posts: 9

PostPosted: Fri Aug 18, 2006 12:48 pm    Post subject: Re: Converting Record Format FB to VB
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Fri Aug 18, 2006 8:16 pm    Post subject:
Reply with quote

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
View user's profile Send private message
cheetz007

New User


Joined: 10 Aug 2006
Posts: 23

PostPosted: Wed Aug 30, 2006 9:50 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Wed Aug 30, 2006 10:13 pm    Post subject:
Reply with quote

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
View user's profile Send private message
cheetz007

New User


Joined: 10 Aug 2006
Posts: 23

PostPosted: Thu Aug 31, 2006 2:25 pm    Post subject:
Reply with quote

Thanks Frank, that's exactly what I was looking for - you truly are a Guru!
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: Thu Aug 31, 2006 9:11 pm    Post subject:
Reply with quote

Glad I could help.
Back to top
View user's profile Send private message
BODART_THIERRY

New User


Joined: 20 Mar 2006
Posts: 2

PostPosted: Fri Sep 08, 2006 7:32 pm    Post subject: Re: Converting Record Format FB to VB
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fetch Previous month & year in MM... girishb2 DFSORT/ICETOOL 3 Thu Sep 21, 2017 9:54 pm
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts FTP data transfer from PC to Mainfram... AJAYREDDY All Other Mainframe Topics 8 Wed Aug 23, 2017 9:59 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us