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 LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am
No new posts Extract Data till prev hour balaji81_k DB2 16 Fri Aug 25, 2017 9:25 pm
No new posts FTP data transfer from PC to Mainfram... AJAYREDDY All Other Mainframe Topics 8 Wed Aug 23, 2017 9:59 pm
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm

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