| Author |
Message |
 Topic: Need Guidance in the EVAL rounding to the nereast interger |
bharu
Replies: 6
Views: 4015
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 30, 2017 12:18 pm Subject: Need Guidance in the EVAL rounding to the nereast interger |
How could the input file have character right .
You don't know which col you need to convert as decimal.
(Row.col24+28/Row.col15)*(Row.col24-rRow.col2 +Row.col20 ) / 9
expression will be e ... |
| Topic: Need Guidance in the EVAL rounding to the nereast interger |
bharu
Replies: 6
Views: 4015
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 30, 2017 11:18 am Subject: Need Guidance in the EVAL rounding to the nereast interger |
Hi Vic,
Thanks for the response . Here the constraint is we don't know what value we are going to receive from the input. In this case everything is dynamic from the client .
Eg :
(78+28/90) *(78 ... |
| Topic: Need Guidance in the EVAL rounding to the nereast interger |
bharu
Replies: 6
Views: 4015
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 30, 2017 10:40 am Subject: Need Guidance in the EVAL rounding to the nereast interger |
Hi
I am trying to do the EVAL statement . But all the decimal value get rounded to the nearest integer value example ( value is -1.88 means its returning the value as -2). I don't want to pass th ... |
| Topic: Error While Accessing the Database |
bharu
Replies: 1
Views: 1777
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Sep 22, 2012 4:01 am Subject: Error While Accessing the Database |
Hi All,
I am getting the below error while accesing the database from the message broker flow Compute node. In this flow i am using WTX node and the compute naode is next to the WTX node . I am no ... |
| Topic: Error accessing stored procedure |
bharu
Replies: 9
Views: 4401
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 25, 2012 4:24 am Subject: Error accessing stored procedure |
| The issue was solved .It was the problem with stored procedure NOCOUNT only. |
| Topic: Error accessing stored procedure |
bharu
Replies: 9
Views: 4401
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 16, 2012 9:20 pm Subject: Error accessing stored procedure |
Thank you Mqjeff
I am new to this stored procedure concept.Will you please help me what should be defined in the stored procedure to execute and return the multiple records.How can i check the dynami ... |
| Topic: Error accessing stored procedure |
bharu
Replies: 9
Views: 4401
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 16, 2012 5:43 am Subject: Error accessing stored procedure |
I am using
CALL sampleprocedure(In1,In2,Environment.Variables.ResultSet[]); to completely reterive all the records.Its hits the store procedure but doesn't return any value. Where this need to be ... |
| Topic: Error accessing stored procedure |
bharu
Replies: 9
Views: 4401
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 16, 2012 5:18 am Subject: Error accessing stored procedure |
Thank you so much for your valuable response.
Now i am able to Hit the stored procedure.The stored procedure need to return N number of records.I am using the DYNAMIC RESULT SET to retrieve all the r ... |
| Topic: Error accessing stored procedure |
bharu
Replies: 9
Views: 4401
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 16, 2012 1:39 am Subject: Error accessing stored procedure |
Hi All,
while accessing the stored procedure from WMB.I faced some issue,Need to pass IN1 and IN2 parameter. Initially IN1 was character and IN2 was Date datatype.I need to pass IN2 as the date f ... |
