Getting extra bit after the first field while unloading data



IBM's flagship relational database management system

Re: Getting extra bit after the first field while unloading

Postby shankar_dh » Wed Mar 12, 2014 2:55 pm

I found out where the problem is while going through table definition,
Thank you All for your interest shown up to find out the resolution.

ACCOUNT_UNIQUE_ID field in the table 130 is NOT NULL but in Table 600
ACCOUNT_UNIQUE_ID field is defined as NULL.(It can have NULL values)

UNLOAD utility will always reserve one byte after the field length for the NULLable fields.
shankar_dh
 
Posts: 41
Joined: Fri Mar 22, 2013 1:00 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Getting extra bit after the first field while unloading

Postby dick scherrer » Wed Mar 12, 2014 10:20 pm

Good to hear you have a resolution - thank you for letting us know :)

d
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Previous

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post