PAL CARD CATALOG ENTRY

SHORT DESCRIPTION

ANSI standard binding to SQL


MOVEMENT WITHIN THE PAL CARD CATALOG
Move to top-level taxonomy
Move to keyword list

ASSET PROFILE

UNIT NAME
SQL2
VERSION
JUN90
REVIEW CODE
C1 1.0 B
INET ADDRESS
Not documented in PAL database
AUTHOR
IBM Corporation
RIGHTS
Approved for public release; distribution unlimited
COPYRIGHT
1990 IBM
DATE CREATED
14 Jun 90
DATE RELEASED
12 Nov 93
DATE LAST UPDATED
12 Nov 93
LOCATION
ASSET
PAL
ENVIRONMENT
Not documented in PAL database
LIMITATIONS
Not documented in PAL database
CERTIFICATION
Ada System Certifier_1 1.0
Date/Time of Processing: Tuesday   31 May       1994 01:28:40Am
Overall Assessment of System: OK
Classification of System: B
Basis of Classification --
Syntax Errors                               PASS
Completeness                                PASS
Independence from External Libraries        FAIL
Independence from a Specific Ada Compiler   PASS

Explanations for failures --
System withs non-standard library units that are not provided

Number of ...
Files              52
Library Units      52
Lines            9312
Statements       3467
Comments         2012

Unidentified Withed Units --
4 unidentified withed units
Subunits and Parent Units --
1 parent program units
0 missing parent units
2 subunits
0 subunits found but not specified
0 subunits specified but not found

FILE LISTING

Directory Display


languages/ada/bindings/sql/sql2:
  File Name                 Size
  ---------                 ----
  README                   1,495
  sql2.zip               109,794


Totals
  ==============  ==============
    2 Files              111,289

ABSTRACT

ASSET_A_159:  Ada/SQL Bindings
     The ANSI Standard binding of SQL to Ada (ANSI X3.168) specifies how
Ada  programs may access the services of relational databases which
conform to ANSI  Standard SQL (ANSI X3.135).  The ANSI binding uses
weak, primitive data types,  but most application programs need a
binding which deals with strong,  user-defined types.  To use the ANSI
binding in such circumstances, an  "abstract module" must be placed
between the application program and the ANSI  binding in order to raise
the level of abstraction of the binding.  A  specification for such an
abstract module is provided by "Guidelines for Use of  the SAME,"
Software Engineering Institute Technical Report CMU/SEI-89-TR-16.  
("SAME" is an acronym for "SQL/Ada Module Extensions.")  Unfortunately,
applying the SAME method without any automated support would be a
tedious task.   "Ada/SQL Bindings" provides the needed automated
support.  It presumes that an  implementation of the module version of
the ANSI Ada/SQL binding is provided by  the database vendor.  It then
permits a user to generate an abstract module  conforming to the SAME
method by instantiating Ada generics and executing the resulting
program.  
     Documents supporting this software are available.  They are
"General  Definition of Project" (ASSET_A_280;  DTIC # AD-A228481), and
"User's Manual  for a Prototype Binding of ANSI-Standard SQL to Ada
Supporting the SAME  Methodology" (ASSET_A_281; DTIC # AD-A228480).  


REVISION HISTORY

14 Jun 90   JUN90  Intermetrics   Initial release to ASSET
12 Nov 93   JUN90  ASSET          Initial release to the PAL


RELEASE NOTICE

This prologue must be included in all copies of this software.
Restrictions on use or distribution:  NONE


DISCLAIMER

	This software and its documentation are provided "AS IS" and
without any expressed or implied warranties whatsoever.  No warranties
as to performance, merchantability, or fitness for a particular
purpose exist.
	The user is advised to test the software thoroughly before
relying on it.  The user must assume the entire risk and liability of
using this software.  In no event shall any person or organization of
people be held responsible for any direct, indirect, consequential or
inconsequential damages or lost profits.