Hello,
i have the following problem:
the MQREAD works fine but the MQSEND returns an ERROR:
SELECT DB2MQ2C.MQREAD('Q.DS.ODS869L.1')
FROM SYSIBM.SYSDUMMY1
;
01DS869D662005060310570520050603105705
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE612I DATA FOR COLUMN HEADER COLUMN NUMBER 1 WAS TRUNCATED
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
i used the following SQL with an Error:
SELECT DB2MQ2C.MQSEND('Q.DS.ODS869L.1',
'DB2.DEFAULT.POLICY',
'TESTING 123',
'1234567')
FROM SYSIBM.SYSDUMMY1
;
DSNE610I NUMBER OF ROWS DISPLAYED IS 0
DSNT408I SQLCODE = -443, ERROR: EXTERNAL FUNCTION MQSEND (SPECIFIC NAME
MQSND4) HAS RETURNED AN ERROR SQLSTATE WITH DIAGNOSTIC TEXT
rc=406:amSesCreateSender
DSNT418I SQLSTATE = 38H01 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRRTN SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -891 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFC85' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
DSNE610I NUMBER OF ROWS DISPLAYED IS 0
DSNT408I SQLCODE = -443, ERROR: EXTERNAL FUNCTION MQSEND (SPECIFIC NAME
MQSND4) HAS RETURNED AN ERROR SQLSTATE WITH DIAGNOSTIC TEXT
rc=406:amSesCreateSender
DSNT418I SQLSTATE = 38H01 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRCUF SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -891 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFC85' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+---
what is wrong?
--
cu
kai