400 Stored Procedure Returns Empty Parameter Values

Kevin Davidson

Delphi Developer

Sun, 27 Jun 2004 23:36:25 GMT

IBM DB2/400 Stored Procedure Returns Empty Parameter Values

This is not a question, just an observation for the benefit others.

We use a TStoredProc to access a stored procedure on an AS/400 DB2/400
V4R3 database. The stored procedure has parameters with the
ptInputOutput parameter type.

When using the Client Access/400 V3R2M0 ODBC drivers, the values in the
Params always came back empty. Switching over to the Client Access
Express V4R4M0 (with service pack SF60796) ODBC drivers allowed us to
receive the parameter values OK.

Kevin

Other Threads

1. DB2 on AS/400 - triggers and stored procedure

2. How to change commitment control with IBM OLEDB provider (DB2/400)

3. How To get(access) Values of record parameter that store procedure (Oracle) returns

4. Delphi Printing with IBM Client Access/400 - fix available from IBM

5. Problem with ODBC float parameter to DB2/400

6. AS/400, anyone used Delphi to access DB2/400

7. Error Calling DB2 Stored Procedure With a Date Parameter

8. PRB: Cannot use empty string as parameter in stored procedure

9. DB2 and DB2/400

10. Output parameter of stored procedure with Oracle are always empty