Tami,
We use ESP as our scheduling package also. This is what we do to check the status
of our jobs.
Capture the return code the load (variable $?), we use
rc="$?"
if [ $rc -ne 0 ]
then exit $rc
fi
Then we interrogate the contents of the messages file. We get the record counts
returned in Row Read, Rows Deleted, Rows Rejected and Rows Loaded. If the count of
Rows Deleted or Rows Rejected is > 0 we set a return code to indicate each
situation. If the Rows Read <> Rows Loaded we set another error code.
Hope this helps,
Roy
Tami Van Dreese wrote:
> We are running scripts on DB2 V6.1.0.31 on AIX to load data into tables. We are
> trying to integrate these jobs with our scheduling package (ESP). The problem
> is how to tell ESP that a load has rejected or discarded rows. When all rows
> are rejected from the load file, ESP picks this up as an abend, but if only some
> rows are kicked out, it interprets this as a successful completion. Does anyone
> know how we can identify this as an imcomplete load?
>
> On a related note, we can't seem to get the 'dumpfile' modifier of the load
> command to work with any of the output file destinations we give it. Any ideas?
>
> Thanks for your help.
> Tami Van Dreese
> Lands' End, Inc
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
