Re: Getting extra bit after the first field while unloading
Posted: 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.
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.