To enable ASE, define one or more of the ASE variables in an account string either directly in the user definition (with the CREATE USER statement), or in the definition of the profile assigned to the user (with the CREATE PROFILE statement). Set up the account to default to automatically use ASE.
Account String Assignment Examples
You assign two account strings to user TAW. The first entry is the default.
MODIFY USER TAW AS ACCOUNT=('$M00ACTB&D&H','$H00FINR&D&H');
When TAW logs on without specifying an account, TAW defaults to using the first account. At query execution time, Analytics Database replaces &D with the current date and &H with the current hour.
In another case, you assign two account strings to user DTG. However, the first (default) account string does not specify date or hour expansion:
MODIFY USER DTG AS ACCOUNT = ('$M00accO', '$L00accB&D&H');
- Log on using .logon DTG, password, '$M00accO&D&H'
- Change the account during a session with the following statement: SET SESSION ACCOUNT='$M00accO&D&H'
Because assigning the first account to DTG without ASE variables means ASE logging does not occur by default, Teradata does not recommend listing the account without &D&H in the account string first.
In another case, assume you omit the ASE variables in the two account strings for user AM1:
MODIFY USER AM1 AS ACCOUNT=('$M00accR', '$H00accT');
AM1 cannot invoke the ASE feature at any time. Teradata does not recommend assigning the first account string without the &D&H variables.