Pseudo Columns

You can use some pre-defined column values in SELECT statements and as a default value for a column definition. The Rules Engine will replace these values.

Here is a list of pre-defined column values that you can use:

•$$USER$$

•$$RDBMSUSER$$

•$$RDBMSOWNER$$

•$$CURRENTDATE$$

•$$CURRENTDATETIME$$

•$$TRANSACTIONDATE$$

•$$TRANSACTIONDATETIME$$

Furthermore, you can use the USER pseudo column (without $$ characters) in SELECT statements.

The USER and $$USER$$ pseudo columns return the active user, and the $$RDBMSUSER$$ pseudo column returns the current RDBMS user. Often the active user and the RDBMS user are the same. However, in web applications for example, you can log on with a specific username, whilst the username which is used to go to the database can be a different one.