Author |
Message |
Topic: E-sql Row-Wise Binding - PASSTRU - SQLSERVER ODBC |
maurito
Replies: 3 Views: 6328
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Nov 21, 2016 4:22 am Subject: E-sql Row-Wise Binding - PASSTRU - SQLSERVER ODBC |
You can use the Transact-SQL row constructor (also called a table value constructor) to specify multiple rows in a single INSERT statement. The row constructor consists of a single VALUES clause with ... |
Topic: Need help regarding Attribute value using esql |
maurito
Replies: 14 Views: 12007
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 05, 2016 5:06 am Subject: Need help regarding Attribute value using esql |
Thanks. Got this working
SET tmp3 = THE ( SELECT ITEM C FROM InputRoot.XMLNSC.Sample.Total
I don't know what you are trying to say with the number of iterations or stepovers, but you will get only O ... |
Topic: MQGET node related query |
maurito
Replies: 3 Views: 3332
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 04, 2016 11:11 pm Subject: Re: MQGET node related query |
Is it possible to use MQGET node as the first node in a flow?
I am trying to do it but the message is not getting read
I am a beginner to WMB..It would be great if you can help me clear my doubts
... |
Topic: Need help regarding Attribute value using esql |
maurito
Replies: 14 Views: 12007
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 04, 2016 10:30 pm Subject: Need help regarding Attribute value using esql |
SET tmp1 = THE ( SELECT ITEM C.Total FROM InputRoot.XMLNSC.Sample AS C WHERE C.Total.(XMLNSC.Attribute)TotalType = 'TransactionNetAmount');
SET tmp2 = THE ( SELECT C.Total FROM InputRoot.XMLNSC.Sam ... |
Topic: Message SELECT |
maurito
Replies: 10 Views: 7193
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 04, 2016 5:18 am Subject: Message SELECT |
When you are in a corner you try things that may be silly but they eliminate random conflicting thoughts in your head.
Your kind of late with the comment, even after my last post. I got it working ... |
Topic: mqsireadlog errors |
maurito
Replies: 2 Views: 4601
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 04, 2016 4:58 am Subject: Re: mqsireadlog errors |
look at the errrors you get, it gives you what the problem is and how to solve it.
First of all , V6 is no longer supported.
Then , look at the errrors you get, it gives you what the problem is and ... |
Topic: Message SELECT |
maurito
Replies: 10 Views: 7193
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 04, 2016 4:21 am Subject: Message SELECT |
RuleID != RuleId
Thanks!!!
Second Question.
I am getting repeating:
AccounttProdTypeIMList
Value:CHARACTER:107
AccounttProdTypeIMList
Value:CHARACTER:108
etc.
Which is sort of wha ... |
Topic: list all service operations (interfaces) available in broker |
maurito
Replies: 9 Views: 7420
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 04, 2016 2:31 am Subject: list all service operations (interfaces) available in broker |
From the definitions that are in the WSDL perhaps?
All the operations are defined in that (or should be)
The WSDL is the definition of the contract between the service and the apps using the servi ... |
Topic: Need help regarding Attribute value using esql |
maurito
Replies: 14 Views: 12007
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 04, 2016 1:40 am Subject: Need help regarding Attribute value using esql |
No.. that doesnt works either.
Doesn't work how?
It crashes the EG? It makes your desk turn green? It uninstalls your screensaver?
Or it gives an error message... ?
I am wondering why yo ... |
Topic: Aggregate request and reply |
maurito
Replies: 15 Views: 11605
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 29, 2016 4:58 am Subject: Aggregate request and reply |
And yet, the environment variable can't be set, and so the control messages can't be used.
But that has nothing to do with whether aggregation nodes or MQGet is "the right chioce".
The e ... |
Topic: Aggregate request and reply |
maurito
Replies: 15 Views: 11605
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 29, 2016 4:53 am Subject: Aggregate request and reply |
And yet, the environment variable can't be set, and so the control messages can't be used.
But that has nothing to do with whether aggregation nodes or MQGet is "the right chioce".
The e ... |
Topic: Aggregate request and reply |
maurito
Replies: 15 Views: 11605
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 29, 2016 4:22 am Subject: Aggregate request and reply |
..
So you're not talking about the Environment tree. You're talking about something else.
Where does this apply to the Aggregate nodes?
AIX ( or Operating System ) Environment variables. Docum ... |
Topic: Aggregate request and reply |
maurito
Replies: 15 Views: 11605
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 29, 2016 3:58 am Subject: Aggregate request and reply |
..
So you're not talking about the Environment tree. You're talking about something else.
Where does this apply to the Aggregate nodes?
AIX ( or Operating System ) Environment variables. Docum ... |
Topic: Aggregate request and reply |
maurito
Replies: 15 Views: 11605
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 29, 2016 3:38 am Subject: Aggregate request and reply |
Instead of using aggregate nodes, they suggested me to use MQGET node for fetching multiple response.
Who are 'they' ?.
Ask them to set the environment variable or give you an alternative design, a ... |
Topic: Small issue with namespace declaration copying |
maurito
Replies: 10 Views: 8197
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 22, 2016 7:25 pm Subject: Small issue with namespace declaration copying |
maurito:
Regarding your two options:
Option 1 broke some of the fields that handled MTOM and Base64 attachments, so a lot of care had to be taken to use that.
Option 2 would send 'null' or empt ... |