Occasionally, the text column has a name other than Text. However, in these instances, the text column can be readily identified by its length and column type. Use your query facility to determine the length of the columns and the specific DBMS view definitions. Its length is 3950, and its column type is VARYING LENGTH STRING. For instance, in the LIBRARY view, the DATASET_NAME column stores the text string, the name of the library data set:
|
Column Name |
Column Type |
Description |
|---|---|---|
|
MODEL_ID |
NUMERIC |
ID of the containing model |
|
TBNAME |
STRING |
LIBRARY |
|
ID |
NUMERIC |
Unique identifier |
|
ORG_ENCY_ID |
NUMERIC |
Original encyclopedia identifier |
|
ORG_ID |
NUMERIC |
Original object identifier |
|
DATASET_NAME |
VARYING LENGTH STRING |
Name of data set |
|
Copyright © 2013 CA.
All rights reserved.
|
|