execute stored procedure db2 whithout resultset

almirafo — Sat, 16 Nov 2024 19:49:37 GMT

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

Re: execute stored procedure db2 whithout resultset

migueluisilva — Mon, 10 Feb 2020 11:44:20 GMT

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.

topic execute stored procedure db2 whithout resultset in App Development

execute stored procedure db2 whithout resultset

Re: execute stored procedure db2 whithout resultset