After-Job Routine

madhonrougeuri · Post by **madhonrougeuri** » Tue Apr 05, 2005 8:22 am

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

kcbland · Post by **kcbland** » Tue Apr 05, 2005 8:52 am

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.

madhonrougeuri · Post by **madhonrougeuri** » Tue Apr 05, 2005 9:51 am

Thanks for the reply Ken.My source is in JdEdwards buffer files..and I want to delete the data in buffer files after the job is finished.I need a script to run from windows...

madhonrougeuri · Post by **madhonrougeuri** » Tue Apr 05, 2005 11:24 am

I dont see the ExecDos in the Built-in before/after subroutines?why is it so?

deepbanerji · Post by **deepbanerji** » Tue Apr 05, 2005 1:33 pm

madhonrougeuri wrote:I dont see the ExecDos in the Built-in before/after subroutines?why is it so?

Go to "Job properties" window and check Before-job subroutine After-job subroutine Drop down boxes.

madhonrougeuri · Post by **madhonrougeuri** » Tue Apr 05, 2005 1:47 pm

I did check it.I didnot find it.There are only four of them.......

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Apr 05, 2005 1:55 pm

Include it under 'ExecSH'

ray.wurlod · Post by **ray.wurlod** » Tue Apr 05, 2005 7:17 pm

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.

chulett · Post by **chulett** » Tue Apr 05, 2005 10:52 pm

Or they are running a UNIX server, in spite of how the post is labelled.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 05, 2005 11:35 pm

ExecDOS installs on UNIX servers.

chulett · Post by **chulett** » Wed Apr 06, 2005 9:40 am

Really? I don't recall ever seeing it in any of my drop-down lists... ExecSH yes, but no ExecDOS.

kcbland · Post by **kcbland** » Wed Apr 06, 2005 10:43 am

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

madhonrougeuri · Post by **madhonrougeuri** » Wed Apr 06, 2005 11:09 am

Thanks for all the help...
Could somebody tell me if I could acheive the same (clear JdEdwards source files)using CALL DSExecute("............") from job control?
Thanks,
madhu

chulett · Post by **chulett** » Wed Apr 06, 2005 11:56 am

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

I do trust you, Uncle Ken.

I'm sure there's an ExecDOS on a Windows server and (only having made it to 7.0.1 so far) hadn't seen one on a UNIX server install. Yet. Not sure why you'd need one, but...

Someday, 7.5 will be within my grasp - and I'll be one step closer to World Domination.

madhonrougeuri · Post by **madhonrougeuri** » Wed Apr 06, 2005 3:38 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..