Calling SQL Server Stored Proc via ODBC stage

[dixy71]

Hi,

I need to execute a Stored Procedure on a SQL Server Table, in Data Stage

scenario is:

SeqFile ---> Transformer-->ODBC Stage


Here i am generating a single dummy record from SeqFile Stage to trigger the call to the stored proc in theODBC Stage.

The call to the stored proc is working but if the stored proc does not exist in the database the following is written to the job log:

odCallUKCUSTOM_CONTROL,0: [DataDirect][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'UKCUSTOM_PAYROLL_Step1_CLEAR_TABLE'.

odCallUKCUSTOM_CONTROL,0: ROWS INSERTED :0
odCallUKCUSTOM_CONTROL,0: ROWS REJECTED :0

main_program: Step execution finished with status = OK.

main_program: Startup time, 0:03; production run time, 0:00.

Parallel job reports successful completion

The first entry in the log is a fatal error but this is not causing the job to abort. Can anyone help or is it an ODBC feature?

Thanks.

[ray.wurlod]

Welcome aboard. :D

Parallel jobs do not necessarily abort if a particular stage aborts. This is different from server behaviour. You can create job sequence or after-job subroutine to detect whether any messages with Fatal serverity were logged, and deal with them accordingly.