| Author |
Message |
 Topic: Making DB Query with arrays |
Mandrake90
Replies: 2
Views: 4075
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 26, 2020 8:35 am Subject: Making DB Query with arrays |
thanks but in SQL the query works because it is quite simple.
SELECT COUNT(*) FROMT DBTABLE where ID in (1,2,3,4,5)
the issue is on Esql because I cannot put my array in the WHERE condition
... |
| Topic: Making DB Query with arrays |
Mandrake90
Replies: 2
Views: 4075
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 26, 2020 4:27 am Subject: Making DB Query with arrays |
Hi All,
I have a LOV in my esql code, named Environment.ListofIDs[]
How can I put it into a WHERE condition whithin a DB query?
Like this
qryRes= SELECT COUNT(*) where Database.DBTTABLE as D ... |
| Topic: RFHUtil Easy question |
Mandrake90
Replies: 9
Views: 18805
|
Forum: IBM MQ Installation/Configuration Support Posted: Tue Jun 23, 2020 8:20 am Subject: RFHUtil Easy question |
| I don't need any credential to access the system.admin channel (as I do on MQJExplorer client) I am wondering where could I put the queue managere Name "QMBRK" into the connection string if ... |
| Topic: RFHUtil Easy question |
Mandrake90
Replies: 9
Views: 18805
|
Forum: IBM MQ Installation/Configuration Support Posted: Tue Jun 23, 2020 5:08 am Subject: RFHUtil Easy question |
yes I am using rfhutilC, I thought it could be an issue related to the firewall but it works fine with another client from the same host...  |
| Topic: RFHUtil Easy question |
Mandrake90
Replies: 9
Views: 18805
|
Forum: IBM MQ Installation/Configuration Support Posted: Tue Jun 16, 2020 12:24 am Subject: RFHUtil Easy question |
here it is:
AMQ9208: Error on receive from host mandrake (192.168.132.41).
EXPLANATION:
An error occurred receiving data from mandrake (192.168.132.41) over TCP/IP.
T ... |
| Topic: RFHUtil Easy question |
Mandrake90
Replies: 9
Views: 18805
|
Forum: IBM MQ Installation/Configuration Support Posted: Fri Jun 12, 2020 8:26 am Subject: RFHUtil Easy question |
thanks Bruce, tried it but still doesn't work
I even tried with another server conn channell but prompt the same error. |
| Topic: RFHUtil Easy question |
Mandrake90
Replies: 9
Views: 18805
|
Forum: IBM MQ Installation/Configuration Support Posted: Fri Jun 12, 2020 7:10 am Subject: RFHUtil Easy question |
Hi All,
I am trying to connect my RFHutil to my remote QM.
I am able to do it with an another client(MQJExplorer) but I am facing the error "Error getting queue name", and if I try to br ... |
| Topic: MQInput CCDT connection |
Mandrake90
Replies: 3
Views: 6955
|
Forum: General IBM MQ Support Posted: Thu Apr 02, 2020 12:23 am Subject: MQInput CCDT connection |
Hi all,
I'm getting troubles while reading messages from a remote Queue (MQ 9 version).
I configure my integration node side this way:
mqsireportproperties IIBNODE-o BrokerRegistry -r
mqsichan ... |
| Topic: Store an XML into Sybase By IIB |
Mandrake90
Replies: 3
Views: 6241
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 12, 2020 4:13 am Subject: Re: Store an XML into Sybase By IIB |
How about base64 encoding the XML and then adding it?
Thanks Vitor,
I write succesfully on DB field with this code:
DECLARE inCCSID INT 850;
DECLARE inEncoding INT 273;
DECLARE msgBitStrea ... |
| Topic: Store an XML into Sybase By IIB |
Mandrake90
Replies: 3
Views: 6241
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 11, 2020 4:23 am Subject: Store an XML into Sybase By IIB |
Hi all,
it's my first topic here but I have been reading you for long time 
As subject, I have a Sybase DB with no XML license, so I can't use CML datatype.
I'm able to write my XML o ... |
