Problem with SQL name length

[#1]

Hi, I'm trying to load some information from a SQL table, however I receive this error message:

SQL Error:[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0107 - "Standard_Apps_Data_Dev" too long. Maximum 18 characters. SQL Scriptline: SQL State:S1000 SQL SELECT * FROM "Standard_Apps_Data_Dev".dbo.T10004

I understand what it means but is there a way around this, loads of the databases have a name longer than 18 characters. I can't believe qlikview is limited to 18 characters!

Any help anyone?

[#2]

Hi

It's an ODBC error so I don't think it's QV related.
What version of the ODBC driver are you using, maybe there's an update available that fixes the problem... just a thought.

/Fredrik

[#3]

Seems limit is in your database provider, not QlikView. I tried to load data from MSSQL view
v_very_very_very_very_very_very_very_very_very_very_very_very_very_long_objectname, everything is working. You can create a view in your database with shortest object name.

DimTime << v_very_very_very_very_very_very_very_very_very_very_very_very_very_long_objectname 1.158 lines fetched

Ramunas

[#4]

Hi, I know that the ODBC connection works fine because I am using it with another program called eden and that works fine. I can't understand it. Anymore ideas?