View previous topic :: View next topic
|
Author |
Message |
sridevi2005
New User
Joined: 15 Sep 2005 Posts: 42
|
|
|
|
Hi All,
I'm facing problem while loading data into tables.
I have taken the punch card by unloading the table.
I have used the same punch card while loading data into that table.
It is giving SOC4 because of description field and this field is VARCHAR field.
Is I'm getting this problem because of same punch card.
Do I need to increase varchar length while loading.
TEST_DES POSITION( 61 )
VARCHAR -- Got this by unloading the table and same used for loading the table
Please help me out on this.
Thanks,
Sridevi
) |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If you post your load job (jcl and control statements), the data that causes the 0c4, and any diagnostic info presented by the load, we may be able to help.
What you have posted does not provide anything to work with. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Sridevi,
I have to guess with the little bit of info that you have given us that the data you are trying to load is not the same data that you unloaded.
The DB2 Utility Guide has this for VARCHAR fields
Quote: |
VARCHAR and VARGRAPHIC fields must contain a valid 2-byte binary length field preceding the data; there cannot be intervening gaps between them and the fields that follow. |
|
|
Back to top |
|
|
|