Warning After Removing Columns (Netezza)

Teej · Post by **Teej** » Wed Jun 08, 2016 12:19 pm

The column is on the database's table itself. It is informing you that you are not going to populate this field.

This usually happens when you are trying to update with the entire table, instead of using a generated SQL statement.

joycerecacho · Post by **joycerecacho** » Wed Jun 08, 2016 12:24 pm

Actually it is a link to new registers, so, it is an 'insert only' link.
These fields are nullable, what is the problem of not mentioning them?

And yes, the query was generated by datastage cause there are 118 fields!

ds_developer · Post by **ds_developer** » Mon Jun 13, 2016 3:51 pm

The Netezza Enterprise stage requires all fields to be provided on an insert.

John