Re: Informix SE 7

Posted in 2003

Zev Berezin — Thu, 15 May 2003 11:55:09 -0400 — source: Usenet: comp.databases.informix

<color><param>0100,0100,0100</param>Here is for the isql part Anything within <<> should be supplied by user. isql <<DatabaseName> <<file with .sql extension> will execute SQL statements in <<file.sql> or isql - </color><<file with .sql extension> and the first line in the .sql file should be database <<DatabName> would also work. The .sql file accepts regular SQL statements. In the isql command you could leave off the .sql extension. HTH, Zev Berezin<color><param>0100,0100,0100</param> On 15 May 2003, at 11:58, qwerty wrote: <color><param>7F00,0000,0000</param>> I have a requirement to automate a report query in Informix - total > newbie - non informix user - I require an idiots guide to do this > please ! > > I would :- > login to informix > type isql > choose database > choose query > execute > > Questions :- > 1) how can/do I automate this without interaction. > 2) how can I then execute this from a unix/linux command prompt, ie > run informix and run the query. > > Thanks > > T. > > >