Data alignment
Posted: Mon Apr 23, 2012 2:48 pm
Hi i need to align my fileds from left to right alignment,
Please tell me how to do that
thanks
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