structure of the DB.INI

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)
version=6700008

versiondatum=<versiondate>

Date of the current version
versiondatum=4.07.2005

table=<tablename>

checks a table
table=beas_mrp_planung

udt=<tablename>=<Description>=<type>

Create a SAP Table

type: Noobject, Masterdata,masterdatalines,Document, documentlines,Noobjectautoincrement

 

Example

udt=BEAS_TEST=Desc Table
udf=BEAS_TEST=beas_Status=Status=alpha=regular=20

 

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 Alpha:regular, adresse, telefon, text

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
column=beas_mrp_planung=bezeichnung=nchar(80)=Bezeichnung

sapcolumn=<tablename>=<columnname>=<datetpye>=<description>

checks a SAP
sapcolumn=OJDT=u_monat=int=monat (partition in month) Nummer

sapcolumninfo=<description>

Info to a  SAP-column
sapcolumninfo=Journalbuchung

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
default=beas_stl=lfdnr=0

droptable=<tablename>=true/false=<columname>

drops a table :
true: drop if column exits,
false: drop, if column does not exist
without condition: drop in any case
droptable=beas_mrp_planung=true=bezeichnung

delcolumn=<tablename>=<columname>=<datetpye>=<description>

deletes a column
delcolumn=beas_mrp_planung=lfgdat_von=nchar(12)=Parameter von Lieferungsdatum

abgleich=<sql-command>

Processes the specified SQL-command if there is a name for "abgleich" (matching)
abgleich=delete from beas_caft_var where varedit='N'

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