Name of table is too long

[funkmonsteruk]

I'm working on a BO universe at the moment and getting a SQLSTATE=42622 error, it is telling me that the names of a couple of my tables are too long (maximum 18 characters). It tells me this when i am checking the integrity status.

I've tried re-naming the tables in question, but I'm still getting the error. Anybody got any ideas

 

[skrandel]

Do you have aliases. Those still need to be under 18 characters.

With DB2, you also have to watch out for column names.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[funkmonsteruk]

I'm using db2, one of my column names is 18 characters and the problem comes when i use an alias for this table...

 

[blom0344]

Hello Funk,

This is strange since with DB2 version 7 onwards there is no restriction on 18 positions for table names. Are you perhaps using an older DB2 version or have you set connection for the universe with setting on a older database engine version? (like V5 or V6)

T. Blom
Information analyst
tbl@shimano-eu.com