RE: Source Evaluation?

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

> On a seperate note:
> In the getFileName.java, you wouldn't want to execute
> select * just to get the name of the columns. That's perhaps
> overkill depending on the driver and its row blocking, and
> where on the network you are related to your database,
> the executeQuery() may pull lots of data across the wire.
> Your mileage may vary.

After thinking about this, will it really do much harm?  If it works at all
like SQL on the AS/400 the SQL command isn't really run until the first
fetch is issued.  That's when all the magic happens.  Before that, preparing
a statement, etc, doesn't take much at all.

I still agree, though, it's probably not the best way to get the column
names.  Right now I'm looking through the docs for something that may work.
Any assistance would be apreciated.  :)

Brad
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---