Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS forUNIX SQL Reference - NCR

NCR Teradata RDBMS forUNIX SQL Reference - NCR, 1997. - 913 p.
Download (direct link): teradataforunix1997.pdf
Previous << 1 .. 165 166 167 168 169 170 < 171 > 172 173 174 175 176 177 .. 241 >> Next


Conversely, if the current journal table does not reside in the Example 4 database being modified, the following statement could be used to

change the default journal table from “FinCopy” to “Jrnll":

MODIFY DATABASE Personnel AS DEFAULT JOURNAL TABLE = Jrnl1

Change fallback protection and space allocation options on the Example 5 Finance database as follows.

MODIFY DATABASE finance AS PERM = 75000000

,SPOOL = 150000000

,NOFALLBACK

,DROP DEFAULT JOURNAL TABLE = finance.journals

8-212

Teradata RDBMS for UNIX SQL Reference
Function

Syntax

Teradata SQL Syntax Guide

MODIFY USER

MODIFY USER

The MODIFY USER statement changes the options that were specified when a user database was created.

MODIFY USER is flagged as non-ANSI, when the SQL flagger is enabled

Teradata RDBMS for UNIX SQL Reference

8-213
Teradata SQL Syntax Guide

MODIFY USER

where:

Syntax Element ... Specifies . . .
username the name of the user to be modified.
AS an introduction to a list of options for modifying the user.
PERMANENT a keyword introducing the allocated fixed space.
number a new value (number) for fixed space allocation, in bytes. number can be entered as an integer, a decimal value, or as a floating point value.
BYTES an optional unit assigned to fixed space value.
STARTUP = a keyword introducing the startup null option.
NULL that any existing startup string for the user is to be deleted.
STARTUP = quotestring a replacement for the user’s startup string, which consists of one or more SQL statements that are executed when the user logs on to the Teradata RDBMS. A startup quotestring can be up to 255 characters, must be terminated by a semicolon, and be enclosed by apostrophes. A startup Kanji quotestring can be up to 255 bytes, must be terminated by a semicolon, and be enclosed by apostrophes. The USING modifier is not supported, and if a DDL statement is used, no other statement is allowed in the string.
PASSWORD = a keyword introducing the password assigned.
pwd NULL a new password for a user or if NULL, that no password is required. A password is considered to be an SQL word and may contain up to 30 characters. If the name is Japanese, refer to the formula discussed in Chapter 4, “Teradata SQL Lexicon,” “Calculating the Length of a Name”.
RELEASE PASSWORD LOCK keywords to release a user lock. A user row in DBC.DBase becomes locked if the number of successive erroneous logon attempts reaches the site-specified threshold. The user row remains locked to logon attempts until the site-defined time has passed, or until a MODIFY USER statement is submitted to release the lock on the user.
SPOOL a keyword introducing spool file space allocation.

8-214

Teradata RDBMS for UNIX SQL Reference
Teradata SQL Syntax Guide

MODIFY USER

Syntax Element ... Specifies . . .
number a new value (n) for the maximum space allocation for spool files, in bytes. number can be entered as an integer, a decimal value, or as a floating point value.
BYTES an optional unit for the spool file space value.
ACCOUNT a keyword introducing the account identifier.
acctid a replacement for one or more account identifiers (quotestring) associated with the user. Quotestring may be up to 30 characters and must be enclosed by apostrophes. If the acctid is Japanese character, refer to the formula discussed in Chapter 4, “Teradata SQL Lexicon,” “Calculating the Length of a Name”. Japanese character acctids can be up to 30 bytes long. A list of acctids must be separated by commas and enclosed in parentheses. The first (or only) acctid in the list becomes the new default acctid for the user.
NO FALLBACK PROTECTION a new default for duplicate copy protection of each data table subsequently created in the database. The current fallback setting for existing data tables remains unchanged. The FALLBACK keyword used alone implies PROTECTION.
DEFAULT DATABASE = dbname a new name for the default database that is established each time the user logs on.
NO FALLBACK PROTECTION a new default for duplicate copy protection of each data table subsequently created in the database. The current fallback setting for existing data tables remains unchanged. The FALLBACK keyword used alone implies PROTECTION.

Teradata RDBMS for UNIX SQL Reference

8-215
Teradata SQL Syntax Guide

MODIFY USER

Syntax Element ... Specifies . . .
NO DUAL BEFORE JOURNAL a new default for the number of before change images to be maintained for data tables subsequently created in the database. The NO keyword terminates any current journaling default. If the JOURNAL keyword is specified without NO or DUAL, single-copy journaling is implied. If journaling is specified, a DUAL journal is maintained for data tables with FALLBACK protection. Existing images are not affected until the corresponding table is updated. This option may appear twice in the same statement: once to specify a BEFORE or AFTER image, and again to specify the alternate type. If only one type is specified, then the current default is modified only for that type. If both BEFORE and AFTER are specified then the two must not conflict. The JOURNAL keyword without AFTER or BEFORE indicates that both types of images are to be maintained. In this case, the current default for either or both types is modified accordingly. For example, if only AFTER JOURNAL is specified, the current default for before-change images remains in effect.
Previous << 1 .. 165 166 167 168 169 170 < 171 > 172 173 174 175 176 177 .. 241 >> Next