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

Add numeric 1 at the end of the dataset


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Mon Dec 04, 2006 10:35 am
Reply with quote

Hi All,

Please tell me how to insert numeric 1 at the end of record.

I/P file length 80

I tried this

INREC FIELDS= (1,80,C'1')

but in this case it is treating 1 as a character & I m not able to do SUM operation on 81st byte.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Mon Dec 04, 2006 9:58 pm
Reply with quote

What do you mean by "numeric 1"? C'1' is X'F1' which is a valid ZD value of +1. You can SUM that as a ZD value. If you mean something else by "numeric 1" other than a ZD +1, tell us what you mean. Or explain what you mean by "I'm not able to do SUM operation on 81st byte".
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Tue Dec 05, 2006 9:40 am
Reply with quote

Hi Frank,

Sorry for not making my prev post clear l

INREC FIELDS=(1,80,C'1')
SORT FIELDS=(10,3,CH,A)
SUM FIELDS=(80,1,ZD)

It is giving me SOC7 in that case.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Dec 05, 2006 9:30 pm
Reply with quote

You have 1,80,C'1' for INREC which puts the '1' (X'F1') in position 81, but you have 80,1,ZD for SUM which is summing on position 80 rather than position 81. You need 81,1,ZD for SUM:

Code:

  INREC FIELDS=(1,80,C'1') 
  SORT FIELDS=(10,3,CH,A)   
  SUM FIELDS=(81,1,ZD)     


Note that if you want to ensure that the SUM in 81 is printable, you should also use:

Code:

   OPTION ZDPRINT
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Tue Dec 05, 2006 9:32 pm
Reply with quote

HI Frank,

Thanks alot my mistake..
Sorry to bug u so much
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 FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts Reading dataset in Python - New Line ... All Other Mainframe Topics 22
Search our Forums:

Back to Top