regarding the DB2 EE stage

[srividya]

Hi

This is in regards to the DB2 EE Stage. We are loading data from a Sequential file to a DB2table using the EE Stage.
When we try to do this we have some special characters being loaded into the DB2 Table.
When we switched from EE stage to API stage the problem did not arise and the data was being loaded properly.

Any idea on why the special characters are being loaded when using a EE stage?

thanks ahead
Regards
Srividya

[ray.wurlod]

Not with so sparse a description. WHAT special values? Are the columns nullable? What are the data types of the affected columns? What values are in the source data? What transformations are being applied?

[bcarlson]

Are you getting hex data in your character fields - like binary zeros at the end of the text?

For example, input is 'MYDATA' (string[6]), but the target field in DB2 is char(8) and you end up with 'MYDATA**' (where * = x'00')?

If so, it is probably either the padchar setting for the job or your input schema doesn't match your output schema (like in the above example where string[6] is being loaded into char(8) field). Check out this topic:

DB2 Enterprise Stage

Hope this helps,

Brad.

[kura]

Hi Divya,

Special character loaded could be Empty strings.

If that is case

When you use API stage it automatically append space in the space for character field. If it is EE stage that is not case. Explicitly add spaces in end.


[quote="srividya"]Hi

This is in regards to the DB2 EE Stage. We are loading data from a Sequential file to a DB2table using the EE Stage.
When we try to do this we have some special characters being loaded into the DB2 Table.
When we switched from EE stage to API stage the problem did not arise and the data was being loaded properly.

Any idea on why the special characters are being loaded when using a EE stage?

thanks ahead
Regards
Srividya[/quote]