hello everybody,

i need a solution for db2 task center. via the import command i put data into a table. at first, this is no problem. but the job even shows a success (return code 0) if some data records were rejected. it is not a success it is an error.

the job shoud fail because in my situation it is not good when the next job starts.

does anyone know a solution for this problem?

thanks
toette

You did not specify the DB2 version or OS.

You could try the clause "warningcount 1" on your import statement.

Andy

good morning,

os = win 2003 sp2. i already tried to set "warningcount=1" but the return code is the same (value 0).

does anyone have another idea?

toette

You will have to define what "success" means on the Run Properties tab, otherwise Task Centre considers as successful any task that completes.