ERROR from ExecDirect: ERROR: Attribute 'Col_Name' is of type 'NUMERIC' but expression is of type 'DATE' You will need to rewrite or cast the expression

 As obvious it seems, but this error might come if you are using Insert/Update then Insert in Netezza Enterprise Stage. In the above error, the column used was Nullable but still the job shows error. This is because in Netezza Enterprise stage, we need to have the entire metadata defined in the target even if the columns defined are not getting any values from source and they have been defined as NULLABLE.