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.
