informix client to load and download

Posted in 2016

Topics: Server Administration, Migration, Import/Export & Data Conversion

JACOBO BALBUENA — Wed, 22 Jun 2016 08:35:23 — source: IIUG Forums & Mailing Lists

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

↪ replying to JACOBO BALBUENA

Fernando Nunes — Wed, 22 Jun 2016 08:38:18 — source: IIUG Forums & Mailing Lists

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

↪ replying to Fernando Nunes

JACOBO BALBUENA — Wed, 22 Jun 2016 08:52:31 — source: IIUG Forums & Mailing Lists

Thanks for answer! I'll look for it. Please tell me that it doesnt require trust (rhost hostequiv kind) between client and database.

↪ replying to JACOBO BALBUENA

Andreas Legner — Wed, 22 Jun 2016 09:16:31 — source: IIUG Forums & Mailing Lists

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

↪ replying to Andreas Legner

JACOBO BALBUENA — Wed, 22 Jun 2016 09:40:45 — source: IIUG Forums & Mailing Lists

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.

Glossary

dbaccess