oracle trimming the spaces

Madhu1981 · Post by **Madhu1981** » Thu Sep 27, 2007 4:46 pm

Hi,

I have job like

CFF ==> Transformer ==> Oracle Enterprise Stage

One Source column is coming as CHAR 2 with two spaces as value and i am loding the same to oracle using load option.

The oracle is trimming the spaces and loading as null value..

then i added a environmental variable APT_ORACLE_PRESERVE_BLANKS to the job and set it as TRUE, still null is loading to the target table

I am sure, the value coming from source is two spaces, becz when i have used as

If COLUMN = ' ' Then 'AA' ELSE COLUMN, it is loading as AA wherever it is spaces, but when i am passing as it is, NULLvalue loading to the target even though the variable APT_ORACLE_PRESERVE_BLANKS set as true

Kindly suggest me, what might be the problem

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Thu Sep 27, 2007 5:09 pm

Write the data to a sequential file. If the spaces exist there, then the problem is an Oracle one. If they do not, then the problem is within your DataStage job design. We need to know which it is before suggesting any remedy.