[Info-Ingres] Embedded SQL

[Tim Ellis]

On Mar 21, 8:37 am, 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

You are remembering to pre-compile the code before compiling it?
 For C programs use  esqlc -f<output filename> <input filename>