syncsort(dmxexpress) produces weird output

Question

I'm trying to sort:

1

4

11

10

2

3

using syncsort. The result looks like:

1

10

11

2

3

4

How to fix this.

I used the command:

syncsort /workspace /mytmp/ /infile /work/in_test /fields fld1 1 char 4 /keys fld1 ascending /outfile /work/out_test overwrite /noprompt /end

Answer 1

This is due to key declaration. You should give length 2 as a key. It will get you your desired output.

Currently it is only sorting 1st position so you are getting this wired output.

SORT FIELDS=(1,2,CH,A)