Retrieval of data from a Seq file

ray.wurlod · Post by **ray.wurlod** » Sat Jan 10, 2009 3:40 pm

Welcome aboard.

Please post the exact error message - it may even give you some clue if you read it carefully.

The representation of NULL in the file must have the same number of characters as the field width. Therefore "X" is invalid as a representation of NULL unless the data type is Char(1) or VarChar(1).

srini4122 · Post by **srini4122** » Sun Jan 11, 2009 4:33 am

Thanks a lot
as i am not a premium member i could read the post partially
can i get an email of your answer.

ray.wurlod · Post by **ray.wurlod** » Sun Jan 11, 2009 5:27 am

No, because that would set a precedent to undermine one of the sources of revenue by which DSXchange hosting and bandwidth costs are funded. A premium membership, which will allow you to read the entire post, is not expensive, at less than 30c (Rs12) per day.

srini4122 · Post by **srini4122** » Sun Jan 11, 2009 7:28 am

Thanks Ray
i will work it out

chulett · Post by **chulett** » Sun Jan 11, 2009 9:07 am

How about the "Please post the exact error message" part, you could see that.

vasa_dxx · Post by **vasa_dxx** » Mon Jan 12, 2009 12:45 am

Could you throw light on the Metadata for the columns.
Try with declaring the Nullable field as varchar2.

miwinter · Post by **miwinter** » Mon Jan 12, 2009 3:26 am

In PX, null field value will convert nulls into the given default on import from a seq file, it won't do the opposite i.e. convert the letter 'X" to a null

ray.wurlod · Post by **ray.wurlod** » Mon Jan 12, 2009 1:46 pm

Still waiting to see the exact error message posted...