Re: passing variables to sql statements in a Unix shell script

Kirt wrote: > > I am trying to pass a variable array in the from statement to select from a > list of table in a loop. I have been unable to make it work. Is there a > way and if so how? > > I also am trying to pass a variable into a statement using a where like > statement. > > I.E. sqlstmt ' delete from (variable array) where description like > "%(variable)%" ' > > I do not know the version of the Informix database although it is at least > one or two years old. It is running on AIX 3.2 and UnixWare 2.03 > > If anyone has any suggestions for me I will appreciate them. > kirt_t@msn.com Kirt, could you post the code or more details, please? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/ ---