ODBC Progress Syntax Error 7587

balebob

New Member
I try to run the DTS package which has th following statement from my SQL2000 server and get the syntax error.

select * from PUB."table_name" with (index=index##name)

We have Progress 9.1E SP4 on AIX 5.2 machine. The SQL2000 server is on Windows 2003 which has a DataDirect ODBC driver to connect to the Progress database.

Thanks.
 

Casper

ProgressTalk.com Moderator
Staff member
correct syntax is:
Code:
with (INDEX("<index-name>"))

Regards,

Casper.
 

balebob

New Member
Thanks, Casper.

Please correct me if I am wrong... From SQL 2000 query:

with (INDEX("PUB"."Table_Name"."Index_Name"))

Am I safe to say that this is correct syntax?
Thanks,
Bob.
 

Casper

ProgressTalk.com Moderator
Staff member
I always use (well that is, if I use it), only the index name without the shema owner and table qualifier

Code:
with(index("custnum"))

I just tried it with schema and table qualifier and found out that the syntax must be:
Code:
with(index("pub.customer.custnum"));
So totally surounded by quotes.

Casper.
 
Top