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.

 

ATTENTION: Manual Database modification is not allowed!

 

 

 

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