Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

 Performing arithmetic on input field Goto page 1, 2  Next
Author Message

Active User

Joined: 06 Jun 2009
Posts: 113
Location: UK

Posted: Tue Dec 06, 2016 8:04 pm    Post subject: Performing arithmetic on input field

Hi,

I like to apply arithmetic to input data.

 Code: 987654321

My Input record

 Code: 9 (2) + 8 + 7(2) + 6 + 5(2) + 4 + 3(2) + 1
Multiplying every alternate digit with 2, starting from left.
 Code: 18 + 8 + 14 + 6 + 10 + 4 + 6 + 1

 Code: 67 * 9
Multiplying final sum with 9
 Code: 603
Expected output record.

Can someone please suggest what reformatting functions I should use to get expected output. I don't think EDIT allows to apply arithmetic operation.

Thanks,

Bill Woodger

Moderator Emeritus

Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

 Posted: Tue Dec 06, 2016 8:41 pm    Post subject: Reply to: Performing arithmetic on input field I opened a DFSORT Application Programming Guide (I used 2.1) PDF and used the PDF-reader to search for 'mul,' (quotes not needed for the search) and readily located several examples of the use of multiple arithmetic operands.

Active User

Joined: 06 Jun 2009
Posts: 113
Location: UK

Posted: Wed Dec 07, 2016 3:27 pm    Post subject: Reply to: Performing arithmetic on input field

Thanks Bill. I was expecting this reply.
I have 2012 version of DFSORT Application Programming Guide, I can't see any example for multiplication there.

I did a small test.
 Code: //STEP001  EXEC PGM=SORT    //SORTIN   DD *              123                          //SORTOUT  DD SYSOUT=*      //SYSIN    DD *                OPTION COPY                  OUTREC FIELDS=(3,MUL,1,3) //SYSOUT   DD SYSOUT=*      //SYSUDUMP DD SYSOUT=*

3 x 123 = 369
and it gives error:

 Code: ICE000I 1 - CONTROL STATEMENTS FOR 5650-ZOS, Z/OS DFSORT V2R1  - 09:47 ON WED DEC 07, 2016 -             OPTION COPY                                                           00130000              OUTREC FIELDS=(3,MUL,1,3)                                                                                     £                                                              ICE007A E SYNTAX ERROR

Do I need to use Mn, EDIT, or EDxy parameter always with MUL?

Thanks.

Active User

Joined: 06 Jun 2009
Posts: 113
Location: UK

Posted: Wed Dec 07, 2016 3:39 pm    Post subject:

fine I tried this.

 Code: //STEP001  EXEC PGM=SORT        //SORTIN   DD *                123                            //SORTOUT  DD SYSOUT=*          //SYSIN    DD *                  OPTION COPY                    OUTREC FIELDS=(1,3,ZD,MUL,+3) //SYSOUT   DD SYSOUT=*          //SYSUDUMP DD SYSOUT=*

and output is:
 Code: ---+----1----+- ***************             369

Can you please explain why do I need '+3' not 3, and why is output 11 bytes long?

Thanks.
Thanks.

Active User

Joined: 06 Jun 2009
Posts: 113
Location: UK

Posted: Wed Dec 07, 2016 4:03 pm    Post subject:

Fine I used EDIT to supress trailing spaces.

 Code: //STEP001  EXEC PGM=SORT                  //SORTIN   DD *                          3456                                      //SORTOUT  DD SYSOUT=*                    //SYSIN    DD *                            OPTION COPY                              OUTREC FIELDS=(1,1,ZD,MUL,+1,EDIT(T),                   2,1,ZD,MUL,+2,EDIT(IT),                  3,1,ZD,MUL,+1,EDIT(T),                   4,1,ZD,MUL,+2,EDIT(IT))

I am doing 3(1)+4(2)+5(1)+6(2). I will add them once I know what multiplication is producing.

It create:
 Code: ---+-- ****** 3 8512

How do I display only one digit when result of multiplication is only one digit? Bear in mind, I need to SUM them later.
4 x 2 is coming out as b8.

Thanks
Rohit Umarjikar

Global Moderator

Joined: 21 Sep 2010
Posts: 2467
Location: NY,USA

Posted: Wed Dec 07, 2016 8:31 pm    Post subject:

 Code: OPTION COPY                              INREC BUILD=(1,1,ZD,MUL,+1,EDIT(T),                     2,1,ZD,MUL,+2,EDIT(IT),                3,1,ZD,MUL,+1,EDIT(T),                   4,1,ZD,MUL,+2,EDIT(IT))  OUTREC FINDREP=(INOUT=(C' ',C''))
Bill Woodger

Moderator Emeritus

Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

Posted: Wed Dec 07, 2016 8:38 pm    Post subject: Reply to: Performing arithmetic on input field

If you don't specify a length (with LENGTH or an explicit EDIT mask) you get a default length. If you don't provide an explicit EDIT, you get a default mask.

