Option Checking
You can specify multiple options within a single MODIFY USER request; however, the database aborts the request and returns an error if you specify duplicate or conflicting options.
STARTUP Options
You can specify either of the following options for STARTUP.
| Option | Description |
|---|---|
| NULL | The existing startup string for the user, if any, is to be deleted. |
| quotestring | A replacement for the user startup string, which consists of one or more SQL statements that are performed when the user logs onto Vantage. A startup quotestring can be up to 255 characters, must be terminated by a SEMICOLON character, and enclosed by APOSTROPHE characters. A startup Kanji quotestring can be up to 255 bytes, must be terminated by a SEMICOLON character, and enclosed by APOSTROPHE characters. The USING request modifier is not supported, and if a DDL request is specified, no other request is allowed in the string. |
See STARTUP String for more information about startup strings.
TIME ZONE Option
The following table describes the TIME ZONE options in detail.
| Option | Description |
|---|---|
| LOCAL | Changes local time zone displacement to that defined for system default. Persistent setting. Does not change if system-defined default time zone changes. Change value with MODIFY USER statement. |
| NULL | No default TIME ZONE displacement is defined for the user. |
| ± 'quotestring' | An optionally signed value that sets a non-system-default interval offset for converting the user TIME ZONE displacement. The format is hh:mm. |
| 'time_zone_string' | Changes value of default time zone for user to displacement specified by time_zone_string. If time_zone_string specifies non-GMT time zone, system-defined UDF GetTimeZoneDisplacement interprets it and determines appropriate time zone displacement for session. Time zone strings that are expressed in terms of GMT do not enable automatic adjustments for Daylight Saving Time. Regions that do not follow Daylight Saving Time are only represented by GMT values. The valid time zone strings are listed in the following table. |
The following table lists the valid time zone strings for the 'time_zone_string' option.
| Valid Time Zone Strings | |||
|---|---|---|---|
|
|
|
|