RE: Source Evaluation?

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

Hmmm... hard to say.  I may test.  But since my application is dynamic, I
need to retrieve column names each time (unless it's the same as the last
request).  So you're really mixing ideas here.  how to retrieve the columns
(my question as to a better way) and where and when to do it.  :)

Brad

> -----Original Message-----
> From: kulack@us.ibm.com [mailto:kulack@us.ibm.com]
> Sent: Friday, February 09, 2001 5:11 PM
> To: JAVA400-L@midrange.com
> Subject: RE: Source Evaluation?
> 
> 
> On 02/09/2001 at 04:40:55 PM, owner-java400-l@midrange.com wrote:
> That was one of my concerns.  Although, I still am not quite 
> sure what I
> should do instead.  Any hints?
> 
> SELECT COLUMN_NAME FROM SYSCOLUMNS WHERE TABLE_NAME = 'TAB1' and
> TABLE_SCHEMA='KULACK'                                         
>    ORDER BY
> ORDINAL_POSITION would be useful too 8-)
> 
> In actuality, its hard to say which is faster to execute, but
> this one ends up being MUCH nicer because it can be a SINGLE prepared
> statement, and if you replace 'TAB1' and 'KULACK' with your
> parameter marker (question mark), all you do is setString() for each
> and execute it.
> I.e. you don't prepare and execute every time, you prepare 1 time,
> and setString(), setString(), execute() every time.
> This is a bigger savings.
> 
> 
> "Do you believe that my being stronger or faster has anything
>  to do with my muscles in this place?" ... "Free your mind."
> Laurence Fishburne as Morpheus in 'The Matrix'.
> 
> Fred A. Kulack  -  AS/400e  Java and Java DB2 access, Jdbc, 
> JTA, etc...
> IBM in Rochester, MN  (Phone: 507.253.5982   T/L 553-5982)
> mailto:kulack@us.ibm.com   Personal: mailto:kulack@bresnanlink.net
> AOL Instant Messenger: Home:FKulack  Work:FKulackWrk
> 
> 
> +---
> | 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
> +---
> 
+---
| 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
+---