Please tell me how to do that
my unload sort card
SELECT A.UN_NO, CHAR('|'),
A.ID_NO, CHAR('|'),
B.LST_NM, CHAR('|'),
SUBSTR(CHAR(COUNT(*)),1,3), CHAR('|')
FROM table1 a , table2 b
WITH UR;
and the formatting sort card
SORT FIELDS=COPY
OUTREC FIELDS=(01:01,08,09:09,08,17:17,17,
34:34,3)
in this the position i need to change is that 34:34,3
SELECT A.UN_NO, CHAR('|'),
A.ID_NO, CHAR('|'),
B.LST_NM, CHAR('|'),
SUBSTR(CHAR(COUNT(*)),1,3), CHAR('|')
FROM table1 a , table2 b
WITH UR;
and the formatting sort card
SORT FIELDS=COPY
OUTREC FIELDS=(01:01,08,09:09,08,17:17,17,
34:34,3)
in this the position i need to change is that 34:34,3
output data
0004000|000000.|............ |8
0004000|000000.|............ |82
0004000|000000.|............ |823
0004000|000000.|............ |8
0004000|000000.|............ |564
0004000|000000.|............ |5
0004000|000000.|............ |8
0004000|000000.|............ |82
0004000|000000.|............ |823
0004000|000000.|............ |8
0004000|000000.|............ |564
0004000|000000.|............ |5
thanks