... the prepare into descriptor will bring you all information into the
sqlvar section, you would need. Before your fetch you would tell DB2 how
your hostvars are defined with set descriptor. After this the fetch will
make the needed translations.
But. as I mentioned SQL CLI would be more convinient - and this is not
dependent on the language you are using. Never the less modern languages,
like java, are by far easier to us for tasks like this.
As an Amazon Associate we earn from qualifying purchases.
This thread ...
RE: Building dynamic SQL with descriptors, (continued)
This mailing list archive is Copyright 1997-2021 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
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.