Kbase P111610: The size of decimal fields created during the ProToOdb are decimal(18,5)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/03/2006 |
|
Status: Unverified
FACT(s) (Environment):
ODBC DataServer
OpenEdge 10.0A
OpenEdge 10.0B
SYMPTOM(s):
The size of decimal fields created during the ProToOdb are decimal(18,5)
Decimal field defined as decimal(4,0) but still decimal(18,5)
Data Source is DB2/400
CAUSE:
Bug# 20051214-009
FIX:
Upgrade to 10.0B04 or higher.
If unable to upgrade you can run the individual steps of the ProToOdb so that you can manually correct the size. Follow the following steps:
1. Run the ProToOdb utility and deselect the load SQL toggle box so that only the script is created.
2. Modify the script to have the correct decimal definition.
3. Load the SQL script manually on the AS/400
4. Create your schema holder and run the Create DataServer Utility to pull in the definitions
5. Connect to the original Progress database and run Schema Migration -> Adjust Schema utility
Your schema holder will now have the proper information for your application.