Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
almirafo
Contributor

execute stored procedure db2 whithout resultset

hello, everyone,

 

I have a script load bellow:

SQL call PAINEL.SP_LOAD_FROM_INTERACT('PF') ;

 

this stored procedure in DB2 load a table but  not return nothing.

 

after execute I have other script that load data from this table.

 

that Stored Procedure on execute script return error.

QVX_UNEXPECTED_END_OF_DATA: Unable to get column information for the fields that are used in the query: Object reference not set to an instance of an object.

 

 

How I execute this stored procedure wihtout error?

 

Tanks

 

Labels (1)
1 Reply
migueluisilva
Contributor

Hi.

I have the same problem.

I created a DSN using the Iseries Access ODBC driver, but when I call the stored procedure from the data load editor I get the same error.

It is possible to use ODBC connections to call DB2 stored procedures?

With the deprecated IBM DB2 connetion everything works fine.