16.10 - ACCESS - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

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

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.


/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).