From: Fred Butzen
Date: March 25 1999 8:12pm
Subject: ESQL-C and UNIONs
List-Archive: http://lists.mysql.com/mysql/974
Message-Id: <36FA98BD.A0E8710E@lepanto.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello.  I am new to MySQL; and I have two questions about it.  I've
combed through the MySQL manual and have not seen these issues
discussed, so I hope you'll pardon my asking questions that may be "old
hat" for MySQL veterans.

My questions are:

1. Is there an embedded-SQL preprocessor that translates ANSI ESQL-C
into the MySQL call-level interface?  Such preprocessors are a standard
feature of Informix and Sybase under Linux, and of other RDBMSs as well.
I have a great deal of code that is written in ESQL-C, and if a
preprocessor exists, it would save me a great deal of time in porting my
code to MySQL. (If someone were developing such a tool, I would gladly
beta-test it.)

2. Does MySQL support UNIONs of SELECT statements?  I suspect not; but
the manual does not mention them one way or the other.

Thanks much ...