Hello group,

I have the situtation bellow:
1) code column: char(30) with values '1' to '30'
2) name column: char(100) with description values for code listed above such as 'Directory', 'Manager', ...

I need to list both columns in the following way:
code name
0001 Directory
0002 Manager
.
.
.

0010 Staf
.
.
0030 Operator

where:
1) code column should be filled with left zeros (total 4 chars)
2) name column should be filled with right blank spaces (total 30 chars)

Thanks in advance,
Marcos

May be this will help you to get on the right track:

Db2 Stoered procedure

Hi,

My platform is AIX 5.1 (FixPack Maintenance ML4) and DB2 7.2 (FixPack 10).
I wrote the following statement:

db2 "select repeat ('0', 4 - length (CODE)) CONCAT CODE, cast (NAME as char (30)) from table WHERE NAME IS NOT NULL AND CODE IS NOT NULL ORDER BY CODE" > ${OUTPUT_FILE_DIR}/${EXPORT_DIVISIONS}

It worked very well but, the content inside the output file is:

0001 <several blank spaces> Director
0002 <several blank spaces> Manager
.
.
.
0030 <several blank spaces> Operator

and I need the right way:

0001Director
0002Manager
.
.
.
0030Operator

Is there any thing more to do ?

Thank you very much again,
Marcos

You need to specify RTRIM. Revisit the link to the other post it has the example.

You could probably go one step further and put CONCAT operator between CODE and NAME...