informix client to load and download
Jacobo Balbuena sought a free SQL client with load and unload, since dbaccess is not allowed on the server. Fernando Nunes suggested sqlcmd by Jonathan Leffler from the IIUG files area. Andreas Legner mentioned the stand-alone CSDK dbaccess, which still needs authentication or trust, and external tables on NFS. Jacobo found external tables unwieldy; no ideal tool was settled on.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi.
Do you know about any free sql client that allows the load and unload command.
Access to machine is not allowed in my work so they can't use dbaccess.
Server studio unload /load command is not free (I think)
Squirrel allows downloads but you must select each select and go to options to
select download options. Its very slow if you really have to download lots of
selects.
Sqleditor worked like a charm until it was deprecated, now it crashes when you
try to download new types of data like bigints.
...
Anything I'm missing?
Thanks in advance
sqlcmd from Jonathan Leffler, available on IIUG files area.
Regards
On Wed, Jun 22, 2016 at 9:35 AM, JACOBO BALBUENA <jacobo.bc@gmail.com>
wrote:
> Hi.
>
> Do you know about any free sql client that allows the load and unload
> command.
> Access to machine is not allowed in my work so they can't use dbaccess.
>
> Server studio unload /load command is not free (I think)
>
> Squirrel allows downloads but you must select each select and go to
> options to
> select download options. Its very slow if you really have to download lots
> of
> selects.
>
> Sqleditor worked like a charm until it was deprecated, now it crashes when
> you
> try to download new types of data like bigints.
>
> ....
> Anything I'm missing?
>
> Thanks in advance
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--94eb2c05665c230da40535d9da64
Thanks for answer! I'll look for it. Please tell me that it doesnt require trust (rhost hostequiv kind) between client and database.
There also is a stand-alone dbaccess nowadays (part of CSDK) that can be=20
used remotely, but any remote connection will require some form of=20
authentication - or trust.
What about external tables, maybe residing on an NFS mount?
Andreas
From: "JACOBO BALBUENA" <jacobo.bc@gmail.com>
To: ids@iiug.org
Date: 22.06.2016 10:53
Subject: Re: informix client to load and download [37300]
Sent by: ids-bounces@iiug.org
Thanks for answer! I'll look for it.=20
Please tell me that it doesnt require trust (rhost hostequiv kind) between =
client and database.=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
External tables could work but then I'll have to watch over the nfs and what
are they creating in the database... If they have select permision but can't
open a shell to use dbaccess in the server they should have an easier way to
download what they want without asking the dba to do it for them.
I used sqleditor years ago when I was developer, I'm sad it doesn't work with
modern data now because it was fast and worked very well.