PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.4.0
- All Products
------------------------------------------------------------------------- db20030 db20023 DTLUSR.DTLSTATUS None A - -Column Name ----------------Type-----Precision--Scale--Nulls-Key-------- TABLE_NAME VARCHAR 255 0 N Y STATUS CHAR 20 0 N N STATUS_REASON CHAR 20 0 N N APPLY_SEQUENCE VARCHAR 255 0 Y N RESTART_POINT VARCHAR 255 0 Y N -------------------------------------------------------------------------
2018-06-21 15:31:05 DTLUCBRG REGISTRATION REPORT (TESTRUN=N) . CONDTYPE = <None> CRGNAME = <kafkaall> DBTYPE = <VSM> FASTLOAD = <N> INSTANCE = <INST6> LOCATION = <node1> LOCATION_CRG = <node1> LOCATION_DM = <node1> LOCATION_XDM = <node1> NOTIFYCHANGES = <N> OUTPUT = <> REPLACE = <Y> REPLACEACTIVE = <Y> REUSECRGNAME = <Y> RPTCOLS = <Y> STATUS = <A> TABLE = <kafsvr.vsamall.ALLDataTypes> . IMSOPTS: Not relevant for this run ORAOPTS: Not relevant for this run MYSOPTS: Not relevant for this run MSSOPTS: Not relevant for this run ADAOPTS: Not relevant for this run CREATEBICI: COLUMNS = <ALL> MAXCOLS = <500> EXTINFO = <BICI> INPUT_FN = <N> OUTPUT_FN = <N> ERROR_FN = <N> . . Processed Registration "kafkaall" Table "kafsvr.vsamall_ALLDataTypes" Old Registration Name "kafkaall". Old condense type "None". Old status "A". Old version "1". . Column Name --------------- Type ------ -- Precision Scale Nulls Key BI CI BIN9 BIN 9 0 N N Y Y CHAR4 CHAR 4 0 N N Y Y Double DOUBLE 0 0 N N Y Y Float DOUBLE 0 0 N N Y Y Num16_0 NUM16 0 0 N N Y Y Num16_6 NUM16 0 5 N N Y Y NUM16U_0 NUM16U 0 0 N N Y Y NUM16U_5 NUM16U 0 5 N N Y Y NUM32_0 NUM32 0 0 N N Y Y NUM32_10 NUM32 0 10 N N Y Y NUMCHAR1 NUM8 0 0 N N Y Y NUMCHAR100 NUMCHAR 100 0 N N Y Y NUMCHAR100_99 NUMCHAR 100 0 N N Y Y PACKED31_0 PACKED 31 0 N N Y Y PACKED31_31 PACKED 31 31 N N Y Y PACKED5_3 PACKED 5 3 N N Y Y SPACKED31_0 UPACKED 31 0 N N Y Y SPACKED31_31 UPACKED 31 31 N N Y Y SPACKED_3 UPACKED 5 3 N N Y Y UPACKED31_0 UPACKED 31 0 N N Y Y UPACKED UPACKED 31 31 N N Y Y UPACKED5_3 UPACKED 5 3 N N Y Y UZONED31_0 UZONED 31 0 N N Y Y UZONED31_31 UZONED 31 31 N N Y Y VARBIN44 VARBIN 44 0 Y N Y Y VARCHAR1 VARCHAR 1 0 Y N Y Y VARCHAR255 VARCHAR 255 0 Y N Y Y VARCHAR4096 VARCHAR 4096 0 Y N Y Y ZONED31_0 ZONED 31 0 N N Y Y ZONED31_31 ZONED 31 31 N N Y Y ZONED5_3 ZONED 5 3 N N Y Y ----------------------------------------------------------------------------- . ========================================================================== Summary of registrations created with status ACTIVE and condense type NONE No of registrations created = 0 No of registrations updated = 1 No of existing registrations not matching update parameters = 0 . 2018-06-21 15:31:09 END OF DTLUCBRG REGISTRATION REPORT =========================================================================
Field
| Description
|
---|---|
Column Name
| Column name
|
Type
| Data type
|
Precision
| Length of the column
|
Scale
| Decimal places
|
Nulls
| Indicates whether the column can contain a null. Valid values: Y or N.
|
Key
| Indicates whether the column is a key column. Valid values: Y or N.
|
GEN_BI
| Indicates whether a before-image column is generated for the column. Valid values: Y or N.
|
GEN_CI
| Indicates whether a change-indicator column is generated for the column. Valid values: Y or N.
|