Hello,
Please pardon my post to an old topic, but this issue has been an on-going struggle for our company for most of the past year.
We use SAS Enterprise Business Intelligence (EBI) on Linux for X64 (SuSE 10) and connect to our operational data stored on a PostgreSQL 8.4 replication server, also on 64-bit Linux (SuSE 10), through the SAS/ACCESS Interface to ODBC.
Our database architect likes to make the table names descriptive. Since Base SAS 9.2 has a limit of 32 characters for table and view names, I and my predecessor have had to work-around this limit by manually creating views on our replication server to shorten the table names.
A current project instantiated 100+ views, many with names longer than 32 characters. A new requirement for this project involves surfacing many of these tables directly to our analysts.
I am working with the database architect to find a simple solution which does NOT involve renaming 50 or more views to fit this name length constraint. Unfortunately, it looks like we may have no choice in the next few weeks.
How can I, CurlerBob, and others best voice our need for SAS 9.x to support longer SQL names for tables, views, et cetera??
Thanks in advance for any insights you all can share!
Cheers,
BobJ
... View more