| Author |
Message |
 Topic: Look up file creation to access predefined table of values |
ENVYMB
Replies: 3
Views: 1913
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Dec 20, 2013 3:28 am Subject: Look up file creation to access predefined table of values |
Hi All,
I have a table of values which i want to store in some file and fetch the value from the file from a ESQL code based on some conditions. I understand , a database table can be created and d ... |
| Topic: Database connection from Compute node |
ENVYMB
Replies: 5
Views: 2961
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Dec 20, 2013 1:32 am Subject: Database connection from Compute node |
Thank you dogorsy 
So messages failing on db connectivity issue is normal even if code is not accessing db. I will not have to change anything in code.
I believe statements
IF v_Row .valid IS ... |
| Topic: Database connection from Compute node |
ENVYMB
Replies: 5
Views: 2961
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 19, 2013 11:52 pm Subject: Database connection from Compute node |
Hi All,
I am using a ODBC connection to database from compute node which is working fine. Configuration is as below.
I have set a datasource name in compute node property.
I have declared sh ... |
| Topic: Removing carriage returns from a string in ESQL |
ENVYMB
Replies: 4
Views: 4669
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 19, 2013 11:22 pm Subject: Removing carriage returns from a string in ESQL |
| Thank You for your replies. |
| Topic: Removing carriage returns from a string in ESQL |
ENVYMB
Replies: 4
Views: 4669
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 28, 2013 3:42 am Subject: Removing carriage returns from a string in ESQL |
Hi,
requirement is to remove carriage return from an incoming string in ESQL. And i have tried below method and worked out.
DECLARE v_carriage CHAR;
SETv_carriage =CAST(X'0D' AS CHAR CCSID Inpu ... |
| Topic: Initializing array in ESQL |
ENVYMB
Replies: 3
Views: 8356
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Nov 20, 2013 10:34 pm Subject: Initializing array in ESQL |
Thanks Simbu. This approach worked out !
Thanks Esa for your reply.
ENVYMB |
| Topic: Initializing array in ESQL |
ENVYMB
Replies: 3
Views: 8356
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Nov 19, 2013 10:08 pm Subject: Initializing array in ESQL |
Hi,
I want to use an array in my esql and populate it with some data, which will be accessed in the later code. I have tried the below option and able to succeed.
SET vCount =1;
DECLARE vm ROW;
... |
