IDS Forum

Re: standalone dbaccess

Posted By: Art Kagel
Date: Friday, 13 September 2013, at 7:48 a.m.

In Response To: RE: standalone dbaccess (Habichtsberg, Reinhard)

Jonathan's sqlcmd is ideal for this. It even has a "server" mode that sets
it into memory reading SQL from a pipe so that scripts can send multiple
commands without the overhead of repeatedly starting up the app and
connecting to the database. It implements .csv format output as well as
traditional Informix delimited, fixed format, and XML output.

Art

Art S. Kagel, Principal Consultant

Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

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 Fri, Sep 13, 2013 at 3:21 AM, Habichtsberg, Reinhard <
RHabichtsberg@arz-emmendingen.de> wrote:

> Hi Art and Marco
>
> Because we had a meeting here yesterday to discuss a tool that meet the
> following demands...:
>
> - Runs from commandline or better within a batch script (windows)
> - connects to the databaseserver
> - runs the queries and receives the resulting data
> - allows to send the output in a csv-file with a certain format
>
> my question: Are some of the free options are able to achieve what we
> need.
>
> Background is: We need to start queries from a jobscheduler software and
> have to store the results in a certain format for further processing.
>
> TIA
> Reinhard
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art
> > Kagel
> > Sent: Thursday, September 12, 2013 8:37 PM
> > To: ids@iiug.org
> > Subject: Re: standalone dbaccess [31410]
> >
> > Oh darn, I meant to mention both! My excuse? Antihistimine fog - and I
> sticking to
> > that!
> >
> > Art
> >
> > Art S. Kagel, Principal Consultant
> >
> > Advanced DataTools (www.advancedatatools.com)
> > Blog: http://informix-myview.blogspot.com/
> >
> > 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 Thu, Sep 12, 2013 at 2:00 PM, Marco Greco <marco@4glworks.com>
> wrote:
> >
> > > On 12/09/13 16:44, Art Kagel wrote:
> > > > If you are running one of the later releases of 11.50 or later,
> you
> > > > can install the Client SDK version 3.50 or later on your clients
> > > > which now contains a copy of dbaccess. Also note that if you just
> > > > need SQL command execution, there are several other free options:
> > > >
> > > > - Jonathan Leffler's sqlcmd utility in the IIUG Software
> Repository
> > > >
> > > > - OAT - www.openadmintool.org (but also included with the CSDK)
> > > >
> > > > - SquirrelSQL - http://squirrel-sql.sourceforge.net/
> > > >
> > > > - Informix SQL Editor - https://code.google.com/p/ifmx-sql-editor/
> > > >
> > > > - DtSQL - http://dtsql.com/
> > > >
> > > > - SQL Explorer - http://eclipsesql.sourceforge.net/
> > > >
> > > > Art
> > > >
> > > > Art S. Kagel, Principal Consultant
> > > >
> > >
> > > And let's not forget Aubit adbaccess or SQSL
> > >
> > > --
> > > 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
> > >
> > >
> > >
> > >
> >
> ************************************************************************
> *******
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11c34b48130d0804e633efdc
> >
> >
> >
> ************************************************************************
> *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a11c23c884b0ab804e6426f8e

Messages In This Thread

• standalone dbaccess
  NATE HICKS -- Thursday, 12 September 2013, at 9:46 a.m.
  • RE: standalone dbaccess
    Alexandre Marini -- Thursday, 12 September 2013, at 10:29 a.m.
  • Re: standalone dbaccess
    Art Kagel -- Thursday, 12 September 2013, at 11:44 a.m.
    • Re: standalone dbaccess
      Marco Greco -- Thursday, 12 September 2013, at 2:00 p.m.
      • Re: standalone dbaccess
        Art Kagel -- Thursday, 12 September 2013, at 2:36 p.m.
        • RE: standalone dbaccess
          Habichtsberg, Reinhard -- Friday, 13 September 2013, at 3:21 a.m.
          • Re: standalone dbaccess
            Marco Greco -- Friday, 13 September 2013, at 3:39 a.m.
          • Re: standalone dbaccess
            Art Kagel -- Friday, 13 September 2013, at 7:48 a.m.
            • RE: standalone dbaccess
              Habichtsberg, Reinhard -- Friday, 13 September 2013, at 8:42 a.m.
              • Re: standalone dbaccess
                Art Kagel -- Friday, 13 September 2013, at 9:26 a.m.
                • Re: standalone dbaccess
                  Jonathan Leffler -- Friday, 13 September 2013, at 11:34 a.m.
                  • RE: standalone dbaccess
                    Habichtsberg, Reinhard -- Monday, 16 September 2013, at 1:58 a.m.
  • Re: standalone dbaccess
    NATE HICKS -- Friday, 13 September 2013, at 11:59 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.