|
View previous topic :: View next topic
|
| Author |
Message |
The Dark Knight
New User
Joined: 16 Feb 2010
Posts: 3
Location: India
|
|
|
|
Is it possible to add two / more numbers via JCL itself...... Sply via Syncsort ?
Please throw light on this..
Thanks |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
| Is it possible to add two / more numbers via JCL itself |
No. JCL does nothing but run programs. These programs can be utilities such as Syncsort, IDCAMS, IEBGENER, or application programs but JCL will not do anything by itself. |
|
| Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
| The Dark Knight wrote: |
| Is it possible to add two / more numbers via JCL itself...... |
Yes, probably (assuming 'JCL' refers to a utility rather than a programming language)..... 
| Quote: |
| Sply via Syncsort ? |
"Sply"?
What Robert Sample said, check your Syncsort manual...... |
|
| Back to top |
|
|
viveksurya
New User
Joined: 08 Jun 2009
Posts: 36
Location: Bangalore
|
|
|
|
Please check the manual.
SYNCSORT - "SUM FIELDS" can be used to add value at particular coulmns.
DFSORT - "SUM FIElDS", TOT function can be used for the same. |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| Quote: |
| Is it possible to add two / more numbers via JCL itself...... Sply via Syncsort ? |
Please be specific.
Do you want to add two\more numbers present in same record?
or do u want to add numbers present at specific position in the file based on some key in the record?
It would be nice if you could show us sample records and required output for it. (Use code tag)
People here then will be able to give more accurate answers |
|
| Back to top |
|
|
The Dark Knight
New User
Joined: 16 Feb 2010
Posts: 3
Location: India
|
|
|
|
Thanks all for your replies.
My query was,
Adding two numbers in the position 1 to 3 & 5 to 7 and writing the output in same or random pos.
|
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Experiment with the below sort-card:
| Code: |
//SYSIN DD *
OPTION COPY
OUTREC FIELDS=(1,3,ZD,ADD,5,3,ZD,LENGTH=4) |
|
|
| Back to top |
|
|
|
|
