| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Stored Procedure with Param Type: CHAR FOR BIT DATA |
« View previous topic :: View next topic » |
| Author |
Message
|
| dominik.schweers |
 Posted: Wed Nov 05, 2008 12:54 am Post subject: Stored Procedure with Param Type: CHAR FOR BIT DATA |
 |
|
Novice
Joined: 23 Oct 2008
Posts: 17
|
Hi Guys,
i need to call a stored proc on DB2(z/OS). The stored proc has two parameters. The first is declared as CHARACTER. The second ist declared as CHARACTER FOR BIT DATA . Both are INOUT.
We tried to call it via
| Code: |
CREATE PROCEDURE myProc(INOUT ch_param CHARACTER, INOUT ch_result CHARACTER)
LANGUAGE DATABASE
EXTERNAL NAME "PROC";
CALL myProc(ch_param, ch_result) IN Database.{STD_DB_SCHEMA(ref_env)};
|
STD_DB_SCHEMA(ref_env) generates the Schema for the current environment.
The Call does not work correctly, we get
[IBM][CLI Driver] CLI0112E Zuordnungsfehler. SQLSTATE=22005
How to handle the CHARACTER FOR BIT DATA in ESQL?
Any ideas?
Thank you. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Wed Nov 05, 2008 10:57 am Post subject: Re: Stored Procedure with Param Type: CHAR FOR BIT DATA |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| dominik.schweers wrote: |
Hi Guys,
i need to call a stored proc on DB2(z/OS). The stored proc has two parameters. The first is declared as CHARACTER. The second ist declared as CHARACTER FOR BIT DATA . Both are INOUT.
We tried to call it via
| Code: |
CREATE PROCEDURE myProc(INOUT ch_param CHARACTER, INOUT ch_result CHARACTER)
LANGUAGE DATABASE
EXTERNAL NAME "PROC";
CALL myProc(ch_param, ch_result) IN Database.{STD_DB_SCHEMA(ref_env)};
|
STD_DB_SCHEMA(ref_env) generates the Schema for the current environment.
The Call does not work correctly, we get
[IBM][CLI Driver] CLI0112E Zuordnungsfehler. SQLSTATE=22005
How to handle the CHARACTER FOR BIT DATA in ESQL?
Any ideas?
Thank you. |
Have you tried using a BLOB type? You will of course need to know in which CCSID your char for bit data is stored on the DB. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
