standalone dbaccess
Nate asked whether dbaccess can be installed standalone on a client (he kept hitting "Unknown error message 32370"). Replies: dbaccess ships with the Informix Client SDK (3.50/3.70 and later), so installing CSDK and configuring sqlhosts (or the Windows registry) gives you a client-side dbaccess. Alternatives suggested: Jonathan Leffler's sqlcmd, SQSL/Aubit adbaccess, OAT, SquirrelSQL, DtSQL, SQL Explorer, Informix SQL Editor. A side question about scripted CSV output on Windows drew recommendations for sqlcmd and SQSL, though Leffler noted sqlcmd's Windows build hasn't been maintained. Nate thanked the group.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Does anyone know if you can install a standalone dbaccess? or how to do it?
I've been messing with this for two days now and the only thing I get is
Unknown error message 32370.
Thanks,
Nate
Hello.
Dbaccess utility comes together with Informix CSDK, since 3.70 relases (don´t
know exactly the specific release, but you can check it out in Information
Center website).
You just have to configure your sqlhosts file (in linux/unixes), or the
windows registry in windows clients.
Hope it helps.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: nathaniel.hicks@trnswrks.com
> Subject: standalone dbaccess [31405]
> Date: Thu, 12 Sep 2013 09:46:20 -0400
>
> Does anyone know if you can install a standalone dbaccess? or how to do it?
> I've been messing with this for two days now and the only thing I get is
> Unknown error message 32370.
>
> Thanks,
> Nate
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
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
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 9:46 AM, NATE HICKS
<nathaniel.hicks@trnswrks.com>wrote:
> Does anyone know if you can install a standalone dbaccess? or how to do it?
> I've been messing with this for two days now and the only thing I get is
> Unknown error message 32370.
>
> Thanks,
> Nate
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e014939642bafbd04e6319e57
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
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
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.
On 13/09/13 08:21, Habichtsberg, Reinhard 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 > SQSL definitely runs from the a batch file on windows and the whole point of it is that you can do complex SQL scripts. And formats, csv or otherwise, are another of it's strong points. Me thinks you should give it a try - see my sig -- 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
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
Does sqlcmd run on Windows Server 2008 or 2012 and what are the software
requirements to run sqlcmd? Has Informix CSDK and Visual C or another
SDK to be installed on the Windows Server?
Reinhard.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Art
> Kagel
> Sent: Friday, September 13, 2013 1:49 PM
> To: ids@iiug.org
> Subject: Re: standalone dbaccess [31414]
>
> 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
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
Hmm, I haven't tried to compile sqlcmd on windows, honestly. I would
require the CSDK and a C compiler, yes. Download the package, Jonathan is
very thorough, so I'm sure the readme file will tell you if it will work on
Windows. Or perhaps Jonathan will pipe in.
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 8:42 AM, Habichtsberg, Reinhard <
RHabichtsberg@arz-emmendingen.de> wrote:
> Does sqlcmd run on Windows Server 2008 or 2012 and what are the software
> requirements to run sqlcmd? Has Informix CSDK and Visual C or another
> SDK to be installed on the Windows Server?
>
> Reinhard.
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art
> > Kagel
> > Sent: Friday, September 13, 2013 1:49 PM
> > To: ids@iiug.org
> > Subject: Re: standalone dbaccess [31414]
> >
> > 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
> >
> >
> >
> ************************************************************************
> *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply"
SQLCMD compiled on Windows about a decade ago.
Then Microsoft got grumpy about safe function like strcpy() etc safe if
used properly, that is; unsafe when misused and generally made life hell
for someone who's not really interested in investing in their weird
infrastructure. There's the ISO TR 24731-1 (now Annex K of ISO/IEC
9899:2011) Technical Report that documents the C 'safer' functions, with
names like strcpy_s(), but Microsoft doesn't conform to the standard so the
only point of using those functions is defeated by Microsoft. (See
http://stackoverflow.com/questions/372980/do-you-use-the-tr-24731-safe-functions
for
more details.)
I don't have a Windows machine any more (hooray!). SQLCMD has some Win32
support, but it hasn't been actively maintained for quite some time.
AFAICR, I've not done anything to deliberately make it impossible to
compile on Windows, but it is unlikely to be smooth sailing. If you can
persuade ESQL/C to use GCC in a Cygwin environment, it should be
straight-forward. I never found a way to make ESQL/C work nicely at the
Windows command line (it was a complete and utter PITA as far as I was
concerned), let alone work sanely with GCC.
On Fri, Sep 13, 2013 at 6:26 AM, Art Kagel <art.kagel@gmail.com> wrote:
> Hmm, I haven't tried to compile sqlcmd on windows, honestly. I would
> require the CSDK and a C compiler, yes. Download the package, Jonathan is
> very thorough, so I'm sure the readme file will tell you if it will work on
> Windows. Or perhaps Jonathan will pipe in.
>
> 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 8:42 AM, Habichtsberg, Reinhard <
> RHabichtsberg@arz-emmendingen.de> wrote:
>
> > Does sqlcmd run on Windows Server 2008 or 2012 and what are the software
> > requirements to run sqlcmd? Has Informix CSDK and Visual C or another
> > SDK to be installed on the Windows Server?
> >
> > Reinhard.
> >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Art
> > > Kagel
> > > Sent: Friday, September 13, 2013 1:49 PM
> > > To: ids@iiug.org
> > > Subject: Re: standalone dbaccess [31414]
> > >
> > > 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
> > > > > >
> > > > > >
> > > > >@@
Thanks for all the options!
Thanks Jonathan. I see... I would better try to build a linux server and
install SQLCMD there. I believe the job scheduler software has agents for
linux, too.
Reinhard.
Mit freundlichem Gruß
Reinhard Habichtsberg
Dienstleistungsverantwortlicher IT-Rechenzentrum
Bereich Server-, Speicher- und Datenbanksysteme
B-203
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Jonathan Leffler
> Sent: Friday, September 13, 2013 5:35 PM
> To: ids@iiug.org
> Subject: Re: standalone dbaccess [31417]
>
> SQLCMD compiled on Windows about a decade ago.
>
> Then Microsoft got grumpy about safe function like strcpy() etc - safe if
used
> properly, that is; unsafe when misused - and generally made life hell for
> someone who's not really interested in investing in their weird
infrastructure.
> There's the ISO TR 24731-1 (now Annex K of ISO/IEC
> 9899:2011) Technical Report that documents the C 'safer' functions, with
names
> like strcpy_s(), but Microsoft doesn't conform to the standard so the only
point of
> using those functions is defeated by Microsoft. (See
>
> http://stackoverflow.com/questions/372980/do-you-use-the-tr-24731-safe-
> functionsfor
> more details.)
>
> I don't have a Windows machine any more (hooray!). SQLCMD has some Win32
> support, but it hasn't been actively maintained for quite some time.
> AFAICR, I've not done anything to deliberately make it impossible to compile
on
> Windows, but it is unlikely to be smooth sailing. If you can persuade ESQL/C
to
> use GCC in a Cygwin environment, it should be straight-forward. I never
found a
> way to make ESQL/C work nicely at the Windows command line (it was a
> complete and utter PITA as far as I was concerned), let alone work sanely
with
> GCC.
>
> On Fri, Sep 13, 2013 at 6:26 AM, Art Kagel <art.kagel@gmail.com> wrote:
>
> > Hmm, I haven't tried to compile sqlcmd on windows, honestly. I would
> > require the CSDK and a C compiler, yes. Download the package, Jonathan
> > is very thorough, so I'm sure the readme file will tell you if it will
> > work on Windows. Or perhaps Jonathan will pipe in.
> >
> > 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 8:42 AM, Habichtsberg, Reinhard <
> > RHabichtsberg@arz-emmendingen.de> wrote:
> >
> > > Does sqlcmd run on Windows Server 2008 or 2012 and what are the
> > > software requirements to run sqlcmd? Has Informix CSDK and Visual C
> > > or another SDK to be installed on the Windows Server?
> > >
> > > Reinhard.
> > >
> > > > -----Original Message-----
> > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> > > > Of
> > > Art
> > > > Kagel
> > > > Sent: Friday, September 13, 2013 1:49 PM
> > > > To: ids@iiug.org
> > > > Subject: Re: standalone dbaccess [31414]
> > > >
> > > > 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