RE: SQLRPG Question (as Survey for AS/400 Developers (ISERIES) DB2/400)

I'm sorry, but you never have to qualify a file name to SQL.  In fact, if
you want to get creative, you can use a dynamic, embedded SQL statement and
have the program use a different file for each execution.
Bill

> -----Original Message-----
> From: Kaynor@aol.com [SMTP:Kaynor@aol.com]
> Sent: Monday, October 30, 2000 9:08 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      SQLRPG Question (as Survey for AS/400 Developers (ISERIES)
> DB2/400)
> 
> I'm not very knowledgeable about SQLRPG and I'm curious--my cohorts who
> use 
> it say that SQLRPG programs must be recompiled over the exact datafiles
> they 
> will be run against.  
> 
> Can someone explain to me why, and whether there is a way to compile an 
> SQLRPG program so that it can safely use unqualified file names?  I'd like
> to 
> be able to change the library list to run these programs over a different 
> (e.g. Test) data library!
> 
> We have not used SQLRPGLE.
> 
> Apologies if this is an old topic, and thanks in advance for any
> insights....
> --Chapin Kaynor, Vermont
> 
> 
> > ------------------------------
> >  
> >  Date: Fri, 27 Oct 2000 15:05:18 GMT
> >  From: booth@martinvt.com
> >  Subject: RE: Survey for AS/400 Developers (ISERIES) DB2/400
> >  
> >  I am an RPG programmer, and no other kind.  I believe that you believe
> an 
> >  RPG programmer would never willingly choose SQLRPGLE as a solution. 
> >  
> >  I also believe that if you weren't kicking and screaming as someone
> walked 
> >  you through it one time, just one time, that from then on you would 
> >  willingly use SQLRPGLE as one of your tools.  There are some really
> nice 
> >  things SQLRPGLE will do for you.  If some kind and giving mentor will
> hold 
> >  your hand through the first few tries with it you too will become a 
> >  new-generation RPG programmer.
> >  
> >  
> >  _______________________
> >  Booth Martin
> >  Booth@MartinVT.com
> >  http://www.MartinVT.com
> >  _______________________
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---