Before Load Statments

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
JDionne
Participant
Posts: 342
Joined: Wed Aug 27, 2003 1:06 pm

Before Load Statments

Post by JDionne »

I am running a flat file into a SQL server table using a SQL server bulk load stage. In this stage there is an option to put in a bit of sql code before the job imports data. In that line I have put:
delete dbo.STG_JOC_TBL where direction = 'E'
After I inserted that line of code and increased the job timeout limit to 240 seconds I started getting the phantom error 632. After I change nothing and recompile and re run I get the phantom error 764. After a third run I get the phantom error 768.
Any Ideas how I can track this thing down if my errors keep changing?
Jim
Post Reply