Blanks from SAP ECC not populated as blank/null at Oracle Tgt

[Former Member]

Hi,

I am dumping data from ECC to Oracle 11g via SAP BODS 4.1

Columns with blanks are neither populated as blanks nor as null at oracle target table.

However, BODS recognizes the blanks. This is because, when I give a decode function in query transform i.e decode(column=' ', '$',column) , this populates the target with '$'.

When I try to populate directly, Both the below queries return no results.

Select * from ORacle_TGt where column is null

Select * from ORacle_TGt where column=' '

Even on the webi reports, this column is neither seen as NULL nor as Blanks.

Datatype of the column is Varchar(1). Pls help on populating the blank values directly from ECC.

Thanks.

[former_member442248]

Hi Saurabh.

Not required to go to DS Config. Go to Tools --> SAP and select the checkbox.

Regards.

Shaz

[former_member680025]

I am not sure if this was answered...but the ans is to set the below variable in %DS_COMMON_DIR%/conf/DSConfig.txt file,

Interpret_R3_Null_as_Null =TRUE

Restart the Data Services before checking

[former_member192448]

Hi

Set ANSI_Varchar_Behavior parameter to FALSE in %DS_COMMON_DIR%/conf/DSConfig.txt file,

restart SAP Data Services Windows service and test again.

Regards

Charles