IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Can we copy VSAM file to sequential file using ICEGENER?


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
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
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: 20

PostPosted: Fri May 26, 2006 4:59 pm
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: 183
Location: hyderabad

PostPosted: Fri May 26, 2006 5:34 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top