Progress OpenEdge 11.4 issue with table names

Jeevan

New Member
we are using progress openegde 11.4 database and ibm cognos10.2, when we are importing tables (consist of underscore(_) like Emp_Info) from progress to cognos frameworkmanager tool to create the model, it is giving the below error

[DataDirect].[ODBC Progress openedge wire protocol driver].[OPENEDGE]Syntax Error in sql statement at or about "Emp_Info" AND Sysprogress.sysindexes(10713)

if we dont have any underscore in the table names,it is working fine...

please give the suggestions to solve this issue.
 

Jeevan

New Member
Quote the table name.

Also - show the actual SQL that throws the error.

Hi,
it is not possible to quote the table names, because we are importing tables into cognos by selecting using odbc dsn.
here we are getting error while importing and we are not writing any sql. cognos automatically generates simple select query after importing table.
eg: select * from tablename
 
Last edited:

Cringer

ProgressTalk.com Moderator
Staff member
Then you have 3 options
1) Rename your tables and fields to have no _ in them.
2) Find a way of quoting the tables in Cognos.
3) Use a different reporting tool.
 
Top