CA Plex: ODBC table creates without labels or descriptions
search cancel

CA Plex: ODBC table creates without labels or descriptions

book

Article ID: 97584

calendar_today

Updated On:

Products

CA Plex

Issue/Introduction

When generating a DDS table, it has all the field labels and table descriptions.  When generating an odbc sql table, it does not.  How can the odbc sql table be genrated to include labels and descriptions?

Resolution

Database labels generation is only available for System-I variant - table/view generations.  This gives the option of creating System-I physical and logical files with meaningful column headings, instead of headings based on the implementation name of the field or attribute objects concerned. 

Please refer Plex help topic – ‘Generating Database Labels (System i only)’ 

To generate meaningful name with other variants in this regard, enable --- Generate & Build options -) Name Allocation –) ‘Long implementation names for SQL schema’ option. 
This name allocation will be applied for new object’s name, once you have enabled the option - ‘Long implementation names for SQL schema’. 
Long implementation names are derived from the scoped name of the corresponding CA Plex object. For example, the object "Customer.Table" would be allocated the name CUSTOMER_TABLE.