hi,

i allways use C program to access DB2 data, sometimes i need to limit the output length of a CHAR/VARCHAR column from Command line, is there any option for that ?

i tried left (c1, 15) and it does not work
also tried rtrim(c1) didnot work either

any ideas ?

Try VARCHAR(myColumn,40) (or whatever other value you want instead of 40). This will truncate the data.

Andy

Try cast(c1 as char(15))
I am sure this will work

Dakshinamurthi

problem with varchar(col,11); each time it truncates its giving the following message
Recxxxxx F
SQL0445W Value "Recxxxxx FP " has been truncated.
SQLSTATE=01004

No problem with substr(col,1,11) instead of varchar(col,11) where col is your column name