IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


Accomodating Long message into column



IBM's flagship relational database management system
Post a reply

Re: Accomodating Long message into column

Postby coldplay1991 » Fri Dec 09, 2011 2:24 pm

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".
coldplay1991
 
Posts: 59
Joined: Tue Nov 15, 2011 5:47 am
Has thanked: 0 time
Been thanked: 0 time
Top

Re: Accomodating Long message into column

Postby Akatsukami » Fri Dec 09, 2011 10:27 pm

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?
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times
Top

Re: Accomodating Long message into column

Postby coldplay1991 » Fri Dec 09, 2011 11:51 pm

RIGHT
coldplay1991
 
Posts: 59
Joined: Tue Nov 15, 2011 5:47 am
Has thanked: 0 time
Been thanked: 0 time
Top

Re: Accomodating Long message into column

Postby NicC » Sat Dec 10, 2011 11:56 am

coldplay1991 wrote:RIGHT

but which one of the 3 options? And if the 3rd is included then describe 'something else'
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times
Top

Re: Accomodating Long message into column

Postby Akatsukami » Tue Dec 13, 2011 3:04 am

coldplay1991 wrote:RIGHT

Of course.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times
Top
Previous
Post a reply

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks