Re: [open-cobol-list] Embedded SQL

[Sergey Kashyrin]

Hi John,

Unfortunately it will not work this way, at least not straightforward.
None of the C ESQL precompilers know about "S9(9)V9(2) COMP-3" and all Cobol 
precompilers are handling that.
We need to precompile in Cobol and have some runtime engine which will be able to pass the returned values into Cobol variables in 
appropriate format.

Another way of course is to pass ESQL to C precompiler replacing Cobol variables by the appropriate C variables (mostly strings 
because you can't use float/double for well known reason) and than insert the appropriate MOVEs from those intermidiate variables 
into the real one.
For current OC it will be more complicated to implement than to make Cobol 
precompiler (I guess).

Regards,
Sergey

> ----- Original Message ----- 
> From: "John" <address@hidden>
> To: <address@hidden>
> Sent: Sunday, November 25, 2007 3:53 PM
> Subject: [open-cobol-list] Embedded SQL
>
>
> > Dear all
> >
> > If Open COBOL works by precompiling COBOL to C and then passes that to
> > a C compiler, then surely the SQL precompiler should be in C?
> >
> > If Open COBOL passes across the SQL statements untouched (precompiling
> > the COBOL variables to C) then would that work?
> >
> > There are existing SQL precompilers for C for most database engines.
> >
> > John
> >
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2005.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > open-cobol-list mailing list
> > address@hidden
> > https://lists.sourceforge.net/lists/listinfo/open-cobol-list