| Author |
Message |
 Topic: check whether the string contains numeric value in ESQL |
suraj
Replies: 12
Views: 17958
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 15, 2009 6:39 am Subject: check whether the string contains numeric value in ESQL |
CAST with DEFAULT works perfectly fine. Thanks rekarm01
Heres how to do it
DECLARE iValue INTEGER CAST(InputRoot.MRM.ns:Action AS INTEGER DEFAULT 0);
IF(iValue <> 0)THEN
-- input is nu ... |
| Topic: check whether the string contains numeric value in ESQL |
suraj
Replies: 12
Views: 17958
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 14, 2009 6:54 pm Subject: check whether the string contains numeric value in ESQL |
| I dont want an exception to be thrown. The whole message will error out just for this check. |
| Topic: check whether the string contains numeric value in ESQL |
suraj
Replies: 12
Views: 17958
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 14, 2009 1:16 pm Subject: check whether the string contains numeric value in ESQL |
how do i check whether the string contains numeric value in ESQL??
the IS NUM doest not work because If applied to non-numeric types, the result is FALSE. |
| Topic: Set the FTP directory at runtime using 6.1 Filenodes |
suraj
Replies: 0
Views: 2292
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 13, 2009 12:44 pm Subject: Set the FTP directory at runtime using 6.1 Filenodes |
I am using the FileOutput node in WBIMB v6.1 to create a file and then ftp it to a certain specific directory on a remote server.
How can I ftp to 2 diffrent directories on that server using the sam ... |
| Topic: Quotes arround character values in TDS message |
suraj
Replies: 1
Views: 2326
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed May 20, 2009 9:58 am Subject: Quotes arround character values in TDS message |
Hi
I am using MB v6.1
I have to model a data at the output end that is comma delimited with the character(string) values in the data having double qoutes arround them.
something like this
1233, ... |
| Topic: FileInput node configurable properties for FTP |
suraj
Replies: 2
Views: 3175
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Apr 17, 2009 1:14 pm Subject: FileInput node configurable properties for FTP |
I have a same problem as you described.
Were you able to find a solution for this? |
| Topic: TimerNodes |
suraj
Replies: 13
Views: 11682
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 18, 2008 9:49 am Subject: TimerNodes |
I had a same kind of requirement, where i needed to trigger a flow at a particular time of the day, and that too ,only once.
I didnt go with the timer node at all and let the chron job control the ... |
| Topic: Distinct values from ESQL SELECT statement |
suraj
Replies: 2
Views: 3830
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 13, 2008 10:44 am Subject: Distinct values from ESQL SELECT statement |
i tried that, the DISTINCT is not a keyword. It flags an error on this.
Moreover its mentioned in the information center that this SELEECT does not support DISTINCT |
| Topic: Writing Exception list to fie using java compute node |
suraj
Replies: 2
Views: 2883
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 13, 2008 10:33 am Subject: Writing Exception list to fie using java compute node |
How do we write the exception list to a file using the javacompute node ??
I am able to write it after converting that to an XML .
Is there any way to get the list in the file, in same format as the ... |
| Topic: Distinct values from ESQL SELECT statement |
suraj
Replies: 2
Views: 3830
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 13, 2008 10:09 am Subject: Distinct values from ESQL SELECT statement |
Hi,
I am working on MB v6.1
I have a requirement in which i have to get the distinct value of an element in an XML message.
I am using the SELECT statement which gives me all the values of that e ... |
| Topic: trigger a flow at a particular time |
suraj
Replies: 1
Views: 2204
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 04, 2008 7:20 pm Subject: trigger a flow at a particular time |
hi,
I am working on a flow that needs to be triggered at a particular time in a day, say at 8.00 pm
I know i can use the Timer nodes in this case, but the problem is that, to set a particular time ... |
| Topic: trailing spaces in TDS mesasge |
suraj
Replies: 6
Views: 5060
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 13, 2008 7:42 am Subject: trailing spaces in TDS mesasge |
hm... i had tried this..but in this case the last element has an value with | as the last byte.
Each record ends with |. So i had the group terminator there.
I guess.. i will add an extra element ... |
| Topic: trailing spaces in TDS mesasge |
suraj
Replies: 6
Views: 5060
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 13, 2008 7:17 am Subject: trailing spaces in TDS mesasge |
I have already described the problem in my post.
The problem is that each record has some trailing spaces at the end. And the parsing fails because of this.
I have also mentioned how did i model t ... |
| Topic: trailing spaces in TDS mesasge |
suraj
Replies: 6
Views: 5060
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 13, 2008 6:51 am Subject: trailing spaces in TDS mesasge |
thnks,
i have modeled the message the same way.
Type1 with DataElementSeparation as all elements delimited by | and group terminator as |, cause i have | at end of each record.
Type2 has an ele ... |
| Topic: trailing spaces in TDS mesasge |
suraj
Replies: 6
Views: 5060
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 13, 2008 6:34 am Subject: trailing spaces in TDS mesasge |
Hi
I have a file that has numner of pipe delimited records. It looks like
gfgdfg|sgg|sgs|1343|
sfsdgg|sdg|sdf|1434|
But after the last "|" there are some blank spaces for e ... |
