When calling "check database" a database update starts for automatic updating of new or changed columns or tables.
The file DB.INI gets processed. The commands from the DB.INI are interpreted by the program.
These are possible commands for the DB.INI:
version=<versioninfo> |
current Version: 67xxxyy (xxx = versionnumber, yy=build) |
versiondatum=<versiondate> |
Date of the current version |
table=<tablename> |
checks a table |
udt=<tablename>=<Description>=<type> |
Create a SAP Table type: Noobject, Masterdata,masterdatalines,Document, documentlines,Noobjectautoincrement
Example udt=BEAS_TEST=Desc Table
To Add udf's to an udt you simply has to write table name (without @ symbol)
Don't use Prefix "beas" beas_color -> wrong mycompany_color -> correct |
udf=<tablename>=<columnname>=<description>=<type>=<type2>=<length> |
creates a SAP-Field type: Alpha,Float,Numeric,dec type2 at Float: Rate,sum,Price,quantity,percent,measure udf=OITM=beas_myField=This is my field=dec=quantity
Don't use Prefix "beas" beas_color -> wrong mycompany_color -> correct |
Column=<tablename>=<columnname>=<datetype>=<description> |
checks a column |
sapcolumn=<tablename>=<columnname>=<datetpye>=<description> |
checks a SAP |
sapcolumninfo=<description> |
Info to a SAP-column |
primary=<tablename>=<columname> |
sets a primary key for a column primary=beas_mrp_planung=id |
default=<tablename>=<columnname>=<value> |
sets a default value for a column |
droptable=<tablename>=true/false=<columname> |
drops a table : |
delcolumn=<tablename>=<columname>=<datetpye>=<description> |
deletes a column |
abgleich=<sql-command> |
Processes the specified SQL-command if there is a name for "abgleich" (matching) |
abgleichname=<description> |
enables a matching abgleichname=pk_typen |
meldung=<description> |
outputs a message |
prozent=<value> |
displays progress in percent |
script=<Scriptname> |
Calls and interprets a file with a BEAS-Script |