Page 1 of 1
Server Routine with sql statement.
Posted: Mon Dec 21, 2009 3:16 am
by arunmith
Hai, how to execute a sql statement in a server routine? Is there any function to do this? :D
Posted: Mon Dec 21, 2009 3:33 am
by Sainath.Srinivasan
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.
Posted: Mon Dec 21, 2009 4:35 am
by arunmith
Hai Sainath, but i want to use it in an after job subroutine. How do i do this?
Posted: Mon Dec 21, 2009 4:38 am
by DS_SUPPORT
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.
Posted: Mon Dec 21, 2009 7:12 am
by chulett
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.
Posted: Mon Dec 21, 2009 10:52 am
by kduke
Why do you think you need to do this? Can you use a lookup instead?