Re: Create Table mixing referenced and explicit column definitions creating undesirable results

Instead of writing 35 spaces, which I find prone to error and not very
self-documenting (in the case you save your DDLs as I do), I would suggest
one of the following options for newfield (using only one space between
apostrophes):

1) Cast(' ' as char(35) ) as newField
2) Repeat(' ', 35) as newField


Regards

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Fri, Apr 30, 2010 at 10:48 PM, Dennis Lovelady <iseries@xxxxxxxxxxxx>wrote:

select field1, field2, char(35) as newfield, field3 from oldfile

FIELD1 FIELD2 FIELD4 FIELD3
a b 35 c
d e 35 f
g h 35 i
******** End of data ********

How about this:

select field1, field2, ' (total 35 spaces) ' as newfield, field3
from oldfile

Should do the trick.

Joe

Golly Jeepers, Joe! Glenn is not the only tired one, huh?!!? How did I
miss that?!?

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
Thought for the day:
"Smile", they said, "it could be worse!" So I did, and it was.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.