Subject Embedded SQL error
Author Mike Baker
Hi all, thanks for helping me with my previous gpre question. Now I have
another. Here is my setup;

I have created a Database with some tables.
I have created an embedded SQL source file that connects to the database and
does a simple insert.

My insert statement looks like this;

Load values into host variables.....

EXEC SQL
INSERT INTO DESCRIP_TAB
VALUES (:szCBCabId,
:lIDSeqNum,
:szIDFieldId,
:szIDFieldName,
:szIDConstDat);

gpre reports the following error message;
TABLE DESCRIP_TAB is ambiguous

There are no other additional error codes and I cannot find any
documentation describing this error. I have verified that the table and all
of its columns do exist.

Can someone enlighten me as to what this error message means or where I
might find a description for it and how to resolve the problem?

Thanks,
Mike