Hi

I am pretty new to Db2 Stored procedure and would like to have any help in this regard

I am writing an outbound script to extact data from Db2 tables to a flat file.

The Db2 column name is COUNT VARCHAR 5

The output colum name is COUNT1 with VARCHAR 7

so if the value of the COUNT is 234

I want in the output column COUNT1 the value of 0000234 as it always has to be output with length 7 digits

If the value of count is 2345 the value in the output column COUNT1 will be 0002345 meaning i will have to add 000 to make the Column COUNT1 of length 7 always

Can any one write the SQL Syntax for this please

Thanks

Gautam S

Something like...

right('0000000'||count1, 7)