Embedded SQL programming - IBM

1 IBM iDatabaseEmbedded SQL iDatabaseEmbedded SQL using this information and the product it supports, read the information in Notices, onpage edition applies to IBM i (product number 5770-SS1) and to all subsequent releases and modifications untilotherwise indicated in new editions. This version does not run on all reduced instruction set computer (RISC)models nor does it run on CISC models. Copyright IBM Corporation 1998, Government Users Restricted Rights Use, duplication or disclosure restricted by GSA ADP Schedule Contractwith IBM SQL 's new for IBM i file for Embedded SQL concepts and rules for using applications that use host variables in SQL rules for host variables in variables in applications that use SQL4 Indicator variables used with host structures5 Indicator variables used to assign SQL error return codes using the SQL diagnostics applications to use the SQLdiagnostics i programming notes on using the SQL : SQL routine.

2 Logging items from the SQLdiagnostics exception conditions with theWHENEVER SQL statements in C and C++ applications11 Defining the SQL communication area in C andC++ applications that use SQL descriptor areas in C and C++applications that use SQL statements in C and C++applications that use in C and C++ applications that for SQL statements in C andC++ applications that use code in C and C++ applications thatuse in C and C++ applications that in C and C++ applications that and NULs in C and C++ applicationsthat use labels in C and C++ applicationsthat use sequence for C and C++applications that use in C and C++ applications that statement in C and C++applications that use host variables in C and C++ applicationsthat use host variables in C and C++applications that use host variables in C and C++applications that use host variables in C and C++applications that use host variables in C and C++applications that use host variables in C and C++applications that use host

3 Variables in C and C++applications that use host variables in C and C++applications that use host variables in C and C++applications that use set locator host variables in C andC++ applications that use host structures in C and C++ applicationsthat use structure declarations in C and C++applications that use structure indicator array in C and C++applications that use arrays of host structures in C and C++applications that use structure array in C and C++applications that use structure array indicator structure in Cand C++ applications that use pointer data types in C and C++applications that use typedef in C and C++ applications thatuse ILE C compiler external file descriptions inC and C++ applications that use equivalent SQL and C or C++ on C and C++ variable declaration indicator variables in C and C++applications that use SQL statements in COBOL the SQL communication area in COBOL applications that use SQL descriptor areas in COBOL applications that use SQL

4 Statements in COBOL applications that use in COBOL applications that for SQL statements in COBOL applications that use code in COBOL applications thatuse in COBOL applications that use SQL48 Copyright IBM Corp. 1998, 2010iii||||||Sequence numbers in COBOL applicationsthat use in COBOL applications that use SQL48 COBOL compile-time options in COBOL applications that use labels in COBOL applications thatuse statement in COBOL applications that use source COBOL programs and theSQL COBOL host variables in COBOL applications thatuse host variables in COBOL applications that use host variables in COBOL applications that use host variables in COBOL applications that use host variables in COBOL applications

5 That use host variables in COBOL applications that use host variables in COBOL applications that use host variables in COBOL applicationsthat use host variables in COBOL applicationsthat use host variables in COBOL applications that use host variables in COBOL applications that use set locator host variables in COBOL applications that use host structures in COBOL applications thatuse structure in COBOL applications that structure indicator array in COBOL applications that use host structure arrays in COBOL applications that use structure array in COBOL applicationsthat use array indicator structure in COBOL applications that use external file descriptions in COBOL applications that use external file descriptions for hoststructure arrays in COBOL applications thatuse equivalent SQL and COBOL on COBOL variable declaration indicator variables in COBOL applicationsthat use SQL statements in PL/I the SQL communication area in PL/Iapplications that use SQL descriptor

6 Areas in PL/Iapplications that use SQL statements in PL/I applicationsthat use : Embedding SQL statements in PL/Iapplications that use in PL/I applications that use SQL76 Continuation for SQL statements in PL/Iapplications that use code in PL/I applications that in PL/I applications that use in PL/I applications that use labels in PL/I applications that statement in PL/I applicationsthat use host variables in PL/I applications that host variables in PL/I applicationsthat use variables in PL/Iapplications that use variables in PL/Iapplications that use host

7 Variables in PL/I applicationsthat use host variables in PL/I applicationsthat use host variables in PL/I applicationsthat use host structures in PL/I applications thatuse structures in PL/I applications that structure indicator arrays in PL/Iapplications that use host structure arrays in PL/I applicationsthat use structure array in PL/I applications thatuse structure array indicator in PL/Iapplications that use external file descriptions in PL/Iapplications that use equivalent SQL and PL/I data types86 Using indicator variables in PL/I applicationsthat use in PL/I because of structureparameter passing SQL statements in RPG/400 the SQL communication area inRPG/400 applications that use SQL descriptor areas in RPG/400applications that use SQL statements in RPG/400applications that use : Embedding SQL statements inRPG/400 applications that use in RPG/400 applications that i.

8 Database Embedded SQL programming ||||||Continuation for SQL statements in RPG/400applications that use code in RPG/400 applications thatuse numbers in RPG/400 applicationsthat use in RPG/400 applications that use SQL92 Statement labels in RPG/400 applications thatuse statement in RPG/400applications that use host variables in RPG/400 applicationsthat use host variables in RPG/400applications that use host structures in RPG/400 applicationsthat use host structure arrays in RPG/400applications that use external file descriptions in RPG/400applications that use file description considerations forhost structure arrays in RPG/400 applicationsthat use equivalent SQL and RPG/400 rules in RPG/400 applicationsthat use indicator variables in RPG/400applications that use.

9 Using indicator variables inRPG/400 applications that use in RPG/400 because of structureparameter passing ending a called RPG/400 program thatuses SQL statements in ILE RPG the SQL communication area in ILERPG applications that use SQL descriptor areas in ILE RPGapplications that use SQL statements in ILE RPGapplications that use in ILE RPG applications that for SQL statements in ILE RPGapplications that use code in ILE RPG applications thatuse directives in ILE RPG applications thatuse numbers in ILE RPG applicationsthat use in ILE RPG applications that use SQL10