DSXchange

can i abort the sequence in this way if a job aborts?

I have one routine and a job notification stage, which i want to run when a job fails.

Job1-Notify(fail)

Exception handler - notify(seq fail)

If i handle the error in the job, exceptional handler doesnt capture it

or within the stage you are reading as unicode and writing as non-unicode or vice versa

why do we want to delete all rows of child table?

i think we should drop the referential integrity of the parent table using before SQL and then recreate it using after SQL running the insert query in between

why dont u use "do while" in Unix scripting?

link all the 4 to a sequencer stage and change the mode of the stage to "any". link the sequencer stage to "notification activity" stage and fill in the details In each of the 4 jobs(in sequencer), in triggers tab, change expression type to FAILED (conditional) Job 1 -> sequencer...

doesnt that ODBC connection contain a server name and port and all that stuff?

as it says. most likely a network problem. try again

check your DSN. is the server name correct there.

can you post the expression syntax? are you forcing null on a non nullable field?

all the columns which you are using for any calculations in the stage variables in transformer have to be handled for nulls. Just make sure.

I have used almost 30 stage variables some time in a single transformer.

you must be sure about how the stage variabels work ie they get compiled before the columns from top to bottom.

If you can post the error it would have been a great help in understanding your issue

can you post the error?

I am not sure about the limit but 20 is certainly not that number.

once you fire your jobs they run on the server. so even if you close the director or designer your jobs will run fine

are the individual jobs running fine?

this happens because too many jobs are already running on the server and datastage fails to intiate another one. i have experienced this in my projects as well. restarting the server helped me

your user id has been vodooed. you have any suspiscions?

jokes apart. really its nothing on which anyone can help you out because its strange.