Manual

Login

Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.

You can log in there with your existing account of this site.

The content remains free of charge.

Manual

4.2.4. Create database scheme and users for ERP (exemplified by MSSQL) 4.2.4.2. Base functionality
Prev	Next

4.2.4.2. Base functionality

sql_connect SYSADM,SYSADM

ERPTABLE

sql_execute create table ERPTABLE (/
ERP_PDM_NUMBER varchar (50) not null,/
DESCRIPTION varchar (200),/
MAT_NAME varchar (100),/
primary key (ERP_PDM_NUMBER))
sql_execute create public synonym ERPTABLE for SYSADM.ERPTABLE
sql_execute grant all on ERPTABLE to PUBLIC

Meaning of the single fields:

erp_pdm_number: Foreign key (ERPTABLE)

all fields/columns added by you yourself become part of the ERPTABLE.

e.g. Description, Material, Surface.

LINKTABLE

sql_execute create table LINKTABLE (/
PRJ_PATH varchar (500) not null,/
LINE_ID integer not null,/
LINE_SUBID integer not null,/
VERSION varchar(5) not null,/
ACTIVE_STATE smallint default 0 not null,/
REQUESTED_STATE smallint default 0 not null,/
VARSET varchar (4000) ,/
VARIANT integer default 0,/
ERP_PDM_NUMBER varchar (50),/
foreign key ERP_FK (ERP_PDM_NUMBER) references ERPTABLE,/
primary key (PRJ_PATH,LINE_ID,LINE_SUBID,VERSION))
sql_execute create public synonym LINKTABLE for SYSADM.LINKTABLE
sql_execute grant all on LINKTABLE to PUBLIC

Meaning of single fields:

erp_pdm_number_linktable: Foreign key (LINKTABLE)

prj_path: Project path

varset: All variables are concatenated to a string

line_id: Line identifier

subline_id: subline to increment variants

version: number of versions

variant: value 0 or 1 / variant yes or no

active_state

requested_state

LINKTABLE and ERPTABLE are connected by primary key and foreign key.

Prev	Up	Next
4.2.4.1. Installations script	Home	4.2.4.3. Additional functionalities

Manual

Login

Top Links

Manual

4.2.4.2. Base functionality