EXTOL EBI - Using Implied Decimal for Database Schema Field

EXTOL EBI - Using Implied Decimal for Database Schema Field

TAGS: EXTOL EBI / EXTOL customization / EXTOL 2.6 / EXTOL Schema /


There are times, such as JD Edwards, where the decimal position is not stored in the actual database table. In one such instance JD Edwards stores the decimal positions in the Data Dictionary (F9210). in such cases we might need to manually update the EXTOL Schema to reflect the decimal positions.

Below are two pictures where we first retrieve the schema from the 11gR2 Oracle Database.

FROM: The initial retrieval of F47041.EDLN

TO: After we update the schema field F47041.EDLN to IMPLIED DECIMAL and 3 Decimal Positions.

FROM:

image

TO:

image



Copyright 2013 @ www.seanhoppe.com


By: on

A free web counter provided by GoStats.