Accessing LINC Data

Knowledge Base: Accessing LINC Data

Problem:
RDMS tables created by LINC commonly include a column (GLB_DTIME) which is incorrectly defined to RDMS. The column GLB_DTIME is used by LINC to join tables and profiles. The column is generally of no value to a client application.
Solution:
Do not retrieve the column GLB_DTIME using UARS. UARS will describe the column using the RDMS definition, which is incorrect.

Create views of the LINC generated RDMS tables without the column GLB_DTIME and have the users access the views and not the underlying table in order to prevent accidental attempts to retrieve this column. The VIEWS function of the LINC Runtime Utility will build elements that will create or drop views. For additional information, please see the Unisys OS 1100 LINC Installation and Operations Guide.

You can output the column GLB_DTIME from a UASL transaction by describing the column as a data type that will hold the 72 bit binary value.

Problem:
Access to RDMS tables created by LINC are very slow if a profile is not being used.
Solution:
Create a view which will join the table and the profile. The VIEWS function of the LINC Runtime Utility will build elements that will create or drop views. For additional information, please see the Unisys OS 1100 LINC Installation and Operations Guide.

For example, if TABLE1 exists with a single key GLB_DTIME and the profile TABLE1P exists with an index on EMPLOYEE_ID, the following view would allow access to data in TABLE1 using the index from TABLE1P.

VIEW EMPLOYEE_INFO (NAME, EMPLOYEE_ID, POSITION) AS SELECT TABLE1.NAME, TALBE1P.EMPLOYEE_ID, TABLE1.POSITION WHERE TABLE1P.GLB_DTIME=TABLE1.GLB_DTIME

TABLE1 TABLE1P
GLB_DTIME GLB_DTIME
NAME EMPLOYEE_ID
EMPLOYEE_ID

Problem:

LINC documentation explicitly states in multiple locations that you must not use other tools to update your OS 1100 LINC II database, as this may lead to corruption of your LINC system.

The views used to provide efficient access to LINC data contain two tables. RDMS does not allow views containing more than one table to be updated.

How can data in RDMS tables created by LINC be updated?

Solution:
The correct procedure to update your LINC database is to write a Server-Library transaction which will initiate your existing LINC logic. It is possible to write a Server-Library transaction to directly update the LINC database.

Knowledge Base: Accessing LINC Data