Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Can we copy VSAM file to sequential file using ICEGENER?

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

New User


Joined: 18 Nov 2005
Posts: 14
Location: Mumbai

PostPosted: Fri May 26, 2006 4:39 pm    Post subject: Can we copy VSAM file to sequential file using ICEGENER?
Reply with quote

Dear all,

Can we copy VSAM file to a sequential file and Vice -versa using ICEGENER?.If so, can anyone provide me with a sample code.

If we cannot ,Is there any efficient method to achive this (other than IDCAMS).

I know that we can do it using SORT ,but it only reduces exception count,but no significant improvement in CPU usage and execution time.

Thanks in Advance.
Back to top
View user's profile Send private message

Vineet

New User


Joined: 14 Sep 2005
Posts: 18

PostPosted: Fri May 26, 2006 4:59 pm    Post subject: VSAM Copy.
Reply with quote

Hi Sangameshwar N,
I am not sure about ICEGENER but there is another utility 'ICEMAN' using this U can copy. Apart from this U can use 'Repro'. For ICEMAN below is code. Remember for LRECL U of teh flat file need to be verified by the Record size of VSAM file.

Thanx
Vinit A.

000014 //STEP1 EXEC PGM=ICEMAN,
000015 // COND=(0,NE)
000016 //SYSOUT DD SYSOUT=*
000017 //SYSPRENT DD SYSOUT=*
000018 //SYSUDUMP DD SYSOUT=*
000019 //SORTIN DD DSN=VT.RN.RN681.COACCTCC.FRONTCB.FILE,
000020 // DISP=SHR
000021 //FIRST50 DD DSN=T.RN.SIT.TRAN.TEST,
000022 // DISP=(NEW,CATLG,DELETE),
000023 // LRECL=150,BLKSIZE=27600,
000024 // DATACLAS=FB
000025 //SYSIN DD *
000026 OPTION COPY
000027 OUTFIL FNAMES=FIRST50,STARTREC=1,ENDREC=10000
000028 //*
Back to top
View user's profile Send private message
sril.krishy

Active User


Joined: 30 Jul 2005
Posts: 182
Location: hyderabad

PostPosted: Fri May 26, 2006 5:34 pm    Post subject:
Reply with quote

Hi,
Just want to add a note,ICEGENER and IEBGENER are same.You can use ICEGENER as the replacement for IEBGENER.


Thank you
Krishy
Back to top
View user's profile Send private message
Sangameshwar N

New User


Joined: 18 Nov 2005
Posts: 14
Location: Mumbai

PostPosted: Fri May 26, 2006 5:54 pm    Post subject: Re: Can we copy VSAM file to sequential file using ICEGENER?
Reply with quote

Thanks Vineet.The code given by you worked.Can u pls provide me the code to copy sequential file to a VSAM file.

But it will be helpful if someone provide me the solution using ICEGENER as well.


Yes Sril ICEGENER can be replaced with IEBGENER with no change in the code, and whenever ICEGENER faces a condition problem control is given back to IEBGENER.
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 Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us