| Author |
Message |
 Topic: Broker 6.0.0.6 Update Package Help |
kayhansefat
Replies: 0
Views: 1425
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 11, 2008 4:56 am Subject: Broker 6.0.0.6 Update Package Help |
Hi,
I am installing the 6.0.0.6 update to the Broker on Linux x86 and just wanted to check a couple of messages that are coming up prior to the install before I continue.
The first is when I spe ... |
| Topic: PASSTHRU Database BLOB - Help needed |
kayhansefat
Replies: 2
Views: 2471
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 02, 2007 4:29 am Subject: PASSTHRU Database BLOB - Help needed |
| Any ideas how to pass a string in Java to a BLOB database field using Passthru guys? |
| Topic: PASSTHRU Database BLOB - Help needed |
kayhansefat
Replies: 2
Views: 2471
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 01, 2007 2:23 am Subject: PASSTHRU Database BLOB - Help needed |
Just a note that IF the DAT field was a varchar:
MbSQLStatement state = createSQLStatement("IETESTDB", "PASSTHRU('INSERT INTO STD_REQUEST (DAT) VALUES (''" + dat + "'')';&q ... |
| Topic: PASSTHRU Database BLOB - Help needed |
kayhansefat
Replies: 2
Views: 2471
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 01, 2007 2:19 am Subject: PASSTHRU Database BLOB - Help needed |
| Hi I have a database table (DB2) that I am creating a new record in from a Java Compute Node. I can successfully write a new record to the table with VarChar, Char data types etc. But I am having trou ... |
| Topic: Date - Date = Interval in Days Problem |
kayhansefat
Replies: 6
Views: 5020
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Sep 25, 2007 4:55 am Subject: Date - Date = Interval in Days Problem |
Yes that is what I have ended up doing and it works. The INTERVAL is being correctly set (and hence the integer) but the INTERVAL's value was not being shown in the debug variable list!
Thanks for ... |
| Topic: Date - Date = Interval in Days Problem |
kayhansefat
Replies: 6
Views: 5020
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Sep 25, 2007 12:31 am Subject: Date - Date = Interval in Days Problem |
| Yes VK you are indeed right, doing a trace on it I can see that it is set correctly, thanks. The variable's value was not set in the Variable List in the Debug Perspective though. |
| Topic: Date - Date = Interval in Days Problem |
kayhansefat
Replies: 6
Views: 5020
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Sep 24, 2007 6:38 am Subject: Date - Date = Interval in Days Problem |
Thanks vk.
I have been debugging the flow with the RAC. When that line is run, 'output1' is still NULL - no change. |
| Topic: Date - Date = Interval in Days Problem |
kayhansefat
Replies: 6
Views: 5020
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Sep 24, 2007 5:07 am Subject: Date - Date = Interval in Days Problem |
Hi,
I am trying:
DECLARE output1 INTERVAL;
DECLARE hello DATE CURRENT_DATE;
DECLARE testDate DATE '2004-09-13';
SET hello = hello + INTERVAL '5' DAY;
SET output1 = (hello - testDate ... |
| Topic: Execution Group Memory Usage Problem |
kayhansefat
Replies: 1
Views: 5335
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Sep 11, 2007 6:36 am Subject: Execution Group Memory Usage Problem |
| I have a large file containing approx 480,000 records from which I need to create a message for each. I therefore have a JCN which reads the file and for each line, creates a new message and propagate ... |
| Topic: Call DB2 Stored Procedure from JCN |
kayhansefat
Replies: 1
Views: 2385
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 16, 2007 5:50 am Subject: Call DB2 Stored Procedure from JCN |
In a compute node I have managed to call a stored procedure in DB2 by:
CREATE PROCEDURE getMessageID(OUT messageID INT) EXTERNAL NAME GETMSGID;
DECLARE newMsgID INT;
CALL getMessageID&# ... |
| Topic: Cast Character to Time |
kayhansefat
Replies: 10
Views: 5706
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 07, 2007 1:20 am Subject: Cast Character to Time |
Well running the 'date' command confirms:
Tue Aug 7 09:41:37 BST 2007
British Summer Time - which is correct as it is. I guess then that the CAST function presumes that time1 is in GMT and hence ... |
| Topic: Cast Character to Time |
kayhansefat
Replies: 10
Views: 5706
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 07, 2007 12:32 am Subject: Cast Character to Time |
| Any ideas on this even though my timezone is set to Europe/London???? |
| Topic: Cast Character to Time |
kayhansefat
Replies: 10
Views: 5706
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 06, 2007 3:20 am Subject: Cast Character to Time |
| jefflowrey - Thanks for your post, I have checked the timezone in Linux system settings and it is set to 'Europe/London'. |
| Topic: Cast Character to Time |
kayhansefat
Replies: 10
Views: 5706
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 06, 2007 3:15 am Subject: Cast Character to Time |
Linux AS v3
Broker 6.0.0.4
Tried it again in a new project and still applies as I described! |
| Topic: Cast Character to Time |
kayhansefat
Replies: 10
Views: 5706
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 06, 2007 1:53 am Subject: Cast Character to Time |
I have the following:
DECLARE time1 CHARACTER;
DECLARE time2 TIME;
SET time1 = '13:43:00';
time2 = CAST(time1 AS TIME FORMAT 'HH:mm:ss');
How come time2 now is 14:43:00.000 ????
In the h ... |
