[unixODBC-support] inputOutput parameter problem in calling stored Procedure

Bartolomeo Nicolotti bnicolotti at siapcn.it
Tue Feb 17 09:39:01 GMT 2009


I've moved the SQLBindparameter before the SQLPrepare, see here: 

but I got the same result.

			Statement = 0x80690e0            
			SQL = [CALL GIANLUCA.PROVACs(?)][length = 24 (SQL_NTS)]
		DIAG [S0002] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0204 - PROVACS
in GIANLUCA di tipo *N non trovato.

I'll ask IBM. if I can't do this I'll have to use windows, sigh....

Many many thanks

Best regards

Nick Gorham-2 wrote:
> Bartolomeo Nicolotti wrote:
>>I've tried with a C program 
>>helloODBCPrepStoredP.c  that calls a stored procedure (better and RPG
>>program on iseries) and I got:
>>bart at LxPC37:~/download/software/mono/src/test$ ./helloODBCPrepStoredP
>>siapbn siapbn75
>>Error code: -1
>>Failure because: prepare:
>>and from unixodbc log.
>>		Entry:            
>>			Statement = 0x80690e0            
>>			SQL = [CALL GIANLUCA.PROVACS(?)][length = 24 (SQL_NTS)]
>>		Exit:[SQL_ERROR]
>>		DIAG [S0002] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0204 - PROVACS
>>in GIANLUCA di tipo *N non trovato.
>>The message, is the same as with mono, and in the iseries slang means that
>>it searches for a procedure with no parameters (*N), and it doesn't find
>>as the procedure PROVACS has been built for test purpose only, has 1
>>parameter of type char and it's not overloaded.
>>I think that the driver lacks the possibility of doing prepared statements
>>that call stored procedures, or there's some other way of doing this.
>>My pc is 32 bit, the iseries system uses ebcdic and the number of bits on
>>iseries is not so easy to know, I think 48bits, yes the iseries is a
> Just for completnes, move the SQLBindParameter to before the SQLPrepare. 
> But as we have said, its the driver that has the problem. I suspect 
> binding first will fix the problem, or passing the variable in place. 
> But neither help you with mono.
> -- 
> Nick
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support

View this message in context: http://www.nabble.com/inputOutput-parameter-problem-in-calling-stored-Procedure-tp22002537p22053730.html
Sent from the unixODBC - Support mailing list archive at Nabble.com.

More information about the unixODBC-support mailing list