Hi Sven,

indeed, it is not a good idea at all in JDBC, 
and not supported (and will not).  

However, in SQL Studio you can do:

insert into x values (123)
//
select * from x

and mark and execute all together by one button-press.
 
Regards

Alexander Schr�der
SAP Labs Berlin

> -----Original Message-----
> From: Sven K�hler [mailto:skoehler@;upb.de]
> Sent: Friday, November 01, 2002 4:19 PM
> To: [EMAIL PROTECTED]
> Subject: execute more than one statement at a time?
> 
> 
> hi!
> 
> i thought it would be a good idea to do the following:
> 
> insert into table set test=?;
> select table.currval from sysdba.dual;
> 
> but both, SQLStudio and the JDBC-driver, don't seem to accept two 
> statements at once. Perhaps this isn't even a good idea, 
> because binding 
> parameters will get to complicated.
> 
> 
> 
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
> 
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to