Sort condition to filter out records based on a condition

jemonthomas · New User Joined: 24 Jul 2006 Posts: 35 Location: india

i want to filter out records based on a condition as follows

END_DT IS NULL AND NBR_SHM_TYP_CD IN(1,44,0,41,2,43,9,4,5,57,10,59,60,61,62,64,65,66) AND NBR_SHM_PURP_CD IN(1,2,3,4,5,6,0)

can u suggest how to write in include statement in sort

Anuj Dhawan · Posted: Mon Mar 23, 2009 12:19 pm

Hi,

Suggest you post some sample records from input, expected output from them & the rules to get the output. Please tell us the RECFM & LRECL of input and output as well.

Please use BBcode when You post some input and output samples, that's rather readable, Thanks.

Arun Raj · Posted: Mon Mar 23, 2009 12:22 pm

And the length and format of the fields mentioned above.

jemonthomas · New User Joined: 24 Jul 2006 Posts: 35 Location: india

SAMPLE RECORDS

ksk · Posted: Mon Mar 23, 2009 2:13 pm

Provide full information.

What is the starting positon,length and format of fileds END_DT, NBR_SHM_TYP_CD and NBR_SHM_PURP_CD ?

Show us sample output also for ur creteria.

Frank Yaeger · Posted: Mon Mar 23, 2009 9:17 pm

Also, tell us what you mean by "NULL", and explain the conditions you want to use in English (not in some programming language that you understand but others don't). We're happy to help, but we shouldn't have to guess at what you want to do.