Re: Functions List in Informix Database.

Arivin wrote: > > Could someone suggest a way to dynamically list all the function within the > Informix database. > TIA. > Arivin. A quick perusal of the manual reveals that this should work: SELECT procname FROM informix.sysprocedures; If you want to be more specific about *functions*, ie those returning a single scalar value, you need to do some fancy work on the table informix.sysprocbody. Can you be more specific about what you need? -- 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. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/