Embedded SQL

On Mar 21, 8:37 am, 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>
 >> Stay informed about: Embedded SQL 

Hi,
I've tried the command "esqlc -l file.cpp". But the error is: 'esqlc'
is not recognized as an internal or external command,
operable program or batch file.

Mohan




On Mar 21, 2:00 pm, "John Dennis" wrote:
> 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, 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- Hide quoted text -
>
> - Show quoted text -
 >> Stay informed about: Embedded SQL 

On 21 mar, 10:13, wrote:
> Hi,
> I've tried the command "esqlc -l file.cpp". But the error is: 'esqlc'
> is not recognized as an internal or external command,
> operable program or batch file.

Are Ingres variables setted in your environment ? (II_SYSTEM, PATH,
LIB and so on)
Jean-Pierre
 >> Stay informed about: Embedded SQL 

what I am doing is write a C++ file and compile it. Is it not possible
to do in this way?
How can we know whether pre-processor is installed or not?


On Mar 21, 2:31 pm, "Roy Hann"
wrote:
> wrote in message
>
>
>
> > Hi,
> > I've tried the command "esqlc -l file.cpp". But the error is: 'esqlc'
> > is not recognized as an internal or external command,
> > operable program or batch file.
>
> Is the pre-processor installed on the machine where you are doing this?
> What is the PATH for the user who is compiling?
>
> (Also it looks like you are trying to pre-process the wrong file. esqlc
> expects a file with a .sc suffix.)
>
> Roy
 >> Stay informed about: Embedded SQL 

On 21 mar, 10:52, wrote:
> what I am doing is write a C++ file and compile it. Is it not possible
> to do in this way?
> How can we know whether pre-processor is installed or not?

pre-processor come with the installation of Ingres ...

Are you trying to compile programm for Ingres without Ingres on the
machine ?
Even just a small client installation ?

Look if you can find files like version.rel or config.dat somewere on
your disks, you'll find then the root directory of Ingres (II_SYSTEM).

esqlc should be in the $II_SYSTEM/ingres/bin directory (or %II_SYSTEM%
\ingres\bin)

HTH
 >> Stay informed about: Embedded SQL 

Hi,
I have Ingres installed on my machine but I couldn't find esqlc.exe
and esqlcc.exe in my C:\IngresII\ingres\bin directory.
Is there any way to get these files.


On Mar 21, 3:11 pm, "Roy Hann"
wrote:
> wrote in message
>
>
>
> > what I am doing is write a C++ file and compile it. Is it not possible
> > to do in this way?
>
> The words EXEC SQL ... are not C++ code are they? They have to be
> translated into API calls in C++ syntax before the C++ compiler ever gets to
> see the code.
>
> > How can we know whether pre-processor is installed or not?
>
> There are various ways. I am old and reactionary so I would do it as
> follows. Log in as the user who is trying to compile the code, start a DOS
> window, and (assuming everying is on the C: drive):
>
> cd %II_SYSTEM%\ingres\bin
> dir esql*.exe
>
> You should see esqlc.exe and esqlcc.exe.
>
> Also, still in the DOS window:
>
> set
>
> And look for PATH to see if the above ingres\bin directory is in the path.
>
> Roy
 >> Stay informed about: Embedded SQL 

wrote in message

> Hi,
> I've tried the command "esqlc -l file.cpp". But the error is: 'esqlc'
> is not recognized as an internal or external command,
> operable program or batch file.

Is the pre-processor installed on the machine where you are doing this?
What is the PATH for the user who is compiling?

(Also it looks like you are trying to pre-process the wrong file. esqlc
expects a file with a .sc suffix.)

Roy
 >> Stay informed about: Embedded SQL 

wrote in message

> what I am doing is write a C++ file and compile it. Is it not possible
> to do in this way?

The words EXEC SQL ... are not C++ code are they? They have to be
translated into API calls in C++ syntax before the C++ compiler ever gets to
see the code.

> How can we know whether pre-processor is installed or not?

There are various ways. I am old and reactionary so I would do it as
follows. Log in as the user who is trying to compile the code, start a DOS
window, and (assuming everying is on the C: drive):

cd %II_SYSTEM%\ingres\bin
dir esql*.exe

You should see esqlc.exe and esqlcc.exe.

Also, still in the DOS window:

set

And look for PATH to see if the above ingres\bin directory is in the path.

Roy
 >> Stay informed about: Embedded SQL 

Hi
I've tried re-installing, but this didn't create the files esqlc.exe
and esqlcc.exe. Ingres gets installed on my machine when i install a
tool. Is this the reason for not installing those files. If so, what
can be the way to get these files?

Mohan

On Mar 21, 5:56 pm, "Roy Hann"
wrote:
> wrote in message
>
>
>
> > Hi,
> > I have Ingres installed on my machine but I couldn't find esqlc.exe
> > and esqlcc.exe in my C:\IngresII\ingres\bin directory.
> > Is there any way to get these files.
>
> You should be able to just re-run the Ingres installer on your machine. It
> will discover the existing installation and leave it alone.
>
> I'm not sure an Ingres installation is enormous you should worry about
> selecting just the specific components you want, so make sure you install
> everything it offers you (including the documentation).
>
> Don't get over-enthusiastic and select (strict) SQL-92 compliance though;
> you certainly don't want that.
>
> Roy
 >> Stay informed about: Embedded SQL 

wrote in message

> Hi,
> I have Ingres installed on my machine but I couldn't find esqlc.exe
> and esqlcc.exe in my C:\IngresII\ingres\bin directory.
> Is there any way to get these files.

You should be able to just re-run the Ingres installer on your machine. It
will discover the existing installation and leave it alone.

I'm not sure an Ingres installation is enormous you should worry about
selecting just the specific components you want, so make sure you install
everything it offers you (including the documentation).

Don't get over-enthusiastic and select (strict) SQL-92 compliance though;
you certainly don't want that.

Roy
 >> Stay informed about: Embedded SQL 

wrote in message

> Hi
> I've tried re-installing, but this didn't create the files esqlc.exe
> and esqlcc.exe. Ingres gets installed on my machine when i install a
> tool. Is this the reason for not installing those files. If so, what
> can be the way to get these files?

Hmm. What is the name of the file that you downloaded from Ingres? I
wonder if the preprocessors aren't in the package you got?

Roy
 >> Stay informed about: Embedded SQL 

What "tool" are you installing which also installs Ingres? Perhaps the
provider of that tool does not deliver the application development
environment with their embedded Ingres.

John

On Mar 22, 1:13 am, wrote:
> Hi
> I've tried re-installing, but this didn't create the files esqlc.exe
> and esqlcc.exe. Ingres gets installed on my machine when i install a
> tool. Is this the reason for not installing those files. If so, what
> can be the way to get these files?
>
> Mohan
>
 >> Stay informed about: Embedded SQL 

Hi,
I've installed Unicenter Service Plus Knowledge Tool on my machine.
This automatically installs the Ingres database.
Mohan



On Mar 22, 5:23 am, "John Dennis" wrote:
> What "tool" are you installing which also installs Ingres? Perhaps the
> provider of that tool does not deliver the application development
> environment with their embedded Ingres.
>
> John
>
> On Mar 22, 1:13 am, wrote:
>
>
>
> > Hi
> > I've tried re-installing, but this didn't create the files esqlc.exe
> > and esqlcc.exe. Ingres gets installed on my machine when i install a
> > tool. Is this the reason for not installing those files. If so, what
> > can be the way to get these files?
>
> > Mohan- Hide quoted text -
>
> - Show quoted text -
 >> Stay informed about: Embedded SQL