Calling stored procedures via ODBC
Posted: Wed Jul 26, 2000 12:22 pm
I notice in the documentation that when using an ODBC stage to call a stored procedure (in our case a call to Oracle running on a DEC Alpha), that the ODBC stage does not get/receive anything back from the remote machine. Were in DS 3.1.1r3 on an NT Server, BTW. I understand there is an option to receive return codes, etc. in later releases.
Regardless, I was wondering if the DS job will complete after issuing the call via ODBC or will it wait until the called stored procedure finishes? Based on the above, I imagine its the first scenario.
The reason I ask is that we plan on issuing a call in the final job in our DS jobstream to start some processes on the DEC Alpha. But we dont want the DS job to wait until the called procedure is done before it finishes (The procedure will take a few hours to run).
Thanks.
Brad Vincent
Compuware Corporation
c/o The Detroit Medical Center
Data Warehousing with a "health"-y spin
(313) 966-2176
Regardless, I was wondering if the DS job will complete after issuing the call via ODBC or will it wait until the called stored procedure finishes? Based on the above, I imagine its the first scenario.
The reason I ask is that we plan on issuing a call in the final job in our DS jobstream to start some processes on the DEC Alpha. But we dont want the DS job to wait until the called procedure is done before it finishes (The procedure will take a few hours to run).
Thanks.
Brad Vincent
Compuware Corporation
c/o The Detroit Medical Center
Data Warehousing with a "health"-y spin
(313) 966-2176