"I" in an EDIT means "a blank if there is no significant digit encountered yet", so leading zeros you ask to be blank.

You need a + (or -) because that is how DFSORT will tell if you are specifying a numeric literal, or the (incomplete) start of a field definition.

I'm pretty sure the examples for 2.1 are the same as for 2.2, for instance, p136 in both documents:

 Quote: arexp,edit or (arexp),edit specifies that the edited result of an arithmetic expression is to appear in the reformatted input record. The arithmetic expression can consist of input fields, decimal constants, operators and parentheses. An arithmetic expression produces a signed, 31-digit zoned decimal (ZD) result to be edited as specified. See arexp,edit under OUTFIL OUTREC for details.

 Code: Sample Syntax: INREC FIELDS=(C’**’,27,2,FI,MIN, 83,4,PD,EDIT=(STTTTTTT),SIGNS=(+,-), 15:(((15,5,ZD,ADD,+1),MUL,+100),DIV,62,2,PD),M25,LENGTH=10)

Note the use of FIELDS instead of BUILD, which likely indicates that this example has been around for more than 10 years.
Arun Raj

Moderator

Joined: 17 Oct 2006
Posts: 2482
Location: @my desk

 Posted: Wed Dec 07, 2016 8:44 pm    Post subject: zh_lad, I would suggest keeping all the intermediate multiplication results in 2 bytes, so you don't have to figure out later which result has 2 digits and which one has 1 digit. Because you need to sum all of them later. It might add more work and confusion if you get rid of the blanks, and then try to figure out where each intermediate result starts. So you can use TT...edits and read them as ZD in further computations or keep the IT...edits and read them as UFF, whichever works for you.
Bill Woodger

Moderator Emeritus

Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

 Posted: Wed Dec 07, 2016 9:26 pm    Post subject: Reply to: Performing arithmetic on input field And multiple arithmetic operations can be carried out without having to define anything for intermediate results. The next operation is on "the current result" for as long as necessary without having to be concerned about it.

Active User

Joined: 06 Jun 2009
Posts: 113
Location: UK

Posted: Wed Dec 07, 2016 10:06 pm    Post subject:

Thanks Rohit, it worked.

Rohit Umarjikar wrote:
 Code: OPTION COPY                              INREC BUILD=(1,1,ZD,MUL,+1,EDIT(T),                     2,1,ZD,MUL,+2,EDIT(IT),                3,1,ZD,MUL,+1,EDIT(T),                   4,1,ZD,MUL,+2,EDIT(IT))  OUTREC FINDREP=(INOUT=(C' ',C''))

Active User

Joined: 06 Jun 2009
Posts: 113
Location: UK

Posted: Wed Dec 07, 2016 10:18 pm    Post subject: Re: Reply to: Performing arithmetic on input field

Thanks Bill.

2. I am aware of use of 'I' in EDIT
3. I didn't know, I was using arithmetic first the first in SORT - Thanks
4. Yes PDF has examples but always problem is discussed on different page. Ideally it should have link to go directly to the problem description by one click. It difficult to absorb example (sample) if problem is discussed on a different page.

Bill Woodger wrote:
If you don't specify a length (with LENGTH or an explicit EDIT mask) you get a default length. If you don't provide an explicit EDIT, you get a default mask.

"I" in an EDIT means "a blank if there is no significant digit encountered yet", so leading zeros you ask to be blank.

You need a + (or -) because that is how DFSORT will tell if you are specifying a numeric literal, or the (incomplete) start of a field definition.

I'm pretty sure the examples for 2.1 are the same as for 2.2, for instance, p136 in both documents:

 Quote: arexp,edit or (arexp),edit specifies that the edited result of an arithmetic expression is to appear in the reformatted input record. The arithmetic expression can consist of input fields, decimal constants, operators and parentheses. An arithmetic expression produces a signed, 31-digit zoned decimal (ZD) result to be edited as specified. See arexp,edit under OUTFIL OUTREC for details.

 Code: Sample Syntax: INREC FIELDS=(C’**’,27,2,FI,MIN, 83,4,PD,EDIT=(STTTTTTT),SIGNS=(+,-), 15:(((15,5,ZD,ADD,+1),MUL,+100),DIV,62,2,PD),M25,LENGTH=10)

Note the use of FIELDS instead of BUILD, which likely indicates that this example has been around for more than 10 years.
Arun Raj

Moderator

Joined: 17 Oct 2006
Posts: 2482
Location: @my desk

Posted: Wed Dec 07, 2016 10:25 pm    Post subject:

 Quote: Thanks Rohit, it worked
But I am afraid that is not what you were trying to achieve. Like Bill mentioned above, you can have multiple computations, just use braces to have meaningful results and then edit the final result as needed.

Active User

Joined: 06 Jun 2009
Posts: 113
Location: UK

Posted: Wed Dec 07, 2016 10:37 pm    Post subject:

