Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Dbaccess without engine

99 views
Skip to first unread message

James Brunskill

unread,
Apr 12, 2010, 10:45:06 PM4/12/10
to inform...@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 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.b...@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/

Art Kagel

unread,
Apr 12, 2010, 11:00:05 PM4/12/10
to James Brunskill, inform...@iiug.org
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 (a...@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.



_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list


Mike Aubury

unread,
Apr 13, 2010, 2:10:46 AM4/13/10
to inform...@iiug.org, James Brunskill
Aubit4GL has a dbaccess clone...

On Tuesday 13 April 2010 03:45:06 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.
>
> 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.b...@fonterra.com

> <mailto:jarrod...@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/

--
Mike Aubury

http://www.aubit.com/
Aubit Computing Ltd is registered in England and Wales, Number: 3112827
Registered Address : Clayton House,59 Piccadilly,Manchester,M1 2AQ

RedGrittyBrick

unread,
Apr 13, 2010, 5:05:18 AM4/13/10
to
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

Marco Greco

unread,
Apr 13, 2010, 5:33:48 AM4/13/10
to inform...@iiug.org
sqsl (see sig) ports a standalone dbaccess replacement with a whole bunch of
goodies

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.
>

> 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

--
Ciao,
Marco
______________________________________________________________________________
Marco Greco /UK /IBM Standard disclaimers apply!

Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm

Neil Truby

unread,
Apr 13, 2010, 5:44:02 AM4/13/10
to
"James Brunskill" <James.B...@fonterra.com> wrote in message
news:mailman.114.12711272...@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.

Davorin Kremenjas

unread,
Apr 13, 2010, 6:50:34 AM4/13/10
to
> 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

Art Kagel

unread,
Apr 13, 2010, 7:38:40 AM4/13/10
to Davorin Kremenjas, inform...@iiug.org
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 (a...@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.



John Carlson

unread,
Apr 15, 2010, 9:55:10 AM4/15/10
to
Neil Truby wrote:
> "James Brunskill" <James.B...@fonterra.com> wrote in message
> news:mailman.114.12711272...@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

Neil Truby

unread,
Apr 15, 2010, 1:57:44 PM4/15/10
to

"John Carlson" <jwcar...@yahoo.com.invalid> wrote in message
news:hq75s5$jon$1...@speranza.aioe.org...

I'm told that the formal way to do it is to raise a PMR and request it.

Richard Harnden

unread,
Apr 19, 2010, 4:01:50 PM4/19/10
to

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.

0 new messages