Salesforce

Which metaschema tables can be populated for custom use?

« Go Back

Information

 
TitleWhich metaschema tables can be populated for custom use?
URL NameWhich-metaschema-tables-can-be-populated-for-custom-use
Article Number000115223
EnvironmentProduct: Progress OpenEdge
Version: All supported versions
OS: All supported platforms
Question/Problem Description
Are there any metaschema fields that can be used to store internal application information?
Can application specific information such as the startup program name (typically for batch processing) be stored in the database metaschema to query later?
Where can we store specific internal notes to read for the database or the application schema?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
Historically the _User-Misc character field was added to the schema tables expressly for the purpose of Customers being able to store their own information as required:
    
_Db._User-Misc
_Field._User-Misc
_File._User-Misc
_Index._User-Misc
_Index-Field._User-Misc
_Sequence._User-Misc
_User._User-Misc
  • The _User-Misc field is one of the fields that will not be used by Progress in future releases.
  • Schema traps do not prevent writing to these *._User-Misc fields
  • In general, database metaschema tables should never be written to because the compatibility of the contents of these metaschema tables from one major release of Progress to another cannot be guaranteed. The _User-Misc field is the one exception.
In OpenEdge 11.7 more user modifiable VST fields were added:
  • _MyConnection._Myconn-UserMisc
  • _Connect._Connect-UserMisc
  • _Cdc-Change-Tracking._User-Misc
Workaround
Notes
Keyword Phrase
Last Modified Date4/29/2024 8:50 PM

Powered by