Changing value in a Huge dataset



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

Changing value in a Huge dataset

Postby samb01 » Fri Jul 10, 2015 6:25 pm

Hello,

i have a big dataset i can't edit (i have the message "browse substitute").

This is the dsorg :

Dsorg  Recfm  Lrecl  Blksz
--------------------------
 PS    VB     27994  27998



i would like to change a value without editing it because i can't.

So i used this JCL :

//SCANREP   EXEC PGM=IKJEFT01                                           
//SYSTSPRT  DD SYSOUT=*                                                 
//SYSTSIN   DD *                                                       
EDIT 'FCGTD.GCFTT1' DATA NONUM                             
CHANGE * 999999  'BHTRE ERE','Renteuee  Vgère Diffé' ALL           
CHANGE * 999999  'VGNT','Compte ge bftete Euros' ALL   
END SAVE                                                               



But it doesn't work, i have this message :

READY
EDIT 'FCGTD.GCFTT1' DATA NONUM
IKJ52336I 27994 INVALID LINE VALUE FOR DATA DATA SET
READY



Is it possible to do it by dfsort ?

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

Re: Changing value in a Huge dataset

Postby Magesh23586 » Fri Jul 10, 2015 7:07 pm

You can use FINDREP to replace a string by another in DFSORT.

Regards,
Magesh
Magesh23586
 
Posts: 36
Joined: Sat Jul 05, 2014 5:36 pm
Has thanked: 1 time
Been thanked: 3 times

Re: Changing value in a Huge dataset

Postby steve-myers » Sat Jul 11, 2015 12:51 pm

I think, though I'm not certain, the IKJ52336I 27994 INVALID LINE VALUE FOR DATA DATA SET message is telling you TSO EDIT cannot process the data set because its LRECL is too large.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: Changing value in a Huge dataset

Postby BillyBoyo » Sat Jul 11, 2015 2:17 pm

steve-myers is correct, although looking the message up gives little further information.

Why have you got DATA in your EDIT command, and what does it do for you (other than disallow the LRECL of your data set)?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Changing value in a Huge dataset

Postby steve-myers » Sat Jul 11, 2015 8:22 pm

BillyBoyo wrote:steve-myers is correct, although looking the message up gives little further information.

Why have you got DATA in your EDIT command, and what does it do for you (other than disallow the LRECL of your data set)?
The DATA in the command line specifies the data type of the data set. In terms of the TSO command line, it's a keyword, but it's required by EDIT. The DATA keyword implies the data set contains generic data, not some language specific data like PLI, FORT, or ASM. It also implies a data set name suffix when the data set name is not fully qualified.

E X DATA implies you are using data set userid.X.DATA

There's a lot of junk hanging around from early TSO that has either disappeared or never really got implemented. One of these ideas was language syntax checkers that could be used within EDIT. There was some activity in this area in the 1970s, but it has all disappeared, usually because it was too clumsy or too limited. After SPF appeared there was no real interest in enhancing the command line portion of TSO. About the only language oriented syntax checker that has survived are the JCL check products from at least 2 vendors if my memory is correct, and these operate with ISPF, not the command line.

As billy-boyo says, the DATA keyword limits the record size to 255. There is a table in TSO/E Command Reference (which I just discovered) that discusses this better than I can here, but you'll notice that all these data set types limit you to 255 bytes or less. This appears to be a generic restriction in EDIT.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post