Run SQL from windows command on an Informix Server
Hi
SZ,
I misunderstood your request,
you want access Informix from DOS !!
I guess you need a scripting tool
thinking about Perl or Wscript ?
-----Original Message-----
From: Support Informix
Sent: 13 December 2005 17:38
To: 'ids@iiug.org'
Subject: RE: Run SQL from windows command on an Informix Server [6084]
Hi SZ,
Yes, it exists,
download and install informix ODBC or JDBC
and use then something like Winsql, MS-Access (hm,hm), ...
succes
-----Original Message-----
From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org]
Sent: 13 December 2005 15:47
To: ids@iiug.org
Subject: Run SQL from windows command on an Informix Server [6084]
Hi,
There is any way to execute an SQL command (eg select * from table) from a
command window (dos prompt window) from a windows2000/XP client PC "against"
on a windows2000 based Informix 9.x server.
(Something like dbaccess but remotely, executed from client pc on another
windows based informix server 9.x)?
Thanks in advance
SZ
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde
en
vertrouwelijk. Indien dit bericht niet voor U bestemd is, gelieve dit dan te
vernietigen en
de verzender te verwittigen. Openbaring, vermenigvuldiging, verspreiding en
verstrekking aan
derden is niet toegestaan, tenzij anders vermeld. Aangezien internet de
integriteit van dit
bericht niet kan verzekeren, kan de Dienst Vreemdelingenzaken niet
verantwoordelijk gesteld
worden indien dit bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention exclusive
de ses
destinataires et sont confidentiels. Si vous recevez ce message par erreur,
merci de le
detruire et d'en avertir l'expediteur. Toute utilisation de ce message non
conforme a sa
destination, toute diffusion ou toute publication, totale ou partielle, est
interdite, sauf
autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de
ce message,
l'Office des Etrangers decline toute responsabilite au titre de ce message,
dans l'hypothese
ou il aurait ete modifie.
Visitez notre site web: http://www.dofi.fgov.be
Hi SZ,
Yes, it exists,
download and install informix ODBC or JDBC
and use then something like Winsql, MS-Access (hm,hm), ...
succes
-----Original Message-----
From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org]
Sent: 13 December 2005 15:47
To: ids@iiug.org
Subject: Run SQL from windows command on an Informix Server [6084]
Hi,
There is any way to execute an SQL command (eg select * from table) from a
command window (dos prompt window) from a windows2000/XP client PC "against"
on a windows2000 based Informix 9.x server.
(Something like dbaccess but remotely, executed from client pc on another
windows based informix server 9.x)?
Thanks in advance
SZ
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde
en
vertrouwelijk. Indien dit bericht niet voor U bestemd is, gelieve dit dan te
vernietigen en
de verzender te verwittigen. Openbaring, vermenigvuldiging, verspreiding en
verstrekking aan
derden is niet toegestaan, tenzij anders vermeld. Aangezien internet de
integriteit van dit
bericht niet kan verzekeren, kan de Dienst Vreemdelingenzaken niet
verantwoordelijk gesteld
worden indien dit bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention exclusive
de ses
destinataires et sont confidentiels. Si vous recevez ce message par erreur,
merci de le
detruire et d'en avertir l'expediteur. Toute utilisation de ce message non
conforme a sa
destination, toute diffusion ou toute publication, totale ou partielle, est
interdite, sauf
autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de
ce message,
l'Office des Etrangers decline toute responsabilite au titre de ce message,
dans l'hypothese
ou il aurait ete modifie.
Visitez notre site web: http://www.dofi.fgov.be
Your
best bet is going to be using VBScript with ADO. The Informix client SDK and
IConnect has the necessary the ODBC and OLEDB drivers. You can than query the
database (I've done this with 7.3 and 9.X servers) and retrieve data that
extract within the
VBScript program. There are a few things that you include in your VBScript to
make
accessing your data easier. Drop me an email if you need specifics.
Regards,
Charles Rutledge
Centauri Computer Works
centauri@pobox.com
> -----Original Message-----
> From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org]
> Sent: 13 December 2005 15:47
> To: ids@iiug.org
> Subject: Run SQL from windows command on an Informix Server [6084]
>
> Hi,
>
> There is any way to execute an SQL command (eg select * from table) from a
> command window (dos prompt window) from a windows2000/XP client PC "against"
> on a windows2000 based Informix 9.x server.
> (Something like dbaccess but remotely, executed from client pc on another
> windows based informix server 9.x)?
>
>
>
> Thanks in advance
>
>
> SZ
dbaccess could do that.
I think some place inside IBM there is a standalone dbaccess.
So I suppose that if you have all the client access installed the you
could use this "dbaccess" to execute a query against a remote database
not only that it resides on Windows... it could be anywhere IDS is
supported.
J.
sergios.zag.... escribis:
> Hi,
>
> There is any way to execute an SQL command (eg select * from table) from a
> command window (dos prompt window) from a windows2000/XP client PC "against"
> on a windows2000 based Informix 9.x server.
> (Something like dbaccess but remotely, executed from client pc on another
> windows based informix server 9.x)?
>
>
>
> Thanks in advance
>
>
> SZ
Hi,
There is any way to execute an SQL command (eg select * from table) from a
command window (dos prompt window) from a windows2000/XP client PC "against"
on a windows2000 based Informix 9.x server.
(Something like dbaccess but remotely, executed from client pc on another
windows based informix server 9.x)?
Thanks in advance
SZ