4.3. Add / remove database columns
4.3.1. Create database columns via SQL scripting
Prev  Next

4.3.1. Create database columns via SQL scripting

The LinkDB database instance consists of several tables. Three columns are created in the ERPTABLE by default:

  • ERP_PDM_NUMBER

    Display of the material master number

  • DESCRIPTION

    Display of the description text

  • MAT_NAME

    Display of the material

Any number of additional columns can be created in the ERPTABLE to record the third-party 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 on the database structure can be found under Section 4.2, “Installation Link database ”.

Prev Up Next
4.3. Add / remove database columns  Home 4.3.2.  Add database column with PARTlinkManager