15.00 - ACCESS - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

ACCESS

Purpose  

The ACCESS command drops access to the current CI or DB segment, and accesses a copy of the same segment in the specified location. If a location is not given, ACCESS identifies the copy of the segment that is currently accessed.

Syntax  

Note: The online help lists the display options (/P, /S, /M, /L, /X, /H, /V) as /dispopt. You can type the options at the beginning or end of the command.

 

Syntax Element

Description

/P

Positions to the segment. Nothing is displayed unless there is a problem.

/S

Displays the segment in a short format. This is the default.

/M

Displays the segment in a medium-length format.

/L

Displays the segment in a long format.

/X

Displays the segment in an extended format.

/H

Displays the segment in hexadecimal.

/V

Verifies that the segment is logically correct, but does not display it.

place

The location of the segment you want to access. The valid values are DISK, DRAM, or LATEST.

If you omit place, the ACCESS command identifies which copy of the segment is currently accessed.

Usage Notes  

The ACCESS command must be invoked from a CI or DB context (as indicated by the CI ==> or DB ==>  prompt).