Columns
Subsequent rows must contain the column and variable attributes with each represented by a new row in the text file with attributes. The position is determined by the order in which the column /variable rows are processed. For example, in a comma delimited file: Name, Data Type, Length, Precision, Oracle Name, SAS Name, SAS Format, Description, SAS Label, Nullable, Default Value, Date Format
Normal Oracle LSH validation rules apply to the Column or variable attributes. The operation uses Oracle LSH default values if invalid values are provided for any of the attributes.
Table 7-2 Column Attributes with Reference Codelist Values
Attribute | Valid Values |
---|---|
Data Type |
VARCHAR2, NUMBER, DATE |
Nullable |
YES, NO |
SDTM Identifier |
|
Parent topic: Text Load Set Table Descriptors