Mixed case table in Pro*Cobol

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 06 Mar 2001 12:08:30 -0800
Message-ID: <F001.002C5072.20010306120708@fatcity.com>

Trying to access a table via a DB_LINK. The table is mixed case so need the double quotes. SQL*Plus likes the statement but Pro*cobol apparently gets confused by the quotes. Any suggestions.

1784 EXEC SQL
Error at line 1785, column 55 in file interface.PCO

  1785                   INSERT INTO DBO."GCRTA_employeeInput"@ADS
  1785  ......................................................1

  1785 PCB-S-00400, Encountered the symbol "@ADS" when expecting one of the fo^  

           . ( SELECT PARTITION VALUES @
        The symbol "." was substituted for "@ADS" to continue.

 

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204 Received on Tue Mar 06 2001 - 14:08:30 CST