Syncsort - Picking the last value from record

rgupta71 · Posted: Wed Jul 22, 2009 12:32 am

Hi Experts,

I am in a problem. I want to sort my data such that the output is always the last record.

I/P file
U1 P1 A1 A2 A3
U1 P2 A1
U1 P3 A1 A2 A3 A4

O/P file
U1 P1 A3
U1 P2 A1
U1 P3 A4

U1 is of 2 characters. P1 is of 10 characters and values are in array format with range upto 25.

Can we achieve this using SYNSORT.

Thanks in Advance.

sdsinfo · New User Joined: 14 Jan 2008 Posts: 10 Location: bangalore

it is possible to sort your records in such a way that ur last value of record will be at last but ur records position will be changed.. do u want to sort in this way or you must need first record's last value should be in the first record itself in forst position ?

Aaru · Posted: Fri Jul 24, 2009 10:28 am

Rgupta,

rgupta71 · Posted: Fri Jul 24, 2009 10:30 pm

Hi Aaru,

The record is of the format
<key1 Key2><Count><value1><value2><value3>...........<value25>
Key1 is of 2 characters
Key2 is of 10 character
Count defines no of values present in the record. I need to pick the last record.i.e. the value which is equal to count.
Value is of 4 characters
Values are a type of array that range from 1 to 25.

Thanks

Craq Giegerich · Posted: Fri Jul 24, 2009 10:37 pm

What is the size and format of the count, packed decimal, zoned decimal, binary?

dick scherrer · Posted: Fri Jul 24, 2009 11:46 pm

Hello,