Page 2 of 2

Re: Accomodating Long message into column

PostPosted: Fri Dec 09, 2011 2:24 pm
by coldplay1991
DDL of target table

Screen shot deleted - do not post screen shots as all they do is introduce clutter.
Using copy/paste from the terminal screen and applying the "Code" tag provides an aligned "screen".

Re: Accomodating Long message into column

PostPosted: Fri Dec 09, 2011 10:27 pm
by Akatsukami
coldplay1991 wrote:Hi, I am loading a message from a source file and while load it (using DB2 LOAD) to a new table, the new column can not fully show it even though the character limit is very high. Also, is there any ideal SQL data choice and modifier to LOAD the long message output properly into the new table column(my target location). I dont want it to overflow to 2 lines and not show half or broken either.

So, are you saying:
  1. That your messages are more than 150 characters in length?
  2. That your terminal emulator won't display 150 characters at a single time?
  3. Something else?

Re: Accomodating Long message into column

PostPosted: Fri Dec 09, 2011 11:51 pm
by coldplay1991
RIGHT

Re: Accomodating Long message into column

PostPosted: Sat Dec 10, 2011 11:56 am
by NicC
coldplay1991 wrote:RIGHT

but which one of the 3 options? And if the 3rd is included then describe 'something else'

Re: Accomodating Long message into column

PostPosted: Tue Dec 13, 2011 3:04 am
by Akatsukami
coldplay1991 wrote:RIGHT

Of course.