Re: Compiler for Embedded SQl Macros

2006-01-02 Thread SGreen
Ezhilarasan Sammandam <[EMAIL PROTECTED]> wrote on 12/30/2005 08:53:36 
AM:

> Hi,
> 
> Is there any compiler to Compile Embedded SQL Macros into source codes
> for MySql?
> In otherwords, what is the equivalent of PRO*C (in Oracle)  in MySql?
> 
> Thanks,
> Ezhilarasan

STORED PROCEDURES and FUNCTIONS are part of V5.x.
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html

 Before that you can compile your own functions (also known as User 
Defined Functions) by following the directions in the manual. These are 
actually compiled modules that you load into the running server or 
physical extensions that become part of the server itslef (they call these 
"native functions") 
Full details: http://dev.mysql.com/doc/refman/4.1/en/adding-functions.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Compiler for Embedded SQl Macros

2005-12-30 Thread Ezhilarasan Sammandam
Hi,

Is there any compiler to Compile Embedded SQL Macros into source codes
for MySql?
In otherwords, what is the equivalent of PRO*C (in Oracle)  in MySql?

Thanks,
Ezhilarasan


Re: Embedded SQL

2001-12-20 Thread Sinisa Milivojevic

Raymond Wan writes:
> 
> Hi,
> 
>   I know there's a C API for MySQL, but I was just wondering if
> MySQL has a preprocessor that supports statements such as "EXEC SQL ..." 
> in a host language such as C.  The preprocessor would then replace these
> statements with calls to the C API. 
> 
>   I looked through the documentation and I could not find anything,
> so I'm thinking that either it does not exist or it is called something
> else, preventing me from finding it.  Also, I looked through the mailing
> list archive and noticed someone asked it but I did not find a response. 
> 
>   Any information would be appreciated; thanks in advance!
> 
> Ray

There are template queries in MySQL++. Take a look at them.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Embedded SQL

2001-12-20 Thread M. A. Alves

On Thu, 20 Dec 2001, Raymond Wan wrote:
> . . . I know there's a C API for MySQL, but I was just wondering if
> MySQL has a preprocessor that supports statements such as "EXEC SQL ..."
> in a host language such as C . . .

The thing (purportedely) exists for Ada (adapower.com).

However Ada is not "as C" in a number of traits, notably debbuging time
;-)

-- 
   ,
 M A R I O   data miner, LIACC, room 221   tel 351+226078830, ext 121
 A M A D O   Rua Campo Alegre, 823 fax 351+226003654
 A L V E S   P-4150-180 PORTO, Portugalmob 351+939354002



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Embedded SQL

2001-12-20 Thread Raymond Wan


Hi,

I know there's a C API for MySQL, but I was just wondering if
MySQL has a preprocessor that supports statements such as "EXEC SQL ..." 
in a host language such as C.  The preprocessor would then replace these
statements with calls to the C API. 

I looked through the documentation and I could not find anything,
so I'm thinking that either it does not exist or it is called something
else, preventing me from finding it.  Also, I looked through the mailing
list archive and noticed someone asked it but I did not find a response. 

Any information would be appreciated; thanks in advance!

Ray


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Embedded SQL?

2001-08-04 Thread Jeremy Zawodny

On Fri, Aug 03, 2001 at 03:35:11PM -0700, L. S. wrote:
>
> Is there Embedded SQL support for MySQL?

There is some embedded work goin on in the 4.0 (development) branch of
MySQL.  The manual describes how to get access to the 4.0 tree if
you'd like to check it out.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936 <-- NEW

MySQL 3.23.29: up 48 days, processed 390,305,509 queries (92/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php