Hi!
How to create a before job subroutine that will handle bunch of DML statements and stored porcdures.
Thanks in advance!
before job subroutine
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the Routines branch of your Repository create a new routine and ensure that its type is Before/After Subroutine.
Within the subroutine, code in DataStage BASIC and use the BASIC SQL Client Interface, or BCI, functions to mimic operation of the ODBC API.
Search the forum for examples.
Within the subroutine, code in DataStage BASIC and use the BASIC SQL Client Interface, or BCI, functions to mimic operation of the ODBC API.
Search the forum for examples.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You use SQLExecDirect() or SQLExecute() (for prepared SQL) functions.
There is a lot of structure you have to set up around this, to bind parameters and bind result columns, allocate memory for managing the environment and freeing the same, connecting and disconnection, and handling errors. The suite of functions is called the BCI.
Search
There is a lot of structure you have to set up around this, to bind parameters and bind result columns, allocate memory for managing the environment and freeing the same, connecting and disconnection, and handling errors. The suite of functions is called the BCI.
Search
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.