By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

MQSEND on z/OS and DB2

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.