Re: Variable file names in Select from clause in SQPRPGLE?

Dave Murvin wrote:

What manual(s) do you suggest? It seems like when I have looked though some of the SQL manuals, they read more like a standards manual than a how to use it manual. Perhaps a section on "getting started" or an overview or do I just have to bite the bullet and wade though it?

Dave:

Tricky question. Many answers might assume that the asker was familiar enough to recognize the big difference between 'dynamic' and 'static' SQL. Without that concept, it can be difficult to begin narrowing down to a good source.

Personally, I'd probably start with the Information Center. For V5R4, you might navigate down through Database-> Programming-> Embedded SQL programming, and then perhaps hit 'Coding SQL statements in ILE RPG applications' at:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzajp/rzajprpgi.htm
or http://tinyurl.com/66djvy

A fairly clean example is there in the sub-topic 'Example: Dynamic SQL in an ILE RPG application that uses SQL'.

It shouldn't take long to note that the navigation pane there has lots of topics/sub-topics related to SQL and embedded SQL. Unfortunately, it takes the same amount of time to realize that it's not something to pick up in a couple evenings...

Tom Liotta