Originally posted by: SystemAdmin

Good day all,

Another question... I am trying to PUT and Get messages from an MQ queue. I have read through the MQ Adapter .pdf and have implemented the following...

For the PUT I call a function map and pass in the message:

=VALID(PUT("MQS","-QN S3089_IN2 -CD CH1/TCP/10.90.98.148:1417 -T",PACKAGE(In1)),FAIL(LASTERRORCODE()+ ": " + LASTERRORMSG()))

The adapter ignores the -CD command and goes straight to my local default queue manager on my workstation. Is there something I am doing wrong in the command?

For the GET I am using an Input Card with the MQ server adapter with command setting:

-QN S3089_IN2 -CD CH1/TCP/10.90.98.148(1417) -QTY S -LSN 10 -T

Again, the adapter ignores the -CD command.

Any help is appreciated.


#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

It looks to me like your specifying the wrong adapter. MQS is for the local MQ server, MQSC is the MQ Client adapter.

I don't know about the IP address and Port format you're using, but I got mine to work using the format of 1.2.3.4(1417). So, my command for putting the message is:

=VALID(PUT("MQSC", "-TS -QMN QMWIND1 -CD CH.CLIENT.WIN/TCP/148.126.98.12(1417) -QN TESTQUEUE.PUTTO -HDR -FORMAT MQSTR", PACKAGE (BuildMessage_OUT)), FAIL("Put message failed: " + LASTERRORCODE() + LASTERRORMSG()))

And the card command for getting the message was:

-QMN QMWIND1 -QN TESTQUEUE.GETFROM -CD CH.CLIENT.WIN/TCP/148.126.98.12(1417) -CVT -HDR

Hope that helps. Good Luck!
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Thanks. I'll try. I had tried the MQSC at one point and it returned an error that the adapter could not be found.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

I am still getting "Adapter Not Found" error any ideas? Isn't the MQ Client installed on the machine when the MQ Series is installed?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Is there any configurations required such as a jar that needs to be in the dstx.ini file?
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

You don't need to add a jar file, but you do need the MQ Client to be installed on the computer you're running DSTX on if you're connecting to a queue manager on another machine.

It's been a while since I've done an MQ install from the ground up. I believe the client connectivity is an option when you do the install. Do you have an MQ admin to work with? I'm pretty sure the client is free from IBM. You can use either the 5.3 client (http://www-1.ibm.com/support/docview.wss?rs=171&context=SSFKSJ&context=SSWHKB&dc=D400&uid=swg24006105&loc=en_US&cs=utf-8&lang=en) or the 6.0 client (http://www-1.ibm.com/support/docview.wss?rs=171&context=SSFKSJ&context=SSWHKB&dc=D400&uid=swg24009961&loc=en_US&cs=utf-8&lang=en) depending on your environment.


#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Thank you for your help. I'll post back next week.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

You were correct I had not installed the client portion when I had installed the server. I reinstalled it and I was able to use the MQSC adapter. Thanks.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender