using DB2 connector to load a table
Moderators: chulett, rschirm, roy
using DB2 connector to load a table
I am using a DB2 connector to load a table. The table has a decimal field. When I load the decimal with a character it loads a 0.0 in that field. I want it to throw a database error so that I can trap this on the DB2 connector reject link. Is there a variable or setting that I can enable to make this happen?
Waiting the end point to check that a column have the good format is in my opinion not a good thing to do.
Using the isvalid function may involve a lot of coding.
In your case, I'll check when reading the source with a column import and reject lines with wrong format if your source is a file.
If you have lot of tables or process you can factorize using one job and multiple schema files.
Using the isvalid function may involve a lot of coding.
In your case, I'll check when reading the source with a column import and reject lines with wrong format if your source is a file.
If you have lot of tables or process you can factorize using one job and multiple schema files.