Re: isqlperl 1.2 - perl5 ISQL.pm

thabib@dogbert.zentropy.com wrote: > > Has anyone gotten isqlperl 1.2 to compile under any version of perl 5 > and if so... how did you do it? > > Tony Did this about a year ago for both native PERL5 applications and distributed JAVA applications we sell the complete tookit required to do what you want and more it was a signifigant a mount of work. You will be suprised that it has a sorely neede load() and unload() function that deals with duplicates and file compression. We have an interface based on an extension to the isqlperl module also ported to JAVA. A middleware connection manager runs on a Unix box and talks to the 7.X engine. JAVA applets or applications can talk to the database with only a 9K byte class file upload. This works in ALL JDK1.02 and JDK1.1 browsers without the overhead of JDBC. In addition to JAVA the system supports perl5. The package performs great and packs a lot of punch for just about any Web enabled database application you can imagine. The toolkit and source are availible for $25K US for unlimited internal use. The function library (perl5 - JAVA is the same) is as follows (javadoc is available at http://quark.quantumsi.com/java/docs/:) - Jon NAME ISQL.pm - Perl5 dynamic interface to Informix Databases, Copyright 1996,1997 Quantum Systems Integrators, Inc. all rights reserved. SYNOPSIS use ISQL; # functions $status = &isql_execute($sttmnt_or_id, @params); $id = &isql_open($statement, @params); @titles = &isql_titles($id); $sttmnt = &isql_statement($id); $type = &isql_type($id); @types = &isql_columns($id); @row = &isql_fetch($sttmnt_or_id, @params); $status = &isql_close($id); $status = &isql_shutdown(); @databases = &isql_databases(); @status = &isql_get_schema(table, filename, ownership, extents {,fn,nn} ); @status = &isql_load($table, $filename, $delim, $update, $nullcvt {,$debug}); @status = &isql_unload($cmd, $file, $delim, $compress, $checksum); $errmsg = &isql_msg([$code]); @sqlca = &isql_ca(); # exports $isql_code; $isql_autoclose; $isql_attrib; $isql_database; $isql_transactions; $isql_ansi; $isql_online; SIMPLE EXAMPLE use ISQL; &isql_execute("database test") || die "select db test ... $isql_code\\n"; $cid = &isql_open( "select tabname from systables where tabid > 100") || die "open statement ... $isql_code\\n"; while(@row = &isql_fetch($cid)) { printf STDERR "row: @row\\n"; }