topic Problem with SQL name length in QlikView

Problem with SQL name length

Wed, 06 Jan 2010 12:30:09 GMT

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?

Problem with SQL name length

Wed, 06 Jan 2010 12:49:17 GMT

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

Problem with SQL name length

Wed, 06 Jan 2010 12:53:47 GMT

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

Problem with SQL name length

Wed, 06 Jan 2010 13:54:14 GMT

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?