Re: Can an SQL field be shortned for output display and/or print?

Often you will find that you need to CAST the column. Check out the
difference in these three statements

select objname, objtype,
objtext,
objsize
FROM TABLE(QSYS2.OBJECT_STATISTICS('ROB', '*ALL')) AS a
order by objsize desc

select objname, objtype,
left(objtext, 5) as Short,
objsize
FROM TABLE(QSYS2.OBJECT_STATISTICS('ROB', '*ALL')) AS a
order by objsize desc

select objname, objtype,
cast(left(objtext, 5) as char(5)) as Short,
objsize
FROM TABLE(QSYS2.OBJECT_STATISTICS('ROB', '*ALL')) AS a
order by objsize desc

Then again, if it's just for display purposes and if you run these in Run
SQL Scripts instead of STRSQL you may find that you don't give a rip.

Rob Berendt