Comparing COMP3 Variable in SORT

[salini devana]

I have defined COMP-3 variable as follows.

Amount - PIC S9(11)V99 COMP-3

I need to extract the data where amount is not equal to 0.

How can i include this condition in the in SORT?

SORT = (123,8,PD,NE,0000000000000)

Is this correct? Please help me.

[DikDude]

That is not correct. You need to use the syntax specified in the manual or other topics here in the forum.

You can either SORT the data or COPY the data.

Do you need to (re)sequence the data or simply extract those records?

Search for topics that use INCLUDE.

[William Collins]

Or its sibling, OMIT, to avoid the confusion of a negative condition.

[salini devana]

DikDude,

I need to extract the data for which amount is not equal to 0 but not resequencing.

OUTREC IFTHEN=(123,8,PD,NE,0000000000000)

Is this syntax correct? For Comp-3, shall i need to use PD (Packed decimal)?

[William Collins]

It was suggested that you look at INCLUDE/OMIT in the documentation. Did you do that?