Previous Topic: TECHNICAL_DESIGNNext Topic: TEXT


TECHNICAL_SYSTEM

The following table details various column names along with their descriptions.

Col

Column Name

Len

Coltype

Description

1

MODEL_ID

4

INTEGER

1ID of the containing model

2

TBNAME

16

CHAR

TECHNICAL_SYSTEM

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

HOST_TELEPROCESS

1

CHAR

Host teleprocessing monitor:

  • I (IMS)
  • C (CICS)
  • T (TSO)

6

SOURCE_LANGUAGE

32

VARCHAR

Name of source language

7

DBMS

1

CHAR

Database management system:

  • 2 (DB2 z/OS)
  • A (Datacom)
  • B (ODBC/ADO.NET)
  • C (MSSQL)
  • E (DB2 UDB)
  • H (NONE)
  • J (JDBC)
  • O (Oracle)

8

PROFILE_MANAGER

1

CHAR

Type of profile manage, D (DB2)

9

SCREEN_HANDLER

1

CHAR

Type of screen handler:

  • T (Bypass)
  • M (Mapped)

10

DB2_SYS_IDENT

8

CHAR

Name of DB2 system identification

11

APPLIC_IDENT

32

VARCHAR

Name of application ID

12

RESTART_INDIC

1

CHAR

Restart or reset indicator:

  • Y (Yes)
  • N (No)

13

EXTENDED_ATTR

1

CHAR

Allow extended attribute not output?

  • Y (Yes)
  • N (No)

14

HELP_EXIT

8

CHAR

Name of help routine exit csect

15

DEC_PNT_OR_
COMMA

1

CHAR

Decimal point or comma?

  • . (Decimal point)
  • , (Comma)

16

DB2_REFERENCE

1

CHAR

DB2 reference fully qualified?

  • Y (Yes)
  • N (No)

17

TRAP_ABENDS

1

CHAR

Trap abends from CICS?

  • Y (Yes)
  • N (No)

18

TRAP_PA_KEYS

1

CHAR

Trap CLEAR, PA1, PA2, PA3 keys?

  • Y (Yes)
  • N (No)

19

START_XCTL

1

CHAR

Use START or XCTL in CICS?

S (Start)

20

COMPILER_LANG

 

1

CHAR

Computer language dialect:

  • 2 (VSCOB)
  • 4 (CSC)
  • 5 (UNIXC)
  • G (GCC)
  • J (JAVAC)
  • V (MSVCNT)

21

OPERATING_SYSTEM

32

VARCHAR

Operating system

22

RESTARTABLE

1

CHAR

Restartable application?

  • Y (Yes)
  • N (No)

23

BUSINESS_SYS_ID

4

INTEGER

Business system that contains this technical system