| Author |
Message |
 Topic: Defining a Data Source |
semcgurk
Replies: 1
Views: 1546
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 11, 2014 4:27 am Subject: Defining a Data Source |
Hi there,
I am trying to use a 'Database' node in my message flow to interact with a database.
I have defined a Database Connection in my project and am trying to associate these with a 'Databas ... |
| Topic: Passing Array as a Parameter to Function |
semcgurk
Replies: 7
Views: 2689
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Nov 15, 2013 8:26 am Subject: Passing Array as a Parameter to Function |
| Thank you! |
| Topic: Passing Array as a Parameter to Function |
semcgurk
Replies: 7
Views: 2689
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Nov 15, 2013 8:14 am Subject: Passing Array as a Parameter to Function |
D'oh!
Copy and paste #fail:
CREATE FUNCTION FilterByMultipleValues(IN CharArray REFERENCE) RETURNS CHAR
|
| Topic: Passing Array as a Parameter to Function |
semcgurk
Replies: 7
Views: 2689
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Nov 15, 2013 8:03 am Subject: Passing Array as a Parameter to Function |
If it is an Environment Variable with multiple instances, could I not just create a reference to it and thus define my function thus:
CREATE FUNCTION FilterByMultipleValues(IN CharArray[& ... |
| Topic: Passing Array as a Parameter to Function |
semcgurk
Replies: 7
Views: 2689
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Nov 15, 2013 7:25 am Subject: Passing Array as a Parameter to Function |
Hi there,
I am trying to create a Function that allows an array to be passed in as a parameter.
I cannot get the signature of the function right.
I have tried the following:
CREATE FUNCT ... |
| Topic: Recursion Problem |
semcgurk
Replies: 12
Views: 4670
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 14, 2013 6:14 am Subject: Recursion Problem |
| Thanks all for your replies - I think I have enough information now to give this a crack - thanks again! |
| Topic: Recursion Problem |
semcgurk
Replies: 12
Views: 4670
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 14, 2013 5:03 am Subject: Recursion Problem |
Guys,
Thanks so much for the replies - these have really helped me out.
This:
...WHERE lastname IN (SELECT Names FROM Environment AS Names)
looks like the perfect option except ... |
| Topic: Recursion Problem |
semcgurk
Replies: 12
Views: 4670
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 14, 2013 3:17 am Subject: Recursion Problem |
@chevalier - yes, I think that's right - thanks for this!
How can I prevent this from happening?
@sibmu - the expected output is
<Body>
<Person>
<FirstName>Bruce< ... |
| Topic: Recursion Problem |
semcgurk
Replies: 12
Views: 4670
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 14, 2013 1:30 am Subject: Recursion Problem |
Hi there,
I'm having an issue with my code - I'm trying to set up a loop whereby I loop round an array of items and try and extract a number of arrays from this:
DECLARE N INTEGER CARDINALIT ... |
