RE: Run SQL from windows command on an Informix Server
Hi,
As an alternative to prepare a Win[2k|23|XP] client using dbaccess remotely
you may follow the techarticle instructions, found at following URL:
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0406chong/index
.html
HTH,
Robert
Robert Seifert
_________________________________________________________________
IBM Deutschland GmbH, Information Management , Software,
Informix Products, Advanced Support
Elite VAR support engineer
Development Support for IBM Informix Products on-site @ SAP
c/o SAP AG, -TechDev05-, Dietmar-Hopp-Allee 16, D-69190 Walldorf, Germany
forum.subscriber@iiug.org wrote on 14.12.2005 04:04:53:
> 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 thanquery
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