Page 1 of 1
column meaning clarification-LIST DICT
Posted: Fri Oct 04, 2013 1:43 pm
by vamsi.4a6
I tried below command in Datastage Shell
LIST DICT DS_JOBOBJECTS
But not able to understand the meaning of following fields.Any input is really appreciated.
1)Type & FIELD NUMBER
2)FIELD DEFINATION
3)CONVERSION CODE
4)COLUMN HEADINGS
Posted: Sat Oct 05, 2013 5:58 am
by ArndW
DataStage (or UniVerse/UniData/Rocket) hashed files are a bit different from tables, the data and definitions are completely separate. A row is stored as a string with certain special characters used to logically delineate columns (this would be a @FM, or field mark, then one multiple values per field, @VM or value marks, and even one lower layer of multiple sub-values per value, or @SM.
The DICTionary of a hashed file defines how those strings are interpreted by the list engine and consists of the following main columns:
Code: Select all
1 Type Usually "D"ata or "I"-type. I-Types are computed fields
2 Number Field number for "D"ata, Formula code when "I"
3 Conversion OCONV() type output conversion, usually empty
4 Format FMT() type display formatting when listed
5 Heading List column header
6 Field Type "S"ingle value or "M"ultivalue (Multivalue is with @VM,@SM)
7 Association Association for "M"ultivalue fields,multiple columns grouped
This is just a quick overview, the details can be found in the old Server documentation or downloaded from Rocket Software.
Posted: Sat Oct 05, 2013 3:53 pm
by ray.wurlod
TYPE and FIELD NUMBER and FIELD DEFINITION relate to how data are stored, which Arnd as covered. FIELD NUMBER relates to data fields while FIELD DEFINITION relates to computed fields.
The remainder relate to how data are displayed when a query is executed; the default conversion (for example date conversion), the default column heading, the default format, and whether multi-valued fields are associated.