Re: Using *LIBL/table name in SQL statements?

Hi Chad,

You can definitely define Library Name & Table at run time.  Use SQL
"PREPARE" Statement.


Thanks




Sandeep Badve
Crowe Chizek and Company LLC
Ph (317) 569 - 8989  Ext. 6152
sbadve@xxxxxxxxxxxxxxx


                                                                           
             "cornelius, chad"                                             
             <chad.cornelius@j                                             
             udicial.state.co.                                          To 
             us>                       "'JAVA400-L@xxxxxxxxxxxx'"          
             Sent by:                  <JAVA400-L@xxxxxxxxxxxx>            
             java400-l-bounces                                          cc 
             @midrange.com                                                 
                                                                   Subject 
                                       Using *LIBL/table name in SQL       
             10/30/2003 09:41          statements?                         
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Java Programming                                              
             on and around the                                             
              iSeries / AS400                                              
             <java400-l@midran                                             
                  ge.com>                                                  
                                                                           
                                                                           




Does anyone know if it is possible to use some thing similar to *LIBL/table
name in SQL statements?  I know explicitly defining library/table name
works, but I need to read from a user's current library list, which defers
from location to location.  Any help would be greatly appreciated.



Thanks,

Chad



_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.