Hi :
I can send to the server two or more sentences ( Inserts, Update, Deletes ) together to the server ?
Like this :
begin insert into test ( id, desccription ) values ( 1, 'Test1'); insert into test ( id, desccription ) values ( 2, 'Test2'); insert into test ( id, desccription ) values ( 3, 'Test3'); end
This is not possible with SAP DB. Iy you want to execute the same statement with different values, you might want to use the batch facilities built into the programming interfaces
- the C/C++ precompiler allows you to specify arrays as host variables
- JDBC has addBatch and executebatch on PreparedStatements
- ODBC has something similar, although this is not available to all programming interfaces built upon ODBC (Perl, PHP)
If you want to load large sets of data into the database, the SAP DB Loader would be the right tool.
Daniel Dittmar
-- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
