Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Embedded SQL / Ada

 
   Database Forums (Home) -> Ingres RSS
Next:  Problem installing SQL Server 2000 Standard Editi..  
Author Message
jamieeverest

External


Since: Dec 03, 2004
Posts: 1



(Msg. 1) Posted: Fri Dec 03, 2004 4:38 am
Post subject: Embedded SQL / Ada
Archived from groups: comp>databases>ingres (more info?)

Hi,

I have some Embedded SQL Ada code that I need to preprocess so that I
am able to use it in an Ingres database that I am creating. I have
downloaded the latest version of Ingres (r3.0.1) from CA's website.
However, I notice that the Ada preprocessor is missing, even though
the preprocessors for the other languages (c, cobol, fortran) are
present. Does anybody know why this is?
I downloaded the source which seems to suggest that this is supported,
but I do not want the hassle of having to recompile all the library's
etc that are required.

Is this preprocessor available from any other source or are there any
other preprocessors for Ada that will produce code that will be usable
in Ingres?

Thanks
Jamie

 >> Stay informed about: Embedded SQL / Ada 
Back to top
Login to vote
Paul Mason5

External


Since: Jun 23, 2004
Posts: 5



(Msg. 2) Posted: Fri Dec 03, 2004 10:04 am
Post subject: Re: Embedded SQL / Ada [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

(Jamie Everest) wrote in message ...
 > Hi,
 >
 > I have some Embedded SQL Ada code that I need to preprocess so that I
 > am able to use it in an Ingres database that I am creating. I have
 > downloaded the latest version of Ingres (r3.0.1) from CA's website.
 > However, I notice that the Ada preprocessor is missing, even though
 > the preprocessors for the other languages (c, cobol, fortran) are
 > present. Does anybody know why this is?

I take it you mean the Windows version? The Linux version does have
the Ada precompiler.

The precompilers have always varied slightly from platform to platform
based on what compilers are available and were tested with. 2.6 on
Windows doesn't have support for ESQL/ADA either but neither does it
have ESQL/FORTRAN but it was added in r3. Also for instance VMS is the
only platform I know of that has ESQL/BASIC support.

 > I downloaded the source which seems to suggest that this is supported,
 > but I do not want the hassle of having to recompile all the library's
 > etc that are required.
 >
 > Is this preprocessor available from any other source or are there any
 > other preprocessors for Ada that will produce code that will be usable
 > in Ingres?
 >

I'm not sure but I *think* the problem with ADA on Windows is that the
compiler would be a GNU one which tend to use a different library
format. I know that I've tried in the past to e.g compile ABF using
GCC on Windows and had problems at the linking stage because of this.

In theory, especially with the source, it ought to be possible to get
it to work. In practice it may take quite a bit of work. You could run
your ADA program on Linux and connect to Windows via Ingres Net - is
that feasible for you?
It may be possible to get it to work by

 >> Stay informed about: Embedded SQL / Ada 
Back to top
Login to vote
Ingres Forums

External


Since: Oct 20, 2009
Posts: 12



(Msg. 3) Posted: Tue Nov 29, 2011 7:16 am
Post subject: Re: Embedded SQL / Ada [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I downloaded the source which seems to suggest that this is supported,
but I do not want the hassle of having to recompile all the library's
etc that are required.

thanks
CW
Mysite:'Divx Movies' (http://www.moovieland.com)


--
cyberworldukltd
------------------------------------------------------------------------
cyberworldukltd's Profile: http://community.actian.com/forum/member.php?userid=113664
View this thread: http://community.actian.com/forum/showthread.php?t=4667
 >> Stay informed about: Embedded SQL / Ada 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Embedded SQL - 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..

Embedded SQL programming - Hi, I am trying to pre-compile the following embedded SQl program: #include <stdio.h> void main() { EXEC SQL INCLUDE SQLCA; EXEC SQL WHENEVER SQLERROR STOP; EXEC SQL CONNECT causp; EXEC SQL DELETE FROM skeleton...

Process hanging on Endselect - We have a process which needs to produce an average figure over the last 16 qualifying weeks. The way it currently works is to select the rows from the two relevant tables ordered by date descending, then in a select loop check if the week qualifies and...

E_DM9063_LK_TABLE_MAXLOCKS - We have a weekly job that takes a COPY.OUT from the "Live" database and then does a COPY.IN to a development database in a separate installation. I've noticed that in one instance, the ERRLOG is getting a number of messages of the general form...

Help fo vnode - I am going to use the ingres replication. For that I have set vnodes using "netutil". I have configured all the things for replication on my local database using repmgr. Now I want to move the Configuration to the Remote Server database. When I...
   Database Forums (Home) -> Ingres All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]