| Author |
Message |
 Topic: Unable to insert ESQL Current_Timestamp into DB2 table |
madhu36r
Replies: 3
Views: 3482
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 01, 2013 11:06 am Subject: [SOLVED] ESQL TIMESTAMP is compatible with DB2 |
HI ALL,
I have a typo in the character representation of a TIMESTAMP value of a column, so I am getting the above exception.
You dod not need to CAST to any character or timestamp.
The ESQL ... |
| Topic: Unable to insert ESQL Current_Timestamp into DB2 table |
madhu36r
Replies: 3
Views: 3482
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 01, 2013 8:24 am Subject: Unable to insert ESQL Current_Timestamp into DB2 table |
Removed the CAST, still got the same exception
SET TEST_TS1 = Environment.Variables.myCurrTsp[1].*[1] ;
Text:CHARACTER:{DB2 FOR OS/390}{ODBC DRIVER}{DSN09015} … DSNT408I SQLCODE = -180 ... |
| Topic: Unable to insert ESQL Current_Timestamp into DB2 table |
madhu36r
Replies: 3
Views: 3482
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 01, 2013 7:55 am Subject: Unable to insert ESQL Current_Timestamp into DB2 table |
Hi All,
I am working with WMB6.1 on mainframe.
I am unable to insert ESQL CURRENT_TIMESTAMP into CURRENT TIMESTAMP of DB2 table.
I tried to map ESQL TIMESTAMP to DB2 Time stamp.
DECLARE mys ... |
| Topic: Looging the exception to an error queue |
madhu36r
Replies: 2
Views: 2066
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Dec 08, 2006 11:44 am Subject: Looging the exception to an error queue |
Greg,
Thanks for your suggestion. I am able to log the message.
The real problem is 2097 0x00000831 MQRC_CONTEXT_HANDLE_ERROR
The issue is with losing the context when the message comes thro ... |
| Topic: Looging the exception to an error queue |
madhu36r
Replies: 2
Views: 2066
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 07, 2006 9:01 am Subject: Looging the exception to an error queue |
Hi
I am newbee to Message broker.
I am getting a message from http input node and trying to handle the exception by logging the error message to a mq queue.. The exception happened when the outp ... |
