Re: Knotty puzzle with chaining to files not known at compile time

["Larry Ducie" <larry_ducie@xxxxxxxxxxx>]

Hi James,

<snip>
Given my only means of accessing SQL is via CLI, it's out of the question 
for the problem at hand.
</snip>

Although SQL may not necessarily be the most appropriate choice for 
addressing your problem I must check your meaning of the word "accessing". 
You can use the QSQPRCED API to dynamically prepare and run SQL statements 
on your system. There is no need to install any of the SQL options or use 
CLI. This API was introduced in V2R3 and supports all the usual SQL usage 
requirements - commitment control, scrollable cursors, cursor positioning, 
various date and time formats, prepare, describe, execute - select, insert, 
update, delete... The only real perculiarity in using this API is that you 
have to handle the result set as you would in java using JDBC. That is, you 
iterate through each column for each row fetched.

As an aside, this structure makes it an excellent choice for dynamically 
creating XML from queries.

Anyway, I have sample code if you wish to consider this option.

Cheers

Larry Ducie