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.
sql_connect SYSADM,SYSADM
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::
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 nvarchar(4000), VARSET_UPDATE nvarchar(4000), VARIANT integer default 0, ERP_PDM_NUMBER varchar(50), DATA_ID integer default 0 not null, foreign key(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
In order to save loading time in PARTdataManager, VARSET has been splitted into VARSET and VARSET_UPDATE with as of version 9.04.
Now VARSET only contains the information which is needed by PARTdataManager. That means, value range values and if it's about a variant, variant values, which differ form the original value of line.
VARSET_UPDATE is only required for a catalog update. There, the original values are found, which are required to retrieve lines during the update. Value range values are not contained because they are not needed to retrieve lines.
Filling happens when a dataset is added to database (by erpcustom script).
The command
padmin.exe
–migrateVarset
can be called, when changing over from
VARSET to VARSET and VARSET_UPDATE during an update. (Not absolutely
needed, because PARTdataManager notes, if
VARSET_UPDATE is not filled, so for this dataset the old methods have
to be used.)
LINKTABLE and ERPTABLE are connected by primary key and foreign key.