Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Mark Denham — — source: Informix-list mailing list archive (1991-1998)
Have you tried using the USER keyword? I am not sure if it is available in
SPL, if not you can use
SELECT user
FROM dummy_table
This will give you the username.
Mark Denham
BBC
Email: Mark.Denham@bbc.co.uk
----------
From: ilist
To: informix-list
Subject: Help!! "who" in a stored procedure.
Date: 19 June 1995 20:25
I have a trigger which calls a stored procedure, inserting a row into
a table. ( online 7.1, Tools 6.0, Unix V )
Can I get the stored procedure to find out who the current user is in Unix,
in order to write this to one of the columns in the row I'm inserting?
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.