Thread: ECPG: include sqlca

ECPG: include sqlca

From
Michael Meskes
Date:
Hi,

I just got a bug report that originated in the programmer not knowing he had
to include sqlca to use whenever. When I told him he asked me why it isn't
included automatically. Now that's a tricky question. :-)

I do know that Oracle also asks the programmer to include sqlca, but how
about other DBs? Infromix? Sybase? DB2? Does anyone know that?

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!


Re: ECPG: include sqlca

From
"Zeugswetter Andreas SB SD"
Date:
Michael wrote:
> I just got a bug report that originated in the programmer not knowing he had
> to include sqlca to use whenever. When I told him he asked me why it isn't
> included automatically. Now that's a tricky question. :-)
> 
> I do know that Oracle also asks the programmer to include 
> sqlca, but how
> about other DBs? Infromix? Sybase? DB2? Does anyone know that?

Informix includes 
#include <sqlhdr.h>
#include <sqliapi.h>
automatically. 

sqlhdr.h then includes sqlca, sqlda, locator.h and most of the other headers.

Andreas


Re: ECPG: include sqlca

From
Bruce Momjian
Date:
Zeugswetter Andreas SB SD wrote:
> Michael wrote:
> > I just got a bug report that originated in the programmer not knowing he had
> > to include sqlca to use whenever. When I told him he asked me why it isn't
> > included automatically. Now that's a tricky question. :-)
> > 
> > I do know that Oracle also asks the programmer to include 
> > sqlca, but how
> > about other DBs? Infromix? Sybase? DB2? Does anyone know that?
> 
> Informix includes 
> #include <sqlhdr.h>
> #include <sqliapi.h>
> automatically. 
> 
> sqlhdr.h then includes sqlca, sqlda, locator.h and most of the other headers.

Also, we are allowed to be better than other databases.  I recommend
auto-include, perhaps with a message to the user.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: ECPG: include sqlca

From
Michael Meskes
Date:
On Wed, Jan 09, 2002 at 10:45:44AM -0500, Bruce Momjian wrote:
> > sqlhdr.h then includes sqlca, sqlda, locator.h and most of the other headers.
> 
> Also, we are allowed to be better than other databases.  I recommend
> auto-include, perhaps with a message to the user.

Very valid point. I will commit this in a few minutes.

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!