Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Begin/End Atomic and JDBC

3 views
Skip to first unread message

Tim Kuchlein

unread,
Jul 12, 2001, 11:14:23 PM7/12/01
to
Hi All

Does anyone out there happen to know if you can use the following:

begin atomic
<1st statement>;
<2nd statement>;
.....
end atomic%

with a JDBC connection? I know that I could recode the SQL that I'm using
in Java but I would rather just use the SQL that I already have. Any ideas?

thanks in advance
tim

Ps. My environment is Win2K WE v7.1 fp3 or v7.2 and Linux EEE v7.1 fp3 or
v7.2.


Serge Rielau

unread,
Jul 13, 2001, 9:27:09 AM7/13/01
to
Hi Tim,

Yo and No...

In principle you can use dynamic compound statements in JDBC, ODBC and CLI.
However there was a bug with the batch mode which chops of statements after each
';' leading to syntax errors a ala: End of statement found, expected ';'. You
can request the fix from support.

inline SQL PL is not yet supported for EEE. This includes dynamic compounds and
the usage of precedural logic and local vars in SQL Functions and Triggers.
This will be supported in the next release.

Cheers
Serge


0 new messages