Previous Topic: CURRENT_EFFECTNext Topic: DASD_VOL_USAGE


CURRENT_INFO_SYS

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

Col

Column Name

Len

Coltype

Description

1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

CURRENT_INFO_SYS

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Name of the current information system

6

SEQ

2

SMALLINT

Sequence within current information system.

Use ORDER_BY_SEQ to return information systems in the same order as specified in the toolset.

7

STATUS

1

CHAR

System Status:

  • C (Current)
  • P (Planned)

8

PARENT_SYS_ID

4

INTEGER

ID of the parent current information system.

Join with CURRENT_INFO_SYS.

Zero for root current information system (will be used in future release).