Starting 14.10 Object name length has been increased to 128 characters from earlier 30 byte.
But still the view dbc.tables's column ‘tablename’ is defined as 30 char only,
thus restricted the full use of this new feature, as we frequently use the view dbc.tables to search objects
and now as it’s only storing the first 30 char, string based search may result into multiple records.
Any workaround or fix available/planned for this.
You do what is recommended since TD12, utilize the V-Views instead of the old legacy version:
select * from dbc.TablesV
Deiter is correct. For more details, refer to the Data Dictionary reference chapter on views, and the 14.10 Extended Object Names Orange Book. Our plans are to remove the compatibility views in the future.
Thanks a ton Mr. Guru (Dieter) !!
Thanks Mr. Dave, will try to ref the orange book you've recommended.