Hello Everyone,
I have a small query on DB2 LOAD. Sometimes there are errors/warnings in the message file like the one below:-

SQL0180N The syntax of the string representation of a datetime value is
incorrect. SQLSTATE=22007

SQL3185W The previous error occurred while processing data from row "F0-1" of
the input file.

Is there any was of getting the corresponding column name in the message file?

Regards
Ashwin

Have a look at the FOR EXCEPTION clause of the LOAD command. That allows you to specify a table where erroneous rows will be copied to. So you can do the load and analyze the problematic rows (and only those) afterwards.