After-Job Routine
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 24
- Joined: Sun Jan 23, 2005 3:36 pm
After-Job Routine
Hi All,
I need to delete data from the source after the job finishes.I figured out that I need to write an after-job subroutine to achieve this.Does any body have a routine to accomplish this?
Thanks,
Madhu
I need to delete data from the source after the job finishes.I figured out that I need to write an after-job subroutine to achieve this.Does any body have a routine to accomplish this?
Thanks,
Madhu
What source? How do you want to do it? Bat script? Perl script? After-job routines call to ExecDOS to run any Windoze command line program will do what you need.
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
-
- Participant
- Posts: 24
- Joined: Sun Jan 23, 2005 3:36 pm
-
- Participant
- Posts: 24
- Joined: Sun Jan 23, 2005 3:36 pm
-
- Participant
- Posts: 14
- Joined: Fri Sep 03, 2004 2:50 pm
- Location: NJ
-
- Participant
- Posts: 24
- Joined: Sun Jan 23, 2005 3:36 pm
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If ExecDOS is not there, either someone has removed it (some people believe it's dangerous to permit access to the operating system), or your DataStage server is incompletely installed.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
chulett wrote:Really? I don't recall ever seeing it in any of my drop-down lists... ExecSH yes, but no ExecDOS.
Check your install under Routines\Built-In\Before/After. On release 7.1 and prior Unix servers ExecDOS does not appear. On NT servers it is there. Trust us
![Wink :wink:](./images/smilies/icon_wink.gif)
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
-
- Participant
- Posts: 24
- Joined: Sun Jan 23, 2005 3:36 pm
I do trust you, Uncle Ken.kcbland wrote:Check your install under Routines\Built-In\Before/After. On release 7.1 and prior Unix servers ExecDOS does not appear. On NT servers it is there. Trust us
![Wink :wink:](./images/smilies/icon_wink.gif)
Someday, 7.5 will be within my grasp - and I'll be one step closer to World Domination.
![Laughing :lol:](./images/smilies/icon_lol.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 24
- Joined: Sun Jan 23, 2005 3:36 pm
Hi.
I tried to delete the records in the JDedwards buffer file(DB2/As400)...but it doenst allow me to perform any operations except for Select.
Error i got is:
SQL statement:DELETE FROM JDEDTA.F56BO04
SQLSTATE=S1000, DBMS.CODE=-7008
[DataStage][SQL Client][ODBC][INTERSOLV][ODBC 20101 driver][DB2/400]F56BO04 in JDEDTA not valid for operation.
I have full authority to the source file..
Could some body give me any pointers.......
Thanks..
I tried to delete the records in the JDedwards buffer file(DB2/As400)...but it doenst allow me to perform any operations except for Select.
Error i got is:
SQL statement:DELETE FROM JDEDTA.F56BO04
SQLSTATE=S1000, DBMS.CODE=-7008
[DataStage][SQL Client][ODBC][INTERSOLV][ODBC 20101 driver][DB2/400]F56BO04 in JDEDTA not valid for operation.
I have full authority to the source file..
Could some body give me any pointers.......
Thanks..