Thanks Arun. Yes, I need to edit my original post to:

 Code: 1+8 + 8 + 1+4 + 6 + 1+0 + 4 + 6 + 1 = 40 * 9 = 360

I want to sum the digits of all the results of multiplication. I think I would need intermediate result to find all the digits to do sum later.

Thanks
Arun Raj

Moderator

Joined: 17 Oct 2006
Posts: 2482
Location: @my desk

Posted: Wed Dec 07, 2016 11:08 pm    Post subject:

Quote:
 Code: 987654321

My Input record

 Code: 9 (2) + 8 + 7(2) + 6 + 5(2) + 4 + 3(2) + 1
Multiplying every alternate digit with 2, starting from left.

From your original post, if it is every alternate digit, should it not be like this?

9 (2) + 8 + 7(2) + 6 + 5(2) + 4 + 3(2) + 2 + 1(2) = 70 * 9 = 630

You don't need to worry about the format of intermediate results because, as suggested you can do multiple computations one after the other, like this and edit only the final result.
SORTOUT
 Code: 0630

Active User

Joined: 06 Jun 2009
Posts: 113
Location: UK

 Posted: Wed Dec 07, 2016 11:22 pm    Post subject: Reply to: Performing arithmetic on input field Thanks Arun. Please check my previous post where I said I need to add up all the digits e.g. 9 (2) + 8 + 7 (2 ) + 6 + 5 (2) + 4 + 3 (2) + 1 18 + 8 + 14 + 6 + 10 + 4 + 6 + 1 1+8+8+1+4+6+1+0+4+6+1 = 40 × 9 = 360. I couldn't edit my original post. Thanks >>Still "2" is missing
Bill Woodger

Moderator Emeritus

Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

 Posted: Thu Dec 08, 2016 12:29 am    Post subject: Reply to: Performing arithmetic on input field IFTHEN=(WHEN=INIT for an OVERLAY to give you the several multiply-by-two results (they are not "intermediate results" in the sense normally used), then another WHEN=INIT with the BUILD to ADD all the digits that you need (odd-number from original location, even-numbered from the location OVERLAYed to) and then multiply that by +9.

Active User

Joined: 06 Jun 2009
Posts: 113
Location: UK

 Posted: Thu Dec 08, 2016 4:21 am    Post subject: Thanks Bill. I will apply these suggestions. I was about to fix missing '2' but it was locked. Cheers
Bill Woodger

Moderator Emeritus

Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

 Posted: Thu Dec 08, 2016 4:24 am    Post subject: Reply to: Performing arithmetic on input field No-one locked anything, and that last comment wasn't mine :-) Posts can only be edited by non-moderators for 10 minutes after they have been entered. If you can post (or PM) me a correction I can apply it and tidy up a bit.

Active User

Joined: 06 Jun 2009
Posts: 113
Location: UK

Posted: Thu Dec 08, 2016 7:46 pm    Post subject: Re: Reply to: Performing arithmetic on input field

Hi Bill,

How will I deal with space when result of multiplication is only 1 digit.

 Code: 1,1,UFF,MUL,+2,EDIT(IT)

How will I ignore space to pick up digits to sum in OUTREC (second IFTHEN).

Rohit was using FIND and REPLACE
 Code: OUTREC FINDREP=(INOUT=(C' ',C''))

Thanks.

 Bill Woodger wrote: IFTHEN=(WHEN=INIT for an OVERLAY to give you the several multiply-by-two results (they are not "intermediate results" in the sense normally used), then another WHEN=INIT with the BUILD to ADD all the digits that you need (odd-number from original location, even-numbered from the location OVERLAYed to) and then multiply that by +9.
Arun Raj

Moderator

Joined: 17 Oct 2006
Posts: 2482
Location: @my desk

Posted: Thu Dec 08, 2016 7:55 pm    Post subject:

 zh_lad wrote: How will I ignore space to pick up digits to sum in OUTREC (second IFTHEN).
This is already suggested above. Keep the results in 2-bytes and read as ZD or UFF (2 bytes)
 Quote: you can use TT...edits and read them as ZD in further computations or keep the IT...edits and read them as UFF, whichever works for you.
 All times are GMT + 6 HoursGoto page 1, 2  Next
 Page 1 of 2

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics How do i verify the char field is hav... Raghu M N PL/I & Assembler 1 Tue Sep 22, 2020 9:26 pm RPLDDDD field for extended VSAM - ESDS amitsjcntl JCL & VSAM 0 Tue Sep 22, 2020 1:45 pm Dynamically read input files using BP... Srinivas B COBOL Programming 20 Sat Sep 05, 2020 1:48 pm Related to performing validation of f... Kumar Sandeep DFSORT/ICETOOL 19 Fri Apr 24, 2020 5:44 pm To compare an input file with a maste... lekshmi133 COBOL Programming 5 Tue Apr 14, 2020 3:01 pm

 © 2003-2020 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us