| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| Search found 3 matches |
| Author |
Message |
 Topic: Select and other Operations on Environment Variables [ESQL] |
arthasdk
Replies: 1
Views: 2239
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Tue Nov 01, 2016 8:43 am Subject: Select and other Operations on Environment Variables [ESQL] |
Hi Guys,
I have the result of 2 queries stored in two variables like :
SET Environment.Variables.Var1[] = SELECT col1,col2... from Table1... where .....;
SET Environment.Variables.Var2[] = SEL ... |
| Topic: [Help] Conditional ESQL UPDATE Statement |
arthasdk
Replies: 2
Views: 2791
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 04, 2016 10:02 am Subject: [Help] Conditional ESQL UPDATE Statement |
| Will COALESCE work if say, I want to update the record with (D,E,F) with values (<ValD>, <ValE>, NULL) ? |
| Topic: [Help] Conditional ESQL UPDATE Statement |
arthasdk
Replies: 2
Views: 2791
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 04, 2016 9:40 am Subject: [Help] Conditional ESQL UPDATE Statement |
Hi Guys,
I wanted to something like :
Update {DB}.{Schema}.{Table} T SET
A=<ValA>
B=<ValB>
C=<ValC>
Where
D=<ValD>
AND E=<ValE>
AND F=<ValF> ... |
|
|
|
