| Author |
Message |
 Topic: Accessing External Databases Within MQSI |
gowdy
Replies: 5
Views: 7976
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 23, 2001 12:34 am Subject: Accessing External Databases Within MQSI |
Thanks all
Those were options we had considered, as well as the Java plug-in node. In the end, we managed to get ODBC access to the database - no problem therefore.
Of the ideas suggested, th ... |
| Topic: Accessing External Databases Within MQSI |
gowdy
Replies: 5
Views: 7976
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 15, 2001 1:50 am Subject: Accessing External Databases Within MQSI |
Hi
Due to architectural demands, we are not allowed to make direct SQL calls on a database. Is there any way to, eg use Java to access an API to retrieve the data? Someone mentioned the Java plug ... |
| Topic: MQSI Node To Stop An MQ Input Queue |
gowdy
Replies: 5
Views: 8772
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Oct 12, 2001 12:15 am Subject: MQSI Node To Stop An MQ Input Queue |
Eddie,
Thanks for that - sounds like a good idea. As for stopping the queue manager, tried it and it works - I have been often known to saw off the branch whilst sitting on it, even if that branc ... |
| Topic: MQSI Node To Stop An MQ Input Queue |
gowdy
Replies: 5
Views: 8772
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 11, 2001 1:38 am Subject: MQSI Node To Stop An MQ Input Queue |
Hi Eddie
I have been looking at issuing a PCF message to the SYSTEM.ADMIN.COMMAND.QUEUE, but cannot see a command for stopping a Queue or a Queue Manager. Would I need to stop the channel? Any he ... |
| Topic: What's wrong with this XML Data |
gowdy
Replies: 2
Views: 6530
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 09, 2001 9:46 am Subject: What's wrong with this XML Data |
Hi
You need to ensure that you check the box 'Disable HTML on this Post'
Your message reads:
*********************************************
after parsing the following XML data:
<?xml ver ... |
| Topic: Using ESQL to access an Oracle database |
gowdy
Replies: 0
Views: 4453
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 08, 2001 7:17 am Subject: Using ESQL to access an Oracle database |
Hi
Does anyone out there know of any issues using ESQL to access an Oracle database? We are using Oracle 8.1.6. Any help is much appreciated.
Thanks
Mark |
| Topic: Accessing External Databases Within MQSI |
gowdy
Replies: 5
Views: 7976
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Oct 07, 2001 2:04 pm Subject: Accessing External Databases Within MQSI |
Hi
I need to access a database using a compute node. However, the problem is that we are not allowed direct access to the database. Does anyone out there know of a possible solution (support pac, ... |
| Topic: Accessing External Databases Within MQSI |
gowdy
Replies: 1
Views: 8293
|
Forum: Workflow Engines - IBM MQ Workflow & Business Process Choreographer Posted: Sun Oct 07, 2001 2:03 pm Subject: Accessing External Databases Within MQSI |
Oops --- put it in the wrong area.......SORRY!!!!
Mark |
| Topic: Accessing External Databases Within MQSI |
gowdy
Replies: 1
Views: 8293
|
Forum: Workflow Engines - IBM MQ Workflow & Business Process Choreographer Posted: Sun Oct 07, 2001 1:04 pm Subject: Accessing External Databases Within MQSI |
Hi
I need to access a database using a compute node. However, the problem is that we are not allowed direct access to the database. Does anyone out there know of a possible solution (support pac, ... |
| Topic: Storing Tag and Children on a Database |
gowdy
Replies: 0
Views: 4513
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 01, 2001 2:15 am Subject: Storing Tag and Children on a Database |
Hi
I want to store a tag and all its children on one field on a database. I was using
INSERT INTO Database.Table.Fields
(Tag) VALUES (Message.Parent.*[]);
where the layout is
<Message> ... |
| Topic: Deleting Contents of XML Tag |
gowdy
Replies: 2
Views: 6812
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 20, 2001 6:00 am Subject: Deleting Contents of XML Tag |
Hi
I had tried that one, but it appears you cannot delete all the sub-children easily. What I did was:
DECLARE I INTEGER;
SET I = 1;
WHILE I <= CARDINALITY(OutputRoot.XML.Main.SecondLevel.*[ ... |
| Topic: CDATA within XML Tag |
gowdy
Replies: 13
Views: 13057
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 20, 2001 4:20 am Subject: CDATA within XML Tag |
Hi
If I have an XML message wrapped in a CDATA tag in another XML tag, is there any easy way within MQSI to extract the XML message keeping the XML hierarchy.
For example,
<MAIN>
<
