Identifier in Sybase ASE

[GerryML]

I created views in Sybase ASE 12.5. However, when I tried to run the view script on another Sybase version (unknown) I get error messages saying, "The Identifier that starts with 'myViewName' is too long. Maximum length is 30"
How do I fix this? Please- I need an answer ASAP. My email is Lerm2000@hotmail.com
thanks
-Gerry

 

[grega]

- To find the Sybase ASE version run the SQL select @@version

- What is "the identifier that starts with myViewName"? Is it > 30 characters? if so, make it less tan 30 characters.

Greg.

 

[GerryML]

My view name is DBA.QV_PUCHASE_DETAIL_HARD_SOFT_ACCT
It works fine in my version of Sybase. But not my clients. So can u help me on this one??

-Gerry

 

[grega]

I have the same problem in ASE 11.9.2. You have 2 options ...

- upgrade ASE on your clients servers

- Shorten the view name to less than 30 characters.

Greg.