Embedded SQL

Hi,
I got esqlc.exe and esqlcc.exe files and copied them to C:\IngresII
\ingres\bin folder. Now the commands are working. But the error is
with program. Below is the program I've written:

#include <stdio.h>

void main() {

EXEC SQL INCLUDE SQLCA;

EXEC SQL WHENEVER SQLERROR STOP;

EXEC SQL CONNECT causp;

EXEC SQL DELETE FROM skeletons WHERE id = 40;

EXEC SQL DISCONNECT;
}

If I issue the command esqlc filename.sc, I'am getting the following
error:
ESQL TestKT.sc:
%% Error in file TestKT.sc, Line 14:
E_EQ0205 End of file found in middle of line.
The current line will be ignored by the preprocessor.

Can any one suggest what modifications need to be done in the program?

Thanks in advance
Mohan
 >> Stay informed about: Embedded SQL 

There's more files needed than just the executables. The .h files,
libraries, etc... And you can't necessarily simply copy programs from
one installation to another - if the versions are different there's no
guarantee anything will work.

John

On Mar 22, 7:21 pm, wrote:
> Hi,
> I got esqlc.exe and esqlcc.exe files and copied them to C:\IngresII
> \ingres\bin folder. Now the commands are working. But the error is
> with program. Below is the program I've written:
>
> #include <stdio.h>
>
> void main() {
>
> EXEC SQL INCLUDE SQLCA;
>
> EXEC SQL WHENEVER SQLERROR STOP;
>
> EXEC SQL CONNECT causp;
>
> EXEC SQL DELETE FROM skeletons WHERE id = 40;
>
> EXEC SQL DISCONNECT;
>
> }
>
> If I issue the command esqlc filename.sc, I'am getting the following
> error:
> ESQL TestKT.sc:
> %% Error in file TestKT.sc, Line 14:
> E_EQ0205 End of file found in middle of line.
> The current line will be ignored by the preprocessor.
>
> Can any one suggest what modifications need to be done in the program?
>
> Thanks in advance
> Mohan
 >> Stay informed about: Embedded SQL 

Hi,
I could see the eqdef.h file at the location %II_SYSTEM%ingres\files.
But still this program is throwing the same error.
Mohan

>
> To my naked eye that looks fine (although I might have included the SQLCA
> outside the scope of main()).
>
> If you look in %II_SYSTEM%ingres\files do you see a file called eqdef.h?
> That's what is being included, so it needs to be there. If you don't have
> it, presumably you can get it from wherever you got the esqlc.exe. I have
> no idea if you'd get the particular error you are seeing if it doesn't exist
> though.
>
> Roy- Hide quoted text -
>
> - Show quoted text -
 >> Stay informed about: Embedded SQL 

wrote in message

> Hi,
> I got esqlc.exe and esqlcc.exe files and copied them to C:\IngresII
> \ingres\bin folder. Now the commands are working. But the error is
> with program. Below is the program I've written:
>
> #include <stdio.h>
> void main() {
> EXEC SQL INCLUDE SQLCA;
> EXEC SQL WHENEVER SQLERROR STOP;
> EXEC SQL CONNECT causp;
> EXEC SQL DELETE FROM skeletons WHERE id = 40;
> EXEC SQL DISCONNECT;
> }
>
> If I issue the command esqlc filename.sc, I'am getting the following
> error:
> ESQL TestKT.sc:
> %% Error in file TestKT.sc, Line 14:
> E_EQ0205 End of file found in middle of line.
> The current line will be ignored by the preprocessor.
>
> Can any one suggest what modifications need to be done in the program?

To my naked eye that looks fine (although I might have included the SQLCA
outside the scope of main()).

If you look in %II_SYSTEM%ingres\files do you see a file called eqdef.h?
That's what is being included, so it needs to be there. If you don't have
it, presumably you can get it from wherever you got the esqlc.exe. I have
no idea if you'd get the particular error you are seeing if it doesn't exist
though.

Roy
 >> Stay informed about: Embedded SQL 

Hi,
Now I am able to generate the '.c' file. But the problem is if I try
to compile the file it is showing the "unresolved external symbol"
errors. But the header files are included in the c program and the
header files contain the prototype of these functions. Still it is
throwing the errors.
Mohan
 >> Stay informed about: Embedded SQL 

Quoting :

> Hi,
> I could see the eqdef.h file at the location %II_SYSTEM%ingres\files.
> But still this program is throwing the same error.
> Mohan

First, try and compile this:

#include <stdio.h>

void main() {
}

If that works, continue with

#include <stdio.h>

void main() {
EXEC SQL INCLUDE SQLCA;
}

I'm expecting that to fail (it's another include command)..

if not just carry on adding code until you see the offending line.

As others have said, copying files one at a time is a really bad approach.

Paul
 >> Stay informed about: Embedded SQL 

Quoting :

> Hi,
> Now I am able to generate the '.c' file. But the problem is if I try
> to compile the file it is showing the "unresolved external symbol"
> errors. But the header files are included in the c program and the
> header files contain the prototype of these functions. Still it is
> throwing the errors.

Missing libraries, or incorrect library path probably..

> Mohan
>
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres.TakeThisOut@kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>


--
 >> Stay informed about: Embedded SQL 

You're welcome. BTW 'Edmonton Asian Escort'
(http://www.edmontonescortasiam.com) how far back do you suggest
answering 'Edmonton Escort' (http://www.edmontonescortasian.com) some of
these posted problems? 'Edmonton Escorts'
(http://www.edmontonescortasiam.com) See a lot of unanswered ones going
way back. 'Edmonton Asian Escorts' (http://www.edmontonescortasiam.com)


--
lzqqqq
------------------------------------------------------------------------
lzqqqq's Profile: http://community.ingres.com/forum/member.php?userid=112924
View this thread: http://community.ingres.com/forum/showthread.php?t=7994
 >> Stay informed about: Embedded SQL