hello *,
[this is all about JDBC]
i want to select a number of rows from a table, given some some key
values. to reduce communication overhead i do not want to perform
multiple SELECT statements but rather prepare the result set/table
completely inside the DB and transfer it to the client appplication when
it is finished.
the first idea was to perform multiple SELECTs in batch mode and
retrieve the union of the result sets. unfortunately this does not work
/ will be removed very soon.
the second idea was to create a temporary table, fill it with the
desired rows and then to select the entire temp table. unfortunately i
did not find a syntax to do that: declaring a cursor is no problem, but
i cannot provide all row qualifiers at once. can i add more rows to a
cursor?
the last idea would be to actually create a table and fill it using
INSERT INTO temptable SELECT .... however, this way i have to construct
a unique table name. i am also not sure about the overhead of
creating/dropping base tables for such operations (i want to retrieve a
few thousand rows).
thanks a lot for any hint,
Raimund
--
Raimund Jacob
\|/ ____ \|/
Pinuts Media+Science GmbH "@'/ ,. \`@"
Potsdamer Str. 96 /_| \__/ |_\
D-10785 Berlin \__U_/
http://www.pinuts.de/ voice: +49 30 590090313 fax: +49 30 590090390
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
