COLUMN_SCRIPT 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 is done to make System Architect’s overall 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.
