Grouping of records

trushant.w · Posted: Mon Jan 20, 2014 12:16 pm

I want to group a records (inpt file pos 34 bytes 4)
like all 5064 will come first then 5099,5087,2356 and then all others will come

sureshpathi10 · Posted: Mon Jan 20, 2014 12:34 pm

Hi,

Please search how to code with IFTHEN=(WHEN=GROUP...and post what you've tried here to help you further along with sample input/output.

trushant.w · Posted: Mon Jan 20, 2014 12:38 pm

actually dont want to use build.
And want to keep the in put file as it is after arranging in above sequence
I am not getting when=group syntax without Build

sureshpathi10 · Posted: Mon Jan 20, 2014 12:42 pm

Please read the manual for WHEN=GROUP and try to understand the logic of BUILD/OVERLAY used with. Try to code by yourself.
When you don't get your expected result, provide the code here... we will help you out.

BTW, When you post any question, please remember to give any code & example data to work with.

trushant.w · Posted: Mon Jan 20, 2014 1:28 pm

Thanks for replying
I am trying with below

sureshpathi10 · Posted: Mon Jan 20, 2014 1:37 pm

Could you also provide the sample input data and expected output?

trushant.w · Posted: Mon Jan 20, 2014 1:46 pm

Sample Input

sureshpathi10 · Posted: Mon Jan 20, 2014 1:55 pm

Here is the sort card.

I believe, your input file is fixed and LRECL=213

trushant.w · Posted: Mon Jan 20, 2014 2:57 pm

Thank you so much suresh.
This woks perfectly for me