IBM Mainframe Forum

Hi,

Can some one help me please?

need to check first 3 digits, if it is non-zero(NZ) then in output it has NZ, if it is zero(ZE) then at end of the record it has to display ZE


my i/p is like below



Expected output

Have you tried anything? Have you a access to a SyncSort manual? If not, you should get one.

You can find a lot of example code here. You're going to need OPTION COPY (or SORT FIELDS=COPY), INREC IFTHEN=(WHEN=condition and OVERLAY. Have a crack at it. Let us know if you get stuck.

I have tried with the below


I am getting below error

if You had just searched the forum You would have found the right syntax without asking.

How I can write one more condition to come NZ(not eq zero)

shailaja85 wrote:

Select all

SORT FIELDS=COPY                 
INREC IFTHEN=(WHEN=(1,3,ZD,EQ,0),
[code]    BUILD=(1,39,40:C'ZE'))   


********************************* TOP OF D
111 AAA                                   
222 BBB                                   
000 CCC                                ZE
333 DDD                                   
******************************** BOTTOM OF

how i can writre one more condition to come NZ(not eq zero)

You are jesting, yes?

You can try by just adding another IFTHEN. The IFTHEN is part of the INREC, so you'll need a "continuation" for your existing IFTHEN (a comma after the final closing-bracket).

Another was is with IFTHEN=(WHEN=INIT, which goes first and which is executed for every record. On that you can set to NZ, with the zero condition overwriting the value later.

There is also IFTHEN=(WHEN=NONE, which goes after the IFTHEN=(WHEN=(condition, and is executed for records which have not had a true test against them.

Best thing is to read up in the manual, look at some examples, ensure you understand them, experiment until you do, and then choose one of the above methods.

Hi,

Could you please provide links/documents/examples of IFTHEN=(WHEN=INIT.
many thanks for your anticipated help.

start from
www.ibm.com/storage/dfsort

If you see the Search box at the start of your topic, put INIT in there and see what you can find.