Load utility log info problem

shahnazurs · #1 (**permalink**) 06-17-09, 05:32

Hi,

I use the following code in UNIX to execute delimited flat file

Code:

db2 -x "load from 'abc' of del modified by coldel~ replace into a.emp" > a.log

if any error happens i.e. data field size is less and is not able to store value from flat file or any other database related error it logs error like

Code:

SQL3107W  There is at least one warning message in the message file.

How can I find out exact error occured while loading?

Thanks.

rahul_s80 · #2 (**permalink**) 06-17-09, 05:48

chk load command options :
[MESSAGES msg-file]

shahnazurs · #3 (**permalink**) 06-17-09, 06:13

Thanks for your suggestion

I gave like below, it thrown me error

Code:

db2 -x "load from 'abc' of del modified by coldel~ MESSAGES=a replace into a.emp" > a.log

saying

Code:

SQL3016N  An unexpected keyword "MESSAGES=conn" was found in the filetmod
parameter for the filetype.

Let me know where do I insert MESSAGES in my snippet.

Thanks.

sathyaram_s · #4 (**permalink**) 06-17-09, 07:02

MESSAGES=a --- Space between the words. No =

Internet Services

Web Development

Digital Marketing

Consumer Tech