PURE DYNAMIC SQL in PERL
mharolkar asked whether a pure dynamic SQL application, with unknown query and result set, can be written in Perl with DBD/DBI. Steven Wilcoxon said yes: DBD::Informix exposes the selected columns and their types, and the query is just a string. Tony Costa asked about setup and support risk; mharolkar pointed to the DBD-Informix install notes, the source and sample programs.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Is it possible to write a pure dynamic sql app. in perl using DBD/DBI, where the incoming query and and the resultset are unknown ! Thanks in advance .. Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.
Sure thing. DBD::Informix has information available on what columns were selected and the column type. The Query intself is a simple string. You do need the standard error catching. S.W. <mharolkar@my-deja.com> wrote in message news:7se5ar$qh9$1@nnrp1.deja.com... > Is it possible to write a pure dynamic sql app. in perl using DBD/DBI, > where the incoming query and and the resultset are unknown ! > > Thanks in advance .. > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.
Could you possibly offer some help regarding setting up an Informix DBI DBD configuration? I want to be able to do this for our programmer, but my recent visit to the cpan Perl site had much info removed. Where can I go to read up on this. Also is there any risk to the production database integrity or will Informix swear off support because its not "commercial" software?? TIA! Tony mharolkar@my-deja.com wrote: > Is it possible to write a pure dynamic sql app. in perl using DBD/DBI, > where the incoming query and and the resultset are unknown ! > > Thanks in advance .. > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.
In article <37EAE0CF.9D49C1CC@bellatlantic.net>, Tony Costa <tcosta@bellatlantic.net> wrote: > Could you possibly offer some help regarding setting up an Informix DBI > DBD configuration? > I want to be able to do this for our programmer, but my recent visit to > the cpan Perl site had much info removed. You can refer to the Installation notes that appear with the packages . http://www.perl.com/CPAN/modules/by-module/DBD/DBD-Informix-0.60.readme In addition to this if you are familiar with esql/c you can go through the source. There are some tutorials as well . See a sample program on the Informix site .. http://examples.informix.com > Where can I go to read up on this. Also is there any risk to the > production database integrity or will Informix swear off support because > its not "commercial" software?? > > TIA! > Tony > > mharolkar@my-deja.com wrote: > > > Is it possible to write a pure dynamic sql app. in perl using DBD/DBI, > > where the incoming query and and the resultset are unknown ! > > > > Thanks in advance .. > > > > Sent via Deja.com http://www.deja.com/ > > Share what you know. Learn what you don't. > > Sent via Deja.com http://www.deja.com/ Before you buy.