Re: DB2 trigger doesn't work when INSERT comes from Java app

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Jacob,

Sorry, no idea why you get this error. You might want to refer to the manual SC41-5701 Database Programming which has a chapter on trigger programs, examples in RPG, COBOL and C.

Theo

----- Original Message -----

From: Jacob Madsen

To: JAVA400-L@midrange.com

Sent: vrijdag 28 april 2000 12:32

Subject: Re: DB2 trigger doesn't work when INSERT comes from Java app - Attention Theo Soppe

Hi Theo.

It's no problem to write it in C, the only problem is, that the precompiler for this statement:

"case '2':

{
EXEC SQL

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

}"

returns this error:

SQL0104 30      21 Position 55

Token UNCOMMITTED was not valid. Valid tokens: COMMITTED.

Can you help me out? Is there an error in your code, or am I doing something wrong?

Jacob

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.