I have an Access front-end db linked to DB2 tables. One of the tables has a "USER" field and I need to insert the userID of the person who logs in to DB2 and adds a record to this table (via my Access form that adds records to that particular DB2 table). So when they open my Access db and open the form to enter data, I want this data to be inserted along with their DB2 user name (or user login ID). I do not want their Windows or network name, it must be the DB2 username.

Try using CURRENT_USER or SESSION_USER values.

Fill the field with the DB2 special register CURRENT USER.

Andy

Apparently CURRENT USER (or SESSION USER) does not apply to IBM mainframe DB2???

If I update a field using CURRENT USER, or CURRENT_USER, or SESSION_USER, or (CURRENT USER), it gives an error

UPDATE [tablename]
SET [tablename].[fieldname] = CURRENT USER


I get error:
syntax error (missing operator) in query expression 'CURRENT USER'

Apparently, you should have mentioned your DB2 version and platform earlier.

CURRENT CLIENT_USERID