Hi,
How to execute the Sql statement in Before job sub routine
How to call the Sql statement in before sub rouitne
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
How to call the Sql statement in before sub rouitne
Srinu Gadipudi
Re: How to call the Sql statement in before sub rouitne
srini,srinivas.g wrote:Hi,
How to execute the Sql statement in Before job sub routine
what type of sql statement you want to execute??if you could explain me a bit,i will try to help you!!!!!!!!!!!
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.