IBM Mainframe Forum

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.

Hello,

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.

Why not
If the column is defined as "n" nytes, "n" bytes should work just fine.

You may need to consider reformatting the input data to conform to the rules (which have not been posted).

I cant change input data dude. What N bytes you mean CHAR(n) ?
The input data is being truncated when I am copying it to a table.What is the idea way to show it full and in 1 row.

DSNE612I DATA FOR COLUMN HEADER MESSAGE COLUMN NUMBER 6 WAS TRUNCATED

Hello,

I see you are having difficulty with this concept. . . If you have 100 bytes of data (the actual number does not matter) and try to put this into a 30-byte column - it will not go in there.

What is the idea way to show it full and in 1 row.

If it will not fit, there is no "idea way". You can truncate the data before the load or you can just let it be lost. If you actively look at the data and report length problems, it may help resolve the problem.

Unless i've missed something i see 3 alternatives:
Change the table definition to prevent truncation.
Change the data to fit.
Just do nothing and live with it.

What do you want me to post?

see this image

this is my current load method

Provide the DDL of your target table(SHE0015.SDSFLG)

I did its in the picture posted above you. the SQL for the SHE0015.SDSFLG