Null in non-nullable field?

chandra.shekhar@tcs.com · Mon Jan 21, 2013 11:49 pm

In the transformer, are you using IsNull function for that column ?

ArndW · Post by **ArndW** » Tue Jan 22, 2013 3:51 am

Often when you perform an action on a field in the database it affects the resulting column nullability.

First off, add "$OSH_PRINT_SCHEMAS" to see what DataStage is getting from the Oracle stage.

anvi · Post by **anvi** » Thu Jan 24, 2013 4:02 am

chandra.shekhar@tcs.com wrote:In the transformer, are you using IsNull function for that column ?

We can't use the IsNull function because we are using "runtime column propagation", so we can't use any transformers.

BI-RMA · Post by **BI-RMA** » Thu Jan 24, 2013 5:02 am

When using Runtime Column Propagation Arnd's advice to set OSH_PRINT_SCHEMAS to True for the job is even more valid.

ArndW · Post by **ArndW** » Thu Jan 24, 2013 5:18 am

I believe I had a case where a non-nullable column X in the database was queried with a "SELECT X as NewColumn..." and "NewColumn" arrived in DataStage as a nullable one. I can't check if that still happens, and it might be dependent upon your database and version, but this is a likely source of getting an altered nullability. Again, have DataStage print out the schemas since they represent the actual data, unlike the column definitions in your job.