SBYN_OVERWRITE
This table stores information about the fields that are locked for updates in the SBRs. It stores the EUID of the SBR, the ePath to the field, and the current locked value of the field. The differences in data types between Oracle and SQL Server are noted in Table 15. The Oracle type is on the first line, and the SQL Server type is on the second.
Table 15 SBYN_OVERWRITE Table Description|
Column Name |
Data Type |
Description |
|---|---|---|
|
VARCHAR2(20) Varchar(20) |
The EUID of an SBR containing fields for which the overwrite lock is set. |
|
|
VARCHAR2(200) Varchar(20) |
The ePath to a field that is locked in an SBR from the EDM. |
|
|
VARCHAR2(20) Varchar(20) |
The data type of a field that is locked in an SBR. |
|
|
NUMBER(38) numeric(38, 0) |
The data that is locked for overwrite in an integer field. |
|
|
NUMBER(38) numeric(38, 0) |
The data that is locked for overwrite in a boolean field. |
|
|
VARCHAR2(200) Varchar(200) |
The data that is locked for overwrite in a string field. |
|
|
CHAR(2) |
The data that is locked for overwrite in a byte field. |
|
|
LONG varchar(MAX) |
The data that is locked for overwrite in a long integer field. |
|
|
DATE datetime |
The data that is locked for overwrite in a date field. |
|
|
NUMBER(38,4) numeric(38, 4) |
The data that is locked for overwrite in a floating decimal field. |
|
|
DATE datetime |
The data that is locked for overwrite in a timestamp field. |
- © 2010, Oracle Corporation and/or its affiliates