[Info-Ingres] Embedded SQL

[John Dennis]

Mohan,

You need to pre-process the embedded SQL code - esqlc is the utility.
This will convert the *.sc file to *.c which can then be compiled.

The process is described in the "Embedded SQL Companion Guide".

John

On Mar 21, 7:37 pm, kodali... at gmail.com wrote:
> Hi,
> I am trying to use embedded SQL to work with the Ingres database.
> Following is the simple program I have written:
>
> EXEC SQL INCLUDE SQLCA;
> EXEC SQL WHENEVER SQLERROR STOP;
> EXEC SQL CONNECT causp;
> EXEC SQL DELETE FROM indexes WHERE id = 40;
> EXEC SQL DISCONNECT;
>
> But these embedded sql statements are not getting recognized and are
> resulting in errors.
> I am using Microsoft Visual Studio 2005 to write the programs. Can
> anyone please tell me how to overcome this?
>
> Thanks in advance
> Mohan