Customizing the metamodel > Keywords for USRPROPS > COLUMN SCRIPT
  
COLUMN SCRIPT
The COLUMN_SCRIPT keyword calls a script written in SA Basic. The column scripts are used for the behavior of columns in tables in a physical data model. The action taken by the script works against each column in the list.
By convention, the function itself is named with one of the following prefixes:
fmtxxx
The function itself exists in hard code and cannot be modified. Most functions in SAPROPS.CFG are this way. Hard-coding the function makes System Architect’s response faster.
_fmtxxx
Exists in the fmtscript.bas file in the System Architect main executable directory.
For information on how to create your own script, see SCRIPT.
Example
DEFINITION "Table"
{
PROPERTY "Description"
{
ZOOMABLE
EDIT ListOf Definition "Column"
FROM "Data Element"
KEYED BY {"Database Name","Owner Name","Table Name":"Name","Name"}
LENGTH 2000
DISPLAY { FORMAT Key LEGEND "Key Data" }
DISPLAY { FORMAT NonKey LEGEND "Non-Key Data" }
DISPLAY { FORMAT COLUMN_SCRIPT FmtERAttr LEGEND "Physical Display"}
}
}
FmtERAttr returns values for attributes in Entities of Entity Relation diagrams or Columns of Tables in Physical diagrams.
FmtERAttr returns ID, NAME, ADDRESS, STREET, CITY, STATE, FIRST_5_DIGITS, ZIP CODE, and LAST_4_DIGITS.
This graphic is described in the surrounding text.
See also
SCRIPT
COMPONENT SCRIPT
VALUESCRIPT
FORMAT
Keywords for USRPROPS