Previous Topic

Next Topic

Book Contents

Book Index

Examples

Assume the following information for the examples below:

Table 163 Values for DBINFO Function Examples

Database Variable

Generation

Key

RunID

Time

Data

DB_CHKDBL1

+0

VAL1

RNID1

21:44

03/03/00

DB_CHKDBL1

+1

VAL3

RNID3

10:15

02/02/00

DB_CHKDBL1

+2

VAL2

RNID2

08:00

01/01/00

DB_CHKDBL2

Not
committed


L3


R05


14:15


05/05/00

DB_CHKDBL3

+0

M4

000202

18:10

02/02/00

DB_CHKDBL3

+1

M5

000101

20:15

01/01/00

Table 164 DBINFO Function Examples

Function

Returns value:

DBINFO('DB_CHKDBL2','GEN')

-1

DBINFO('DB_CHKDBL3@KM5','GEN')

+1

DBINFO('DB_CHKDBL1@RRNID2','GEN')

+2

DBINFO('DB_CHKDBL1@G0','KEY')

VAL1

DBINFO('DB_CHKDBL1@G0','RUNID')

RNID1

DBINFO('DB_CHKDBL1@G1','TIME')

10:15

DBINFO('DB_CHKDBL1@G1','DATE')

02/02/00

Parent Topic

DBINFO: Functions