If I create a column named "USERID" in any table and then select * on that table, the USERID column value returned for every row matches SCAU account I am using with the JCBC driver.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If I create a column named "USERID" in any table and then select * on that table, the USERID column value returned for every row matches SCAU account I am using with the JCBC driver.
That is correct.
The identifier USERID is a reserved name, that corresponds to the login name of the user (similar but not equal to the SQL reserved name CURRENT_USER)
In a similar way the name SYSDAT is the DQ-SQL equivalent of CURRENT_DATE.
Did you try to use the qualified column name (table.USERID)?
No, but I will give that a try. Are there any other reserved names I need to worry about? Is there a documented list?
Ed