| Author |
Message |
 Topic: Issue updating a collection of rows in a database table |
polydegmon
Replies: 5
Views: 3420
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Mar 14, 2013 6:38 am Subject: Issue updating a collection of rows in a database table |
Hi mqjeff, I've done some testing with the IN keyword and it seems to work with any type of list or environment reference, until you try to pass it over to a database.
Even creating the list of val ... |
| Topic: Issue updating a collection of rows in a database table |
polydegmon
Replies: 5
Views: 3420
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 13, 2013 5:44 am Subject: Issue updating a collection of rows in a database table |
Hi mqjeff, I've also tried the following format, however it is still causing the debugger to terminate.
SET Environment.Variables.Banking.BankingToBeRemoved.ReferenceID[1] = '1';
SET Env ... |
| Topic: Issue updating a collection of rows in a database table |
polydegmon
Replies: 5
Views: 3420
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 12, 2013 9:27 am Subject: Issue updating a collection of rows in a database table |
I'm trying to update a collection of rows in a database table using the code below, however it's not working and causes the debugger to terminate once I hit this line.
UPDATE Database.SchemaName. ... |
| Topic: Create Statement Issue |
polydegmon
Replies: 7
Views: 4607
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Nov 28, 2012 6:41 am Subject: Create Statement Issue |
I tried the method you suggested, however the FROM clause doesn't seem to work with the IDENTITY clause
CREATE LASTCHILD OF OutputRoot.XMLNSC
DOMAIN('XMLNSC')
IDENTITY (XMLNSC ... |
| Topic: How to Comes out f the FOR loop |
polydegmon
Replies: 4
Views: 3059
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Nov 28, 2012 5:12 am Subject: How to Comes out f the FOR loop |
You can use the LEAVE statement with a WHILE loop, but it can't be used with a FOR loop.
Check : WHILE <Condition>
IF <Condition> THEN
LEAVE Check;
END IF;
END ... |
| Topic: Create Statement Issue |
polydegmon
Replies: 7
Views: 4607
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Nov 28, 2012 4:59 am Subject: Create Statement Issue |
Yes sorry that's a typo.
This is the code
CREATE LASTCHILD OF OutputRoot DOMAIN('XMLNSC')
TYPE 'XMLNSC.Folder'
NAMESPACE gpd
NAME 'GetProducerDetailsResponse'
FROM E ... |
| Topic: Create Statement Issue |
polydegmon
Replies: 7
Views: 4607
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Nov 28, 2012 4:50 am Subject: Create Statement Issue |
Description Resource Path Location Type
Syntax error. Valid options include: identifier BEGIN CALL CASE CREATE DECLARE DELETE ELSE ELSEIF END
EVAL FOR IDENTIFIER IF INSERT ITERATE LEAVE LOOP ... |
| Topic: Create Statement Issue |
polydegmon
Replies: 7
Views: 4607
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Nov 28, 2012 4:14 am Subject: Create Statement Issue |
Hi, I'm trying to use the CREATE statement to create an XMLNSC folder out of an Environment Variable tree structure, however when I include the FROM clause an error is generated.
CREATE LASTCHILD ... |
| Topic: String Function Contains Issue |
polydegmon
Replies: 2
Views: 1979
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Nov 16, 2012 6:38 am Subject: String Function Contains Issue |
Hi I'm using the CONTAINS function and am experiencing an unexpected result. I have a work around but I'm just wondering if anyone else has experienced this issue.
When I use the CONTAINS function ... |
| Topic: Accessing Shared Variables |
polydegmon
Replies: 9
Views: 5616
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Oct 07, 2011 6:32 am Subject: Accessing Shared Variables |
| Hi lancelotlinc i attended an IBM course a few months ago in london where we did learn about the use of shared variables and the atomic keyword to protect them, however there was no code example of ho ... |
| Topic: Accessing Shared Variables |
polydegmon
Replies: 9
Views: 5616
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Oct 07, 2011 5:10 am Subject: Accessing Shared Variables |
I'm using a shared variable to store a set of rules that need to be accessed in other flows in the EXE group. However I'm getting an error with it.
The shared row is defined in subflow A, outside t ... |
