RE: Mixed case table in Pro*Cobol

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 06 Mar 2001 13:43:13 -0800
Message-ID: <F001.002C5236.20010306133528@fatcity.com>

> -----Original Message-----
> From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org]
> Sent: mardi, 6. mars 2001 12:07
>
> 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.

I don't have Pro*COBOL installed here so I can't try any clever syntax tricks inside a program. The only suggestion I would have is to use a synonym instead of the table name inside the program.

---

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com Received on Tue Mar 06 2001 - 15:43:13 CST