PURE DYNAMIC SQL in PERL

Posted in 1999

mharolkar@my-deja.com — Thu, 23 Sep 1999 21:16:23 GMT — source: Informix-list mailing list archive (1991-1998)

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.

↪ replying to mharolkar@my-deja.com

Steven Wilcoxon — Thu, 23 Sep 1999 17:39:21 -0400 — source: Informix-list mailing list archive (1991-1998)

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.

↪ replying to mharolkar@my-deja.com

Tony Costa — Fri, 24 Sep 1999 02:28:35 GMT — source: Informix-list mailing list archive (1991-1998)

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.

↪ replying to Tony Costa

mharolkar@my-deja.com — Mon, 27 Sep 1999 16:18:02 GMT — source: Informix-list mailing list archive (1991-1998)

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.