File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Products » Websphere
Bookmark "WMB ESQL and DB question" Watch "WMB ESQL and DB question" New topic

WMB ESQL and DB question

Alexander Johnson

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:
subject: WMB ESQL and DB question
It's not a secret anymore!