scripting dbaccess with batch
Hi
how to do scripts using dbaccess in dos batch ?
something like unix
dbaccess db << E
statement;
E
thanks in advance
AFAIK batch doesn't support anything like the UNIX shells' 'here script'
feature. You will have to write the SQL to a file and run the file:
dbaccess mydatabase script.sql
Art
Art S. Kagel
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, Mar 29, 2012 at 8:55 AM, SMITH JOHN <daylight@webmails.com> wrote:
> Hi
>
> how to do scripts using dbaccess in dos batch ?
>
> something like unix
>
> dbaccess db << E
> statement;
> E
>
> thanks in advance
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae9340661c47bad04bc6158ef
echo unload to %CVPHOME%\\\\log\\\\informix\\\\cvplog.txt select * from log order =
by messagedatetime; | dbaccess <database>=20
for example.
j.
On Mar 29, 2012, at 8:55 AM, SMITH JOHN wrote:
> Hi=20
>=20
> how to do scripts using dbaccess in dos batch ?=20
>=20
> something like unix=20
>=20
> dbaccess db << E=20
> statement;=20
> E=20
>=20
> thanks in advance=20
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>=20