Hi,

We have a reprot that insert data into a table and then display it. We are triggering the report from JAVA script.

My question is in case of exception scenario like Primary key violation etc., how to return the status of the report run i.e. PASS / FAIL to the JAVA script.

Any help would be appreciated.

Note: i searched in HELP but nothing informative.

This message has been edited. Last edited by: Kerry,

Hi,

Depends on how you update the table. Are you doing that with a simple update or with a stored procedure?

Regards.

Its a simple SQL insert statement.

Hi Vasantha,

There are many techniques on the Techsupport site so you may want to run a quick search. Or, all you might need is something like this:

SQL DB2
DELETE FROM DB2TABLE.CAR
END
-RUN
-IF &RETCODE EQ 'xxx' THEN GOTO yyy; 

Cheers,

Kerry

If you use a xmlhttprequest - Objekt in order to execute the update procedure, you can retrieve the page generated by it and parse it in JavaScript.
Either you just search for the Update-Include...Information generated by the MODIFY TABLE or you generate some Output yourself with -TYPE or similar and search for that information.