> -----Original Message-----
> From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]]
> 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