Updating a dataset



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Updating a dataset

Postby samb01 » Fri Feb 10, 2012 7:52 pm

Hello,

i have this dataset

********************************* Top of Data ****
CXRT.SVE.A0407008                       
CXRT.SVE.A0406894                       
CXRT.SVE.A0406943                       
CXRT.SVE.A0406901                       
CXRT.SVE.A0423252     
******************************* Bottom of Data ********************


and i want getting this dataset (a sysin of ADRDSSU)

********************************* Top of Data ******
 INCLUDE(   -                                       
   CXRT.SVE.A8038029                   - 
   CXRT.SVE.A8038003                   - 
   CXRT.SVE.A8037998                   - 
   CXRT.SVE.A8037980                   - 
   CXRT.SVE.A8037972                   - 
    )                                                               
******************************** Bottom of Data *******************



Is it possible with DFSORT ?

Thank's for your help.
samb01
 
Posts: 236
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Updating a dataset

 

Re: Updating a dataset

Postby Frank Yaeger » Fri Feb 10, 2012 11:39 pm

You can use a DFSORT job like the following to do what you asked for:

//S1 EXEC PGM=SORT                               
//SYSOUT DD SYSOUT=*                             
//SORTIN DD *                                     
CXRT.SVE.A0407008                                 
CXRT.SVE.A0406894                                 
CXRT.SVE.A0406943                                 
CXRT.SVE.A0406901                                 
CXRT.SVE.A0423252                                 
//SORTOUT DD SYSOUT=*                             
//SYSIN DD *                                     
  OPTION COPY                                     
  OUTFIL REMOVECC,HEADER1=(' INCLUDE(   -'),     
    BUILD=(4:1,20,40:C'-',80:X),                 
    TRAILER1=(5:')')
/*                             
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: Updating a dataset

Postby samb01 » Mon Feb 13, 2012 9:29 pm

Hello Frank Yaeger .
Thank's but it dosn't work...

Have a look :


 INCLUDE(   -                           
   CXRT.SVE.A                -
   CXRT.SVE.A                -
   CXRT.SVE.A                -
   CXRT.SVE.A                -
   CXRT.SVE.A                -
     )                                             


samb01
 
Posts: 236
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Updating a dataset

Postby enrico-sorichetti » Mon Feb 13, 2012 9:39 pm

are You sure that You are using exactly the same sort control statements as provided ?
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2644
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: Updating a dataset

Postby samb01 » Mon Feb 13, 2012 9:40 pm

Hello,

i found the error,

it works with tha sysin

//SYSIN  DD    *                               
 OPTION COPY                                   
 OUTFIL REMOVECC,HEADER1=(' INCLUDE(   -'),     
   BUILD=(4:1,48,58:C'-',80:X),                 
   TRAILER1=(5:')')                             
//*                                             



Thanks a lot.
samb01
 
Posts: 236
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Updating a dataset

Postby skolusu » Mon Feb 13, 2012 9:40 pm

samb01 wrote:Hello Frank Yaeger .
Thank's but it dosn't work...


A simple " it doesn't work" will not help to solve the problem. Frank's job works fine with the sample data you provided . Frank's job will pick the names from position 1 for a length of 20 bytes . Looks like your names does not start in pos 1 or length exceeds 20 bytes. So Show us your complete sysout along with a sample of input file.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: Updating a dataset

Postby samb01 » Mon Feb 13, 2012 9:46 pm

Ok, sorry, i have some datasets whose the lenght is longer than 20....
So, in the new sysin, i consider the dataset'sname could reach 44 bytes...
samb01
 
Posts: 236
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post