Thread: Embedded SQL
View Single Post

   
  #4 (permalink)  
Old 02-26-2008, 10:17 AM
PM \(pm3iinc-nospam\)
 
Posts: n/a
Default Re: Embedded SQL

CLI is DB2 only right?
For multiple dbms that would be ODBC right? (ODBC is similar to CLI.)

PM

"Larry" <lsedels@us.ibm.com> a écrit dans le message de
news:3F3B8790.6EAB0EB8@us.ibm.com...
> Depends upon whether your SQL is static or not. And ... I don't believe MS

or
> Oracle support embedded SQL. You may want to take a more dynamic approach

and
> look at the CLI interface.
>
> Larry Edelstein
>
> Tomasz wrote:
>
> > Hi all
> > We plan to write large application (sales, purchase, accounting) in

C/C++.
> > It will work with DB2 and other databases (MS SQL and Oracle). Client

will
> > work under Win and Linux, so ADO and OLE DB aren't solution.
> > It seems ESQL standard is the only solution that allows to write such
> > application once and connect to different databases. Is this good

choice? Is
> > this fit for serious application? Will it be supported in the future?
> > In your opinion, which API would be the best solution?
> >
> > your help would be greatly appreciated
> > Tomasz

>



Reply With Quote