NULL vs Space in BODS

[Former Member]

How to write the spaces into BODS file? I am facing challenge when extracting data from one of the DB2 table to File, There are few fields which holds space a valid data but when my job completes it just shows me NULL.

[Former Member]

Hello Gopal,

What is the datatype of fields which includes space in target (is it varchar,char?).

Whether your file is CSV ?

[Former Member]

Hi Gokul,

     Its of varchar datatype on target side. My target file is of type semicolon delimited.

[Former Member]

What is your source data type? Use the same data type in the file also.

[Former Member]

Source data type is char for one field & varchar for others.

[Former Member]

Arun,

     Moreover I hard coded few fields in BODS with ' ' (single space) but target file showing only NULL.

[Former Member]

Your requirement will work only if your target data type is also CHAR. Unfortunately, DS do not have a CHAR data type hence the only option is putting ' '.