Re: Informix SE 7

The last few things can be done from the command line or a shell script - if you are running unix/linux I'm assuming you can deal with that. You may have to set a few ENVIRONMENTAL variables - check out the .profile or .login from the informix users home dir. isql dbname queryname > redirected output location 2> redirected stderr Do you have to run the report as the informix user? This is not standard. If you need to create a user account (say 'rptuser') on your UNIX box and have the DBA 'grant connect, select to rptuser on dbname'; Sounds like a pretty simple task - but if you have NO Informix dba in house you should go to /www.ibm.com/informix click on link to library in left frame and scroll down to servers - you will have to dig a couple of layers but you are looking for SQL, Admin Guide, etc. for Informix SE 7.x. PDFs for free - download them to your local box for faster access if you have space. Good luck Rob > 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.