Re: Dbaccess without engine

No, but get Jonathan Leffler's sqlcmd package from the IIUG Software Repository. It can be used to script SQL runs just like dbaccess (even has a mode that emulates the dbaccess command line processing). Sqlcmd has several advantages over dbaccess in scripts also, if you want to use these features. For example it has a 'monitor' or server mode that will permit scripts to pipe multiple SQL to a running sqlcmd task without the overhead of connecting and disconnecting for each statement, flexible output formats including XML, etc., a read-only version you can put on production machines that prevents users from executing SQL that can modify data. Check it out. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Apr 12, 2010 at 10:45 PM, James Brunskill < James.Brunskill@fonterra.com> wrote: > Hi, > > > > I am setting up a redhat linux 5 server which will connect to an external > informix server via the CSDK + Perl. > > I would also like be able to access the database using dbaccess, mainly to > run scripts like: > > # dbaccess <databasename> script.sql> > > > Is there any way to install dbaccess without installing the whole database > engine? > > I guess there will be licensing issues to consider as well? > > > > I noticed there is a windows version of dbaccess available for download on > this site: > > > http://www.ibm.com/developerworks/data/library/techarticle/dm-0406chong/index.html > > > > I’m thinking I’ll probably need to write a perl script to run a series of > sql statements from a command file, > > but would be easier to just install dbaccess if that’s option… > > > > Anyone have a good solution? > > > > Regards, > > > > James Brunskill > > Computer Engineer - Manufacturing Execution Systems > > Automation & Process Control Group > > NZ Technical > > Fonterra > > Fonterra Extn: 77808 > > Ext Line: +64 7 849 2411 x 77808 > > email: james.brunskill@fonterra.com<jarrod.teale@fonterra.com> > > > > DISCLAIMER: > This email contains confidential information and may be legally privileged. > If you are not the intended recipient or have received this email in error, > please notify the sender immediately and destroy this email. > You may not use, disclose or copy this email or its attachments in any way. > Any opinions expressed in this email are those of the author and are not > necessarily those of the Fonterra Co-operative Group. > http://www.fonterra.com/ > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >