Dbaccess without engine

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 <mailto: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/

On 13/04/2010 03:45, James Brunskill wrote: > Hi, > > I am setting up a redhat linux 5 server which will connect to an > external informix server via the CSDK + Perl. > If you are using Perl, is there some reason you'd not use DBD::Informix? http://search.cpan.org/~johnl/DBD-Informix-2008.0513/Informix.pm > 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, DBD::Informix seems the obvious way to run a series of SQL commands from Perl. > > but would be easier to just install dbaccess if that’s option… > > Anyone have a good solution? > http://www.ibdk.dk/seminar/DBD-Informix-20010508.ppt -- RGB

"James Brunskill" <James.Brunskill@fonterra.com> wrote in message news:mailman.114.1271127245.1071.informix-list@iiug.org... 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've just been looking at this! Even to install the Informix server product on the client server, with no intention to create a database server or otherwise use any binary but Informix, technically requires the purchase of a full licence for that clieent server. This is a rule honoured more in the breach than the observance the world over I imagine, but the fact remains - and I had this confirmed by an IBM UK licensing expert last week - that the licence should be purchased. Aubit4GL and other alternatives suggested would be fine. It's one more thing to install though, if you're not otherwise uing it: it's a pity dbaccess cannot be included in the CSDK.

> Is there any way to install dbaccess without installing the whole database engine? Hi James, Other posters gave you better options, but if you really want to use dbaccess on a client box you still can. I don't think there's a way of doing this without installing the engine though. If your server and client platforms match you can just copy dbaccess binary from the server. If not, install the IDS on the client and delete everything you don't need. You'll need parts of CSDK on the client too (sqlhosts, messages, etc...). Every time you fire up dbaccess it will complain something is missing :) Run strace/truss/whatever is applicable on your client platform, to find out which file(s) dbaccess is trying to open. After few iterations you'll have all you need :) Works on my Linux desktop machine, tested. HTH Davorin

Yes it works, however, note that you are likely in violation of your license. Careful! 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 Tue, Apr 13, 2010 at 6:50 AM, Davorin Kremenjas < davorin.kremenjas@gmail.com> wrote: > > Is there any way to install dbaccess without installing the whole > database engine? > > Hi James, > > Other posters gave you better options, but if you really want to use > dbaccess on a client box you still can. > I don't think there's a way of doing this without installing the > engine though. > If your server and client platforms match you can just copy dbaccess > binary from the server. > If not, install the IDS on the client and delete everything you don't > need. You'll need parts of CSDK on the client too (sqlhosts, messages, > etc...). Every time you fire up dbaccess it will complain something is > missing :) > Run strace/truss/whatever is applicable on your client platform, to > find out which file(s) dbaccess is trying to open. After few > iterations you'll have all you need :) > Works on my Linux desktop machine, tested. > > HTH > > Davorin > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

Neil Truby wrote: > "James Brunskill" <James.Brunskill@fonterra.com> wrote in message > news:mailman.114.1271127245.1071.informix-list@iiug.org... > Hi, > > > Aubit4GL and other alternatives suggested would be fine. It's one more > thing to install though, if you're not otherwise uing it: it's a pity > dbaccess cannot be included in the CSDK. > Agreed. To whom would we "recommend" this option? JWC

"John Carlson" <jwcarlson1@yahoo.com.invalid> wrote in message news:hq75s5$jon$1@speranza.aioe.org... > Neil Truby wrote: >> "James Brunskill" <James.Brunskill@fonterra.com> wrote in message >> news:mailman.114.1271127245.1071.informix-list@iiug.org... >> Hi, >> > >> >> Aubit4GL and other alternatives suggested would be fine. It's one more >> thing to install though, if you're not otherwise uing it: it's a pity >> dbaccess cannot be included in the CSDK. >> > > Agreed. To whom would we "recommend" this option? > > JWC I'm told that the formal way to do it is to raise a PMR and request it.

On 15/04/2010 18:57, Neil Truby wrote: > > "John Carlson" <jwcarlson1@yahoo.com.invalid> wrote in message > news:hq75s5$jon$1@speranza.aioe.org... >> Neil Truby wrote: >>> "James Brunskill" <James.Brunskill@fonterra.com> wrote in message >>> news:mailman.114.1271127245.1071.informix-list@iiug.org... >>> Hi, >>> >> >>> >>> Aubit4GL and other alternatives suggested would be fine. It's one >>> more thing to install though, if you're not otherwise uing it: it's a >>> pity dbaccess cannot be included in the CSDK. >>> >> >> Agreed. To whom would we "recommend" this option? >> >> JWC > > I'm told that the formal way to do it is to raise a PMR and request it. I tend to use sqlcmd, but ... if you don't need support (and, therefore IBM need never know), then copy the libs/message-files/whatever is need to get dbaccess to run. Isn't there a free developer version on IDS on IIUG? The database itself is crippled, but if all you want is dbaccess - with no tech support - well, use that. I don't see the difference, really.