How to check current database in SQL

Posted in 1998

Glyn_Balmer_at_erith@smtpgwy.supertension.com — Tue, 24 Feb 98 12:30:47 GMT — source: Informix-list mailing list archive (1991-1998)

I have a number of triggers defined on various events that, when fired, execute procedures resulting in a SYSTEM call (yes, I know it's not very efficient etc etc ...). My problem is that the script executed by the system call needs to know the name of the current database, and just to make this posting worthwhile I'm running OnLine 5.01 ! I appreciated fully that at OnLine 7.xx this is achievable but has anybody out there got any clues as to how I can detect the current database (using system tables?) at this version ? Regards Glyn Balmer I.T. Consultant BICC Cables Limited Erith Kent UK glynb@bicceri.demon.co.uk