Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Facing problem while loading data into tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sridevi2005

New User


Joined: 15 Sep 2005
Posts: 42

PostPosted: Thu Jan 17, 2008 2:53 pm    Post subject: Facing problem while loading data into tables
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jan 17, 2008 9:31 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Thu Jan 17, 2008 9:49 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts Fetching data from JHS as per the cur... arunsoods All Other Mainframe Topics 4 Wed Nov 22, 2017 1:54 pm
No new posts Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm
No new posts Having a problem FTP'ng to the MF pahiker All Other Mainframe Topics 2 Fri Nov 10, 2017 8:20 pm
No new posts Updating data from one file to other!!! Vignesh Sid SYNCSORT 1 Mon Nov 06, 2017 2:42 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us