If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Stored Procedures from sql text.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-12-04, 16:17
max_irwin max_irwin is offline
Registered User
 
Join Date: Jan 2004
Location: All over, MAN
Posts: 1
Question Stored Procedures from sql text.

Is it possible to call a DB2 stored procedure in the following way?
---------------------------------------------------------------
On Win2k, I am running a third-party web component parsing jscript with windows scripting host.

I am also running DB2 7.2 fixpack 10 on another Win2k server.

From the web application, I am able to pass in sql as a string and obtain recordsets via accessing a MSVCPP 6.0 dll, which has connections to the DB2 database.

I do NOT have the ability to modify the code for this application and/or its functionality.

I DO have complete control over the database environment and stored procedures, as well as the script that is parsed by the web application.

The execute call in my jscript is:
Code:
  var strSQL = "call [schema].[procedurename]('foo','bar')";
  execute_sql_statement(strSQL);
The error returned is:
Code:
[IBM][CLI Driver][DB2/NT] SQL1109N The specified DLL "[schema].[procedurename]" could not be loaded.
Can it be done??

Thanks!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On