Kbase P17584: What does FOREIGN-MAXIMUM, DSRVR-PRECISION, FIELD-MISC12, FIELD-MISC13 & FIELD-MISC14 represent with
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
What does FOREIGN-MAXIMUM, DSRVR-PRECISION, FIELD-MISC12, FIELD-MISC13 & FIELD-MISC14 represent within the ORACLE schema holder.
GOAL:
FOREIGN-MAXIMUM
GOAL:
DSRVR-PRECISION
GOAL:
FOREIGN-TYPE
GOAL:
DSRVR-SCALE
GOAL:
DSRVR-LENGTH
GOAL:
FIELD-MISC12
GOAL:
FIELD-MISC13
GOAL:
FIELD-MISC14
FACT(s) (Environment):
Oracle DataServer
FIX:
FOREIGN-TYPE - The foreign data-type. (NUMBER, LONG etc)
FOREIGN-MAXIMUM is used for the size of parameters as well as the maximum size of fields when the client is using SKIP-SCHEMA-CHECK. This allows the client to know how much data can be written to Oracle since the schema is not read.
DSRVR-PRECISION is actually the total number of digits in decimal fields or the precision of the field. The actual field that is read for this value is _Field._Fld-Misc1[1]. The dump code uses a different keyword to represent the field.
DSRVR-SCALE is the digits to the right of the decimal or the scale of the field. This is _Field._Fld-Misc1[2].
DSRVR-LENGTH is the length of the field when represented by characters. For numbers we default to the maximum characters that could be displayed for a field. For character fields it is the length of the field. This field is actually _Field._Fld-Misc1[3].
FIELD-MISC14 is always 1 for Oracle dataserver. This is information is used internally by progress to distinguish dataserver information. Thus, other DataServers, such as ODBC, SQLSERVER, AS400 etc... have different values defined
within the .df.