object=ue_installation=dbupgrade=#<variable>
object=ue_installation=dbupgrade=<filename>
if you use oder version as beas8.8-0-0-76 then use
object=ue_installation=dbpruef=#<variable>
Add new Tables, Columns or Indexes
or make correct length or types
Normal beas read the file db.ini and execute this table-definition-File
Keyworkds
table=<tablename> |
Create a new Table. After this command you need the Primary and the columns |
primary=<table>=<column>,<column> |
set or change the Primary-key |
column=<table>=<columnname=<typ> |
Create a new Column for the Table |
udf=<table>=<column>=<Description>=<typ>=<typ2>=<length> |
Create a SAP-UDF-Column Typ / Typ2 dec,float,decimal,real / rate, sum. price, quantity, percent int, numeric, num / .. date, datetime / time, ... memory, text / .. alpha, char, string, varchar / address, phone / length
|
delcolumn=<table>=<column> |
Delete the Column First you must set "delcolumn" to yes delcolumn=yes delcolumn=mytable=mycolumn
|
droptable=<table>=<true/false/empty>=<column> |
Delete the Table, if colum exist in the table or column is not existing false = delete table, if column not existing true = delete the table, if column is existing empty = delete table allways
droptable=mytable delete table allways droptable=mytable=true=mycol delete table, if column mycol not existing
|
default=table=column=value |
set a default value without constraint, if value for the table/column is null |
constraint=<table>=<column>=<constraintname>=<constraint> |
create or alter a constraint |
delconstraint=<table>=<constraintname> |
delete a constraint |
script=<script> |
Execute this beas-Script |
sql=<sqlscommand> |
Execute this SQL-Command |
Example: Create new Table
#define dbcheck
table=beas_oitm_material
primary=beas_oitm_material=baseitemcode,itemcode
column=beas_oitm_material=baseitemcode=varchar(30) not null
column=beas_oitm_material=itemcode=varchar(30) not null
column=beas_oitm_material=quantity=decimal(19,6)
#end
object=ue_installation=dbupgrade=#<dbcheck>