The USURDDBM table is used for Oracle database mappings and is populated during the Oracle Catalog Mapping phase. The following table describes the columns in the USURDDBM table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| DBMID | INTEGER | 4 | 0 | mapping ID |
| SRCDBNAM | CHAR | 128 | 0 | source database name |
| SRCSCHEM | CHAR | 128 | 0 | source schema |
| SRCUSR | CHAR | 128 | 0 | source user |
| SRCPWD | CHAR | 128 | 0 | source password |
| TRGDBNAM | CHAR | 128 | 0 | target database name |
| TRGSCHEM | CHAR | 128 | 0 | target schema |
| TRGUSR | CHAR | 128 | 0 | target user |
| TRGPWD | CHAR | 128 | 0 | target password |
| FL01 | CHAR | 1 | 0 | flag 1 |
| FL02 | CHAR | 1 | 0 | flag 2 |
| FL03 | CHAR | 1 | 0 | flag 3 |
| FL04 | CHAR | 1 | 0 | flag 4 |
| MCRECID | BINARY | 4 | 0 | machine/company ID |
| GROUPNAME | CHARACTER | 10 | 0 | group name |
| METHOD | CHARACTER | 10 | 0 | method name |