4.3. Adding/removing database columns
4.3.1. Apply databases columns per SQL Scripting
Prev  Next

4.3.1. Apply databases columns per SQL Scripting

The LinkDB database instance is made up of several tables. Per standard installation, three columns are inserted into the ERPTABLE:

  • ERP_PDM_NUMBER

    Display of material number

  • DESCRIPTION

    Display of description text

  • MAT_NAME

    Display of material

Any other columns in the ERPTABLE can be set up for inserting third system information.

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

Detailed information to database structure to be found under Section 4.2, “Installation Link database ”.

Prev Up Next
4.3. Adding/removing database columns  Home 4.3.2.  Adding database column with PARTlinkManager