DB2 UDB LUW DB2 LOG API : Table descriptor record (how to compose the )

[Bernard Dhooghe]

The documentation (Administrative API Reference, 8.2, PDF format) says
page 520:

"The rest of the record is dependent upon the record type and the table
descriptor record defined for the table."

How can the record descriptor by composed for existing tables (not in
the log file as new entry) or is mentioned somewhere?

select colname, colno, rtrim(typename), length, scale,
coalesce(generated,' '),nulls, ... from syscat.columns where
TABSCHEMA= ? and TABNAME= ? order by colno

and first 1. fixed length columns from left to right
then 2. variable length columns from left to right
?
(as the insert log record has first fixed length columns, then variable
length columns).
Bernard Dhooghe

[Bernard Dhooghe]

Bernard Dhooghe wrote:

The documentation (Administrative API Reference, 8.2, PDF format) says
page 520:

"The rest of the record is dependent upon the record type and the table
descriptor record defined for the table."

How can the record descriptor by composed for existing tables (not in
the log file as new entry) or is mentioned somewhere?

select colname, colno, rtrim(typename), length, scale,
coalesce(generated,' '),nulls, ... from syscat.columns where
TABSCHEMA= ? and TABNAME= ? order by colno

and first 1. fixed length columns from left to right
then 2. variable length columns from left to right
?
(as the insert log record has first fixed length columns, then variable
length columns).
Bernard Dhooghe

It is

1. fixed block contains the data for fixed length columns and for the
columns with variable length, instead of the content there is the fixed
length data of 4 bytes (not null column) or 5 bytes (for null columns)
described as follows in the manual "All variable field types have a
4-byte fixed data portion in the fixed length section (plus a null
flag, if the column is nullable). The first 2 bytes (short) represent
the offset from the beginning of the fixed length section, where the
variable data is located. The next 2 bytes (short) specify the length
of the variable data referenced by the offset value." (page 523).
2. variable length block with the content of the variable length
columns

Bernard Dhooghe