aspose file tools*
The moose likes Websphere and the fly likes WMB ESQL and DB question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "WMB ESQL and DB question" Watch "WMB ESQL and DB question" New topic
Author

WMB ESQL and DB question

Alexander Johnson
Greenhorn

Joined: Nov 03, 2011
Posts: 1
I am intentionally trying to insert on top of a previously entered
row to see how to handle exceptions

I sent the following command in ESQL


This works the first time, but the second time through the code
throughs an exception, and goes out the Failure terminal, where I
can see it in the Trace node

When I UN-CHECK the "Throuw exception on Database error", the flow
no longer throws an error, the output routes through the "Out" terminal

The first time through (on an empty table, successfull insert, the
trace shows:


On the second time through (bad insert cmd trying to overwrite a record),
it agains goes through the 'out' terminal, and the trace node shows:



In the first case I see a local env, but not the "Ret" I was trying to
write to

In the second case I do not see a local env of any sort

SInce both cases do not show a RET, I can not test ret inside of ESQL to
determine if the INSERT completed successfully

How can I do this ?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: WMB ESQL and DB question