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

Author Message
Jay Villaverde

New User

Joined: 08 Mar 2014
Posts: 27
Location: USA

Posted: Thu Jun 26, 2014 6:49 am    Post subject: Dividing by different factors in outrec (Syncsort)

Hi. One step in my program is where I want to divide by a certain factor based on a different field.

For example, my data looks like:

 Code: 1331658001|00030835| 1331665001|00031028| 1374639001|00029011| 1378471004|00028856| 1463482001|00031032| 1463484001|00031211| 1741893001|00034740| 1741897001|00052321|

I know I can use the following to divide by a set number such as:

 Code: SORT FIELDS=(01,10,CH,A) OUTREC FIELDS=(01:01,10,                                                      11:C'|',                                                        12:12,08,ZD,DIV,+5,EDIT=('TTTTTTTT'),                           20:C'|')

But I have a need to divide some of those numbers in the 2nd column by 5, others by 3, others by 2, etc. based on the number in the 1st column.

Thanks,
Jay

Bill Woodger

Moderator Emeritus

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

 Posted: Thu Jun 26, 2014 12:25 pm    Post subject: Reply to: Dividing by different factors in outrec (Syncsort) Why use OUTREC FIELDS instead of OUTREC BUILD? You can see that FIELDS means different things in different contexts, but BUILD does not, so is clearer (processing is identical). Why use the column numbers when your output data are contiguous? IFTHEN=(WHEN=(logical-expression) seems to be what you want, unless you can point out why.
Jay Villaverde

New User

Joined: 08 Mar 2014
Posts: 27
Location: USA

 Posted: Thu Jun 26, 2014 5:11 pm    Post subject: Not familiar with IFTHEN but that does seem to be what I need. Can you help with the code for my situation? I'll also look up the usage of it. Thanks
Jay Villaverde

New User

Joined: 08 Mar 2014
Posts: 27
Location: USA

 Posted: Thu Jun 26, 2014 5:38 pm    Post subject: Looks like I got what I needed. Looked up usage of IFTHEN= and it worked beautifully. Thanks
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics SYNCSORT Error - CONTROL FIELD BEYOND... arunn SYNCSORT 10 Sun Oct 04, 2020 4:10 pm Populating Date and Sequence numer in... PORYES SYNCSORT 11 Thu Jul 16, 2020 5:01 pm SEQNUM with TRA=ETOA in OUTREC juares castro SYNCSORT 5 Sat May 30, 2020 5:40 am Insert System Runtime in HEADER In SY... Rick Ryan SYNCSORT 9 Tue May 26, 2020 9:01 pm SYNCSORT in Z/VSE nithinkarthika SYNCSORT 24 Mon May 11, 2020 3:44 pm

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