powered by CADENAS

Manual

Manual

5.2.3.2. Basic 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 individual fields:

erp_pdm_number: foreign key (ERPTABLE)
all self added fields/columns become part of the ERPTABLE.
For example: 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 individual fields:

erp_pdm_number_linktable: primary key (LINKTABLE)
prj_path: project path
varset: all variables summarized in one string
line_id: line identifier
subline_id: sub-line, in order to count up variables
version: number of versions
variant: value 0 or 1 / variant yes or no
active_state: current status
requested_state: requested status
LINKTABLE and ERPTABLE are connected via primary and foreign key.