Suggestion Needed
Moderators: chulett, rschirm, roy
Suggestion Needed
I have to run a unix script to load the data into warehouse. Is it better to use after job subroutine or a sequencer that will call the script if the job ran successfully ?
Modular programming is usually a good idea. You can independently execute the script/sequencer job rather than incur the runtime of a transformation job with after/job commands.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
I agree - to add:
we have a situation with IQ bulk loads where we dont get the system return code from executing an 'Auto' load on the stage, which as you can imagine doesnt inform us whether the load was succesful or not.
We then moved to BASIC code to handle the execute of the .sql (using 'manual' load in the IQ Bulk stage), code which could handle the return code from the OS.
good luck
dnzl
we have a situation with IQ bulk loads where we dont get the system return code from executing an 'Auto' load on the stage, which as you can imagine doesnt inform us whether the load was succesful or not.
We then moved to BASIC code to handle the execute of the .sql (using 'manual' load in the IQ Bulk stage), code which could handle the return code from the OS.
good luck
dnzl
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
"what the thinker thinks, the prover proves" - Robert Anton Wilson