OCI stage assuming null for field containing only one space

[mspanda]

Hi,

I am trying to insert a varchar field with only one space to the oracle table which is not null field through OCI stage .

As it is not a empty string rather it is a varchar field with one space ,should be able to insert into oracle not null field.

i think this field is being treated as null and unable to insert record.I checked the log and there is no error.

Datastage ver 8.0 is newly installed and is there any setting in administrator need to be changed .


Ichecked the administrator:ENVIRONEMENT VARIABLE

APT_STRINH_PADCHAR is 0x0

Pease let me know if any one ever faced this kind of issues .

Thanks
msp

[ray.wurlod]

APT_STRING_PADCHAR is not relevant to VarChar data types. Why do you claim that "OCI stage assuming null for field containing only one space"? What is populated into the table (use a query with NVL function) or, if there is an error message, please post that. In short, debug! Send (a relevant sample of) rows to a text file and inspect that.

[chulett]

Try setting APT_ORACLE_PRESERVE_BLANKS to true.