Re: SQL Existence Check

["Nathan M. Andelin" <nandelin@xxxxxxxxxxxxxxxxxxx>]

> From: <Frank.Kolmann@revlon.com>
> Pray tell what is the standard for business apps , I mean
> not simply for AS400s, but all systems.

SQL is available for nearly every relational database I can think of.  But I
suppose the more relevant point is whether programmers use it?  DB vendors
supply and recommend other interfaces, usually higher level.  That's what
programmers prefer.  OLE DB under Windows is a good example.  Each language
has a different interface.  In Delphi, it's one thing.  In Visual Basic it's
another.  In Visual Foxpro, another still.  COBOL's interfaces are probably
as cross-platform as SQL.

It seems to me that IBM supplies an SQL interface in addition to, rather
than as a replacement for native record level access.

I'm not sure what most Java programmers use?  It wouldn't surprise me if
developers and vendors were writing their own high-level interfaces as
wrappers around standard JDBC.

> C/Exec SQL  SELECT  DISTINCT RCFCUS  INTO :WCFCUS  from RCFRCM02
> C+ WHERE RCFCUS =  :RCFCUS   and RCFRUM = :RCFRUMA
> C/End-Exec

Did you leave out the code that defines WCFCUS on purpose?

Nathan M. Andelin
www.relational-data.com