| Author |
Message |
 Topic: working with environment variables |
LearningMB
Replies: 5
Views: 2299
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jan 23, 2014 3:01 am Subject: Re: working with environment variables |
I am totally new to MB with very less training. 
Ask your manager / team leader to provide you some formal education. Alternatively you can read the infocentre. This IS NOT a training forum. ... |
| Topic: working with environment variables |
LearningMB
Replies: 5
Views: 2299
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jan 23, 2014 1:54 am Subject: working with environment variables |
I want to get the database value to environment variable and assign to a local variable so that i could do some manipulations on it and store it back to the database. I am doing something like this
S ... |
| Topic: difference between to timestamps |
LearningMB
Replies: 4
Views: 2424
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jan 22, 2014 6:13 am Subject: difference between to timestamps |
While i debug the code in message broker toolkit. It's the MB's debuggger
EDIT by exerk: Please post in the correct forum next time, thank you. Moved to the more appropriate forum. |
| Topic: difference between to timestamps |
LearningMB
Replies: 4
Views: 2424
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jan 22, 2014 5:55 am Subject: difference between to timestamps |
I am trying the following. But the debugger stops at the last line and does not move forward at all. Please let me know the correct way to achieve this.
Declare PutTime INTERVAL;
SET PutTime ... |
| Topic: Date/Time conversion and Concatenation |
LearningMB
Replies: 2
Views: 2500
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jan 21, 2014 11:01 pm Subject: Date/Time conversion and Concatenation |
It's working now. I forgot the SET keyword
I am new to MB... Hence the mistake
Thanks for your help! |
| Topic: Date/Time conversion and Concatenation |
LearningMB
Replies: 2
Views: 2500
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jan 21, 2014 10:53 pm Subject: Date/Time conversion and Concatenation |
The code below is giving Syntax error. Please help me with how do I convert the date to Character.
DECLARE MQMD_TS CHARACTER;
MQMD_TS = CAST(InputRoot.MQMD.PutDate AS CHARACTER);
Further I wan ... |
| Topic: transform arbitrarily timestamp of type dateTime |
LearningMB
Replies: 9
Views: 8308
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jan 21, 2014 4:48 am Subject: transform arbitrarily timestamp of type dateTime |
| What is IU here? |
| Topic: Conversion of timestamp - GMT to EST using ESQL |
LearningMB
Replies: 4
Views: 7783
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jan 21, 2014 4:08 am Subject: Conversion of timestamp - GMT to EST using ESQL |
I tried this. But it say's Syntax error. No other compilation error 
DECLARE INTRVL CHARACTER;
DECLARE CURR_TMSP TIMESTAMP;
SET INTRVL = LOCAL_TIMEZONE;
SET NEW_TMSP = TIMESTAMP CURR_TMSP + ... |
| Topic: Conversion of timestamp - GMT to EST using ESQL |
LearningMB
Replies: 4
Views: 7783
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jan 21, 2014 2:26 am Subject: Conversion of timestamp - GMT to EST using ESQL |
Hi,
I am a new bee to MB and ESQL. I need to write a code to convert a given timestamp from GMT to EST. Any help on this is highly appreciated. |
