| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| URGENT!!!!!! DB2 EXTERNAL PROCEDURE |
« View previous topic :: View next topic » |
| Author |
Message
|
| danielaphex |
 Posted: Mon Sep 22, 2003 12:13 am Post subject: URGENT!!!!!! DB2 EXTERNAL PROCEDURE |
 |
|
Apprentice
Joined: 07 Apr 2003
Posts: 28
|
Hi there,
I am having a problem when calling a external stored procedure which is in a DB2 server.
The procedure goal is to GET a message from a queue with a MsgId which is received as a parameter.
I need to send to the procedure, as an input parameter, the MsgId of the incoming message in binary notation (that is to say with 24 binary positions). When trying this, I am having the following problems:
1) If I define this parameter in the DB2 Database as a CHAR we get into trouble because it is produced a transformation (in the DB2 Connect Driver or DB2 Server) of the type of data from ASCII to EBCDIC so we can not make a GET of the message with this CorrelId (when trying to GET no message with this CorrelId is found but the procedure is called)
2) If I define it as a CHAR FOR BINARY DATA we have got the following exception (given by the DB2 Connect Driver so we can not access to the procedure):
| Quote: |
Sep 22 09:29:16 eaidesa WMQIv210[55236]: (EAIBKDESA1_BK.Grupo_DPG)[2571]BIP2230E
: Error detected whilst processing a message in node 'FP_SIC_COL Peticiones.FR_E
nrutador Servicio_SIC_COL.FS_Servicio 1039_COL_V1.0.Invoca Procedimiento'. : EAI
BKDESA1_BK.114f8f4c-f200-0000-0080-cfb54220f4dc: /build/S210_P/src/DataFlowEngin
e/ImbComputeNode.cpp: 453: ImbComputeNode::evaluate: ComIbmComputeNode: 5799f06b
-f700-0000-0080-9c61a7752d72.9ccd4367-f700-0000-0080-9c61a7752d72.716052ff-f600-
0000-0080-e76c9c587a92
Sep 22 09:29:16 eaidesa WMQIv210[55236]: (EAIBKDESA1_BK.Grupo_DPG)[2571]BIP2934E
: Error detected whilst executing the function or procedure 'PROCEDIMIENTOALMACE
NADO'. : EAIBKDESA1_BK.114f8f4c-f200-0000-0080-cfb54220f4dc: /build/S210_P/src/D
ataFlowEngine/ImbRdl/ImbRdlCallableProcedure.cpp: 214: SqlCallableProcedure::exe
cute: ComIbmComputeNode: 5799f06b-f700-0000-0080-9c61a7752d72.9ccd4367-f700-0000
-0080-9c61a7752d72.716052ff-f600-0000-0080-e76c9c587a92
Sep 22 09:29:16 eaidesa WMQIv210[55236]: (EAIBKDESA1_BK.Grupo_DPG)[2571]BIP2519E
: (109, 1) : Error executing SQL statement '{ CALL SYSPROC.HZRXD40( ? , ? , ? ,
? ) }' against datasource 'SICDB2' with parameters 'NULL, 'AMQ EAIBKDESA1.Q?Xg^
Q ^K^T,', 'QMI1', 'EAI.SIC.COL.PETICION.1''. : EAIBKDESA1_BK.114f8f4c-f200-000
0-0080-cfb54220f4dc: /build/S210_P/src/DataFlowEngine/ImbRdl/ImbRdlExternalDb.cp
p: 406: SqlExternalDbStmt::executeStmt: ComIbmComputeNode: 5799f06b-f700-0000-00
80-9c61a7752d72.9ccd4367-f700-0000-0080-9c61a7752d72.716052ff-f600-0000-0080-e76
c9c587a92
Sep 22 09:29:16 eaidesa WMQIv210[55236]: (EAIBKDESA1_BK.Grupo_DPG)[2571]BIP2321E
: Database error: ODBC return code '-1'. : EAIBKDESA1_BK.114f8f4c-f200-0000-0080
-cfb54220f4dc: /build/S210_P/src/DataFlowEngine/ImbOdbc.cpp: 147: ImbOdbcHandle:
:checkRcInner: :
Sep 22 09:29:16 eaidesa WMQIv210[55236]: (EAIBKDESA1_BK.Grupo_DPG)[2571]BIP2322E
: Database error: SQL State '22005'; Native Error Code '-99999'; Error Text '[IB
M][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005'. : EAIBKDESA1_BK.1
14f8f4c-f200-0000-0080-cfb54220f4dc: /build/S210_P/src/DataFlowEngine/ImbOdbc.cp
p: 247: ImbOdbcHandle::checkRcInner: :
|
Could anybody tell me the proper way to define the data in the DB2 Server to receive binary parameters without suffer ASCII to EBCDIC transformation?
Thanks to everyone,
Cheers |
|
| 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
|
|
|
|
