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
 
Changing only first two lines in a file

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

New User


Joined: 20 Feb 2008
Posts: 17
Location: India

PostPosted: Mon Jun 30, 2008 9:30 am    Post subject: Changing only first two lines in a file
Reply with quote

Hi,

I have the following record structure being generated from an unload job which is to be used in a load job.

LOAD DATA REPLACE LOG NO INDDN SYSREC00
- INTO TABLE PSSA.PS_SDK_INSTALL
( column definitions)

But for the load job I need the following record structure

LOAD DATA RESUME YES LOG NO NOCOPYPEND ENFORCE NO
INDDN SYSREC00
INTO TABLE
PSDBDB.<tablename>
(column definitions same as in above record)

Will I be able to do this using ICETOOL? Could someone help me in building the INREC and OUTREC?Thanks!
Back to top
View user's profile Send private message

Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Tue Jul 01, 2008 12:10 am    Post subject:
Reply with quote

Bhavanas,

The following JCL will give you the desired results

Code:

//STEP0100 EXEC PGM=ICEMAN                                           
//SYSOUT   DD SYSOUT=*                                               
//SORTIN   DD *                                                     
LOAD DATA REPLACE LOG NO INDDN SYSREC00                             
----+----1----+----2----+----3----+----4----+----5----+----6----+----
- INTO TABLE PSSA.PS_SDK_INSTALL                                     
 BLAH BLAH1                                                         
 BLAH BLAH2                                                         
 ABCDEFG                                                             
//SORTOUT  DD SYSOUT=*                                               
//SYSIN    DD *                                                     
  SORT FIELDS=COPY                                                   
  OUTFIL IFOUTLEN=80,                                               
  IFTHEN=(WHEN=INIT,OVERLAY=(81:SEQNUM,8,ZD)),                       
  IFTHEN=(WHEN=(81,8,ZD,EQ,1),                                       
  BUILD=(C'LOAD DATA RESUME YES LOG NO NOCOPYPEND ENFORCE NO',80:X)),
  IFTHEN=(WHEN=(81,8,ZD,EQ,2),                                       
  BUILD=(C'INDDN SYSREC00',/,C'INTO TABLE',/,                       
         C'PSDBDB.',19,18,80:X))                                     
//*                                                                 


The output from this job is

Code:

LOAD DATA RESUME YES LOG NO NOCOPYPEND ENFORCE NO   
INDDN SYSREC00                                     
INTO TABLE                                         
PSDBDB.PS_SDK_INSTALL                               
 BLAH BLAH1                                         
 BLAH BLAH2                                         
 ABCDEFG                                           


Hope this helps...

Cheers
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 Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts Garbage on output file Hervey Martinez SYNCSORT 4 Wed Sep 27, 2017 12:50 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 11 Fri Sep 22, 2017 11:35 pm

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