In the Metadata, a few columns have been set to Nullable and the rest to Non-Nullable. I have now set Nullability to Yes for all columns in the Netezza Stage. To test if it works, I retained just 2 columns and the jobs runs fine. However, when I tried to bring in all the additional columns, the job aborts with a different error message.kwwilliams wrote:When DataStage makes the connection it sends the sql statement to the database and run time metadata is returned, which is why you get the warning in the Neteeza said:
"When checking operator: When validating import schema: At field "sample": Importing potential null to not nullable field"....
Code: Select all
Un-handled conversion error on field "quintile " from source type "string[1]" to destination type "int8":
source value=" "; the result is non-nullable and there is no handle_null to specify a default value.