I have read yor information, but, it does not mention about my question.. (How can I get the rejected records ?).
In the log file defined in "messages" only you can find the error and the number record.
Can DB2 generate a file with the records rejected?.
Thanks in advance.
Hi folks!
I'm inserting recods into DB2 table from a text file with the IMPORT COMMAND (the file is a coma delimiter).
Example:
ID1,value1, value2
ID2,value1, value2
ID3,value1, value2
ID4,value1, value2
I using something like this:
import from file_name of del insert into table_name (field1...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.