|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
