Server Routine with sql statement.

arunmith · Post by **arunmith** » Mon Dec 21, 2009 3:16 am

Hai, how to execute a sql statement in a server routine? Is there any function to do this? :D

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Dec 21, 2009 3:33 am

Why ? Why not use it from the job itself ?

Search for DSExecute().

Otherwise you can use universe inbuilt calls - which will be difficult to code and maintain.

arunmith · Post by **arunmith** » Mon Dec 21, 2009 4:35 am

Hai Sainath, but i want to use it in an after job subroutine. How do i do this?

DS_SUPPORT · Post by **DS_SUPPORT** » Mon Dec 21, 2009 4:38 am

Search the forum for the Keyword "BCI".

I will always prefer to execute the sql statements, by using After SQL tab in the target stage.

OR you can write a job and call it through the after job subroutine, which will be simpler than calling sql statements from the routine.

chulett · Post by **chulett** » Mon Dec 21, 2009 7:12 am

Wrap your sql into a script using the command line for your database and then use DSExecute in a routine to call and check it after job.

kduke · Post by **kduke** » Mon Dec 21, 2009 10:52 am

Why do you think you need to do this? Can you use a lookup instead?