Kbase 12701: How Progress Handles Oracle Fieldnames That Have Length > 29
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/03/2007 |
|
Status: Unverified
GOAL:
How Does Progress Handles Oracle Field Names Greater Than 29?
FACT(s) (Environment):
Oracle DataServer
FIX:
Progress metaschema can store foreign database field names with lengths up to 32. Since many ORACLE field names are greater than 32, Progress has an algorithm that takes the first 29 characters of the ORACLE field and concatenates a sequential number to the end, thus using up the 32 characters. The sequential number is displayed as a hexadecimal.
/* ora29.p */
FOR EACH _db WHERE _db-type = "ORACLE":
DISPLAY _db-name.
FOR EACH _file OF _db:
DISPLAY _file-name LABEL "Progress file"
_fil-misc2[1] LABEL "Oracle table".
FOR EACH _field OF _file:
DISPLAY _field-name LABEL "Progress field"
_fld-misc2[1] LABEL "Oracle column".
END.
END.
END.