ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

DDL Field Name Limitations

book

Article ID: 241586

calendar_today

Updated On:

Products

CA 2E

Issue/Introduction

We are converting DDS files to DDL tables. DDL allows 128 character field names. Is there a way to use more characters for field names when using the 2E interface? If we set longer field names outside of 2E will this create issues viewing the table in the model/Software?

Environment

Release : 8.7

Component : CA2E

Resolution

Is there a way to use more characters for field names when using the 2E interface?
Unfortunately this is a limitation when defining the fields from the 2E interface. The length limit on names is 25 characters. This is controlled by YSQLLEN when using SQL/DDL.

If we set longer field names outside of 2E will this create issues viewing the table in the model/Software?
Yes. When we view the field details of a table, where the field names are more than 25, the details will be truncated to be of length 25.

Coming to the processing, however, since the program generation logic uses implementation names so it will not be a problem.