Embedded SQL is an extension of a basic programming language that allows embedding ( embed ) commands of the structured SQL query language directly into the program text. Before a program using embedded SQL is compiled by the compiler of the base programming language, it must be processed by a special preprocessor .
Content
Systems that support embedded SQL
Altibase
- C / C ++ ( APRE is the built-in SQL precompiler provided by Altibase Corp. for its DBMS server.)
IBM DB2
IBM DB2 Version 9 for Linux, UNIX, and Windows supports embedded SQL for C, C ++, Java, COBOL, FORTRAN, and REXX , although support for FORTRAN and REXX is deprecated. [one]
Microsoft SQL Server
- C / C ++ (Starting with Microsoft SQL Server 2008, embedded SQL for C is deprecated, although earlier versions of the product support it. [2] )
Mimer SQL
- C / C ++ (Embedded SQL for C / C ++ is supported on Linux, OpenVMS, and Windows .)
- COBOL (Embedded SQL for COBOL is supported in OpenVMS .)
- Fortran (Embedded SQL for Fortran is supported in OpenVMS .)
Oracle Database
- Ada ( Pro * Ada was officially canceled by Oracle in version 7.3. Starting with Oracle 8, Pro * Ada has been replaced by the SQL * module, but does not seem to have been updated since. [3] The SQL * module is a module language that offers a programming method other than embedded SQL . The SQL * module supports the Ada 83 language standard for Ada .)
- C / C ++ ( Pro * C became Pro * C / C ++ with Oracle8. Pro * C / C ++ is currently supported in Oracle Database 11 g .)
- COBOL ( Pro * COBOL is currently supported with Oracle Database 11 g .)
- Fortran ( Pro * FORTRAN is no longer updated since Oracle 8, but Oracle will continue to release patches when errors are reported and patched.)
- Pascal ( Pro * Pascal has not been released since Oracle 8.)
- PL / I ( Pro * PL / I was not released with Oracle8 . However, the Pro * PL / I application for the Oracle Precompiler Guide continued to appear in the Oracle documentation library until release 11 g . Starting with version 12 c , Pro * PL / I was removed from the Oracle documentation library. [4] )
PostgreSQL
- C / C ++ ( ECPG has been part of PostgreSQL since version 6.3.)
- COBOL ( Cobol-IT now distributes the COBOL precompiler for PostgreSQL , while Micro Focus provides support through the OpenESQL preprocessor)
Raima Database Manager (RDM)
- Raima Database Manager 14.0 supports embedded SQL for C / C ++ and SQL PL [5]
SAP Sybase
- SAP Sybase ASE 15.7 supports embedded SQL for C and COBOL as part of the Sybase Software Developer Kit . [6]
- SAP Sybase SQL Anywhere supports embedded SQL for C and C ++ as part of the SQL Anywhere database management system. [7]
- SAP Sybase IQ supports embedded SQL for C and C ++ as part of the Sybase IQ database management system . [eight]
See also
- GPRE preprocessor
- SQLJ
Notes
- ↑ CM Garcia-Arellano, SS Lightstone, GM Lohman, V. Markl, AJ Storm. Autonomic features of the IBM DB2 universal database for linux, UNIX, and windows // IEEE Transactions on Systems, Man and Cybernetics, Part C (Applications and Reviews). - 2006-05. - T. 36 , no. 3 . - S. 365–376 . - ISSN 1094-6977 . - DOI : 10.1109 / tsmcc.2006.871572 .
- ↑ Installing Microsoft SQL Server 2008 // Pro SQL Server 2008 Administration. - Berkeley, CA: Apress, 2009. - S. 69-110 . - ISBN 9781430223733 , 9781430223740.
- ↑ YV Ravikumar, KM Krishnakumar, Nassyam Basha. Oracle Database Upgrades in Oracle Database Release 12.2 // Oracle Database Upgrade and Migration Methods. - Berkeley, CA: Apress, 2017. - S. 565-601 . - ISBN 9781484223277 , 9781484223284.
- ↑ A. Abdellatif, J. Le Bihan, M. Limame. Pro * C Precompiler // Oracle: A User's Guide. - London: Macmillan Education UK, 1990. - S. 65–87 . - ISBN 9780333542156 , 9781349120888.
- ↑ "Raima Technical Whitepaper" .
- ↑ Mitchell Kramer. Sybase IQ . - Boston, MA: Patricia Seybold Group, 2003-07.
- ↑ Mitchell Kramer. Sybase IQ . - Boston, MA: Patricia Seybold Group, 2003-07.
- ↑ Mitchell Kramer. Sybase IQ . - Boston, MA: Patricia Seybold Group, 2003-07.