Page 1 of 1
How to call the Sql statement in before sub rouitne
Posted: Tue Aug 26, 2008 5:44 am
by srinivas.g
Hi,
How to execute the Sql statement in Before job sub routine
Re: How to call the Sql statement in before sub rouitne
Posted: Tue Aug 26, 2008 6:04 am
by RAJARP
srinivas.g wrote:Hi,
How to execute the Sql statement in Before job sub routine
srini,
what type of sql statement you want to execute??if you could explain me a bit,i will try to help you!!!!!!!!!!!
Posted: Wed Aug 27, 2008 12:45 am
by srinivas.g
for example :
Delete from emp where report_date =sysdate;
Posted: Wed Aug 27, 2008 1:13 am
by tkbharani
As you can't directly call a sql statement in before job subroutine. You can write a small unix script to do that and call the unix script through Execute SH command.
Else write a small procedure and call the same by ODBC stage before calling the actual stage
Posted: Wed Aug 27, 2008 2:16 am
by ray.wurlod
You CAN directly call a sql statement in before job subroutine, by using BCI functions.
Search DSXchange for more information, particularly regarding the likelihood that you will need to purchase a license for your DataDirect ODBC driver to be able to use the BCI functions.