How do i set to Space/Blank on HANA table-datatype as CHAR with Data-Services.

[Former Member]

Hi,

I am trying to load the HANA table. The source is a extract (Fixed Flat file) of a Mainframe DB2 table. After i extract i am running the following DS dataflow.

Flatfile-->Tablecompare(Filefile data Vs Hana table) and then create  3 files.(Insert,Update,Delete) and uses these files to load the hana table.

All the columns which has blanks on flat file are being loaded as Nulls to HANA table. How can i stop this and load the blanks to the table?

Any suggestion will be of great help.

Thanks

[Former Member]

This is because the CHAR data type from source is converted to VARCHAR in HANA. You need to maintain the same CHAR data type both in source and target. I don't think you have a CHAR datatype in HANA, so insert blank ' ' in the transform for loading the blank spaces.

[Former Member]

Arun,

Thanks i even tried to moved blank ' ' in the Query transform but still the hana table is getting inserted as NULL. Any work around for this ?