How to call the Sql statement in before sub rouitne

[srinivas.g]

Hi,

How to execute the Sql statement in Before job sub routine

[RAJARP]

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!!!!!!!!!!!

[srinivas.g]

for example :

Delete from emp where report_date =sysdate;

[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

[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.