| Author |
Message |
 Topic: ESQL Behaviour with Database |
Aldrine
Replies: 10
Views: 7676
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Feb 23, 2012 5:28 am Subject: ESQL Behaviour with Database |
@mqsiuser : As you can see in my first post itself I have tested with PASSTHRU too; but resulted in the same Exception.
@smdavies99: Indeed its the developer should take care of type castings in al ... |
| Topic: ESQL Behaviour with Database |
Aldrine
Replies: 10
Views: 7676
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Feb 23, 2012 1:54 am Subject: ESQL Behaviour with Database |
Use PASSTHRU to write ESQL statements that:
Bypass the WebSphere Business Integration Message Broker Parser
Go straight to the configured backend database
Execute a coded statement
... |
| Topic: ESQL Behaviour with Database |
Aldrine
Replies: 10
Views: 7676
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Feb 23, 2012 1:02 am Subject: ESQL Behaviour with Database |
Hi Friends,
I have a Database Column with type as "NUMBER(*,0)"; which implies it would accept any data without any decimal value.
While executing the following SQL command "UPDAT ... |
| Topic: ESQL Database Advanced Database Operations |
Aldrine
Replies: 9
Views: 6695
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 14, 2011 8:39 pm Subject: ESQL Database Advanced Database Operations |
Thank you mqjeff and inMo;
I read the documentation which led me back to the same questions 
As you can see in the documentation:
For each message flow thread, a broker that accesses a user da ... |
| Topic: JAVA Application to Put and Get Messages from MQ |
Aldrine
Replies: 7
Views: 11912
|
Forum: IBM MQ API Support Posted: Wed Dec 14, 2011 4:03 am Subject: JAVA Application to Put and Get Messages from MQ |
Ah! I see.
the usual caveats about making sure you're reading the data in the right code page and not doing things to convert it under the covers (java is fun that way).
Then use amqsbcg to dump ... |
| Topic: ESQL Database Advanced Database Operations |
Aldrine
Replies: 9
Views: 6695
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 14, 2011 3:55 am Subject: ESQL Database Advanced Database Operations |
There's documentation on how connections are managed.
At a base level, you can assume that there won't be less connections than you have instances of your flow running simultaneously.
I.e. if ... |
| Topic: ESQL Database Advanced Database Operations |
Aldrine
Replies: 9
Views: 6695
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 14, 2011 3:00 am Subject: Additional Details on the Question |
I am using WMB 7.0, and the Oracle DB as Back end.
It is a migration project; in eGate (java) they have already used concurrentUpdate (updating in ResultSet).
 |
| Topic: JAVA Application to Put and Get Messages from MQ |
Aldrine
Replies: 7
Views: 11912
|
Forum: IBM MQ API Support Posted: Wed Dec 14, 2011 2:53 am Subject: JAVA Application to Put and Get Messages from MQ |
Hi mqjeff,
You shouldn't be using an MQRFH2 header if you're on MQ v7.
You should be using message properties.
I am indeed using the MQ 7; the my need is to pump messages read from file (the ... |
| Topic: JAVA Application to Put and Get Messages from MQ |
Aldrine
Replies: 7
Views: 11912
|
Forum: IBM MQ API Support Posted: Wed Dec 14, 2011 12:36 am Subject: Better Solution |
Using the RFHUtil's C program (Scripts) is much better playing around with Java and the Header details.
The Scripts are tidy themselves...
Thanks fjb  |
| Topic: ESQL Database Advanced Database Operations |
Aldrine
Replies: 9
Views: 6695
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 14, 2011 12:29 am Subject: ESQL Database Advanced Database Operations |
Hi Friends,
I am using COMPUTE node to interact to Oracle Database; Currently am able to insert, update and delete the records in the DB.
Is there is any way to perform adva ... |
| Topic: JAVA Application to Put and Get Messages from MQ |
Aldrine
Replies: 7
Views: 11912
|
Forum: IBM MQ API Support Posted: Thu Dec 01, 2011 10:16 pm Subject: JAVA Application to Put and Get Messages from MQ |
Hi Friends,
I am currently trying to build a java program to pump messages with RFH Header (V2) and also to retrieve the messages from Queue.
Code for put:
try {
BufferedReader br = ... |
| Topic: ESQL Select DISTINCT |
Aldrine
Replies: 17
Views: 34952
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2011 5:22 am Subject: ESQL Select DISTINCT |
Thank you for pointing out the tempVariable switch; i have corrected them.
As of efficiency, I was pointing at the way of doing it. but making it efficient is as per need and utility of the End Use ... |
| Topic: ESQL Select DISTINCT |
Aldrine
Replies: 17
Views: 34952
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2011 4:10 am Subject: Solution for getting Distinct |
Hi,
DECLARE tempGroup ROW;
DECLARE index INTEGER 1;
set tempGroup.Field[1] = InputRoot.XMLNS.Body.Field[1];
FOR loopField As InputRoot.XMLNS.Body.Field[*]
IF NOT EXIST ... |
| Topic: Base Conversion from Decimal to Octal and likewise |
Aldrine
Replies: 16
Views: 7484
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 27, 2011 2:31 am Subject: Base Conversion from Decimal to Octal and likewise |
it is not wise to *ban* either ESQL or Java. It is OK to state that one or other is the preferred language on your site, as long as exception are allowed.
You can also mention that thi ... |
| Topic: Using two nodes together--SOAP INPUT AND MQ |
Aldrine
Replies: 17
Views: 9381
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 26, 2011 9:17 pm Subject: Using two nodes together--SOAP INPUT AND MQ |
It is not impossible or incorrect.
On based on you design necessity you have to follow.
If you need to tinker around with the Header values I suggest you follow sorge's idea.
But if you going to ac ... |
