DSXchange

Posted: **Mon Dec 18, 2006 10:28 am**

Hello:

Good Morning all...!!!

Am getting the following error:

LookUp: When checking operator: On output data set 0: When binding output schema variable "outputData": When binding output interface field "COLUMN_NM_1" to field "COLUMN_NM_1": Implicit conversion from source type "string[5]" to result type "string[2]": Source string will be truncated.

LookUp: When checking operator: On output data set 0: When binding output schema variable "outputData": When binding output interface field "COLUMN_NM_2" to field "Reject: When checking operator: When validating export schema: At field "COLUMN_NM_2": Exporting nullable field without null handling properties": Implicit conversion from source type "string[5]" to result type "string[2]": Source string will be truncated.

Reject: When checking operator: When validating export schema: At field "COLUMN_NM_3": Exporting nullable field without null handling properties

Reject: When checking operator: When validating export schema: At field "COLUMN_NM_4": Exporting nullable field without null handling properties

My Job flow Proceess is as follows:

Code: Select all


                     Db2_API_1   Db2API_2  Db2API_3
                              \    |     /
                               \   |   /
DB2UDB_API ----Transformer-----Lookup------Transformer-------DataSet
                                 |
                                 |
                               Reject

For COLUMN_NM_1 and COLUMN_NM_2:

lookup table the COLUMN_NM_1 = Length 4
DB2 Source table COLUMN_NM_1 = Length 5

lookup table the COLUMN_NM_2 = Length 2
DB2 Source table COLUMN_NM_2 = Length 5

Tried for COLUMN_NM_1[4,5] and COLUMN_NM_1[2,5] but still get this error.

And for COLUMN_NM_3 and COLUMN_NM_4

There is no nullable data so tried the IF ISNULL(column) then ' ' else Column
but still keep getting these errors.

Would appreciate any guidence.

Posted: **Mon Dec 18, 2006 11:39 am**

It seems your lookup is failing and so it is returning a null . Try changing nullable as yes for COLUMN_NM_1 ,COLUMN_NM_2

Posted: **Mon Dec 18, 2006 3:25 pm**

Within the Lookup stage, what is the data type of COLUMN_NM_1 on each link on which it appears? The message suggests that it is Char(2) somewhere.

Posted: **Mon Dec 18, 2006 5:45 pm**

Try to maintain the length of the COLUMN_NM_1, COLUMN_NM_2 as it is in the DB2 source. You can try the truncation and the transformation in second transformer.
COLUMN_NM_3 is nullable Yes in the source. Mark default null value in Dataset or NullToValue in transformer. Untill then, the datatype shuld be Nullable yes.