SQL/MX Glossary

Glossary
HP NonStop SQL/MX Glossary—523732-002
Glossary-34
SQL program
with the SQL statements converted to comments and an SQL module definition file.
These two files are submitted to the host language compiler and to the SQL compiler
respectively.
SQL program. A host-language program containing embedded SQL statements to be
compiled by the SQL compiler.
SQL source file. A file written in C, C++, COBOL, or Java, containing both SQL and
programming language constructs.
SQL statement execution time. The time when an individual SQL statement in an SQL
program executes. Contrast with SQL compile time.
SQLCI. SQL/MP conversational interface. SQLCI enables a user to execute SQL/MP
statements and commands, and operate database utilities without embedding SQL in
an application. See also MXCI.
SQLCODE. A value returned to MXCI or an embedded SQL program to indicate the results
of executing an SQL statement. A program can use conditional statements to check
the SQLCODE value to determine the results of execution. The SQLCODE variable is
an integer message code specific to SQL/MX and does not comply with the ANSI
standard. See also SQL message code and SQLSTATE.
SQLJ. Also referred to as SQLJ Part 0, the “Database Language SQL—Part 10: Object
Language Bindings (SQL/OLB)” part of the ANSI SQL-2002 standard that allows static
SQL statements to be embedded directly in a Java program.
SQLJ customizer. Uses the profile (.ser file) and metadata information of each embedded
SQL statement in the profile to generate the module definition file (.m file) and extends
the profile with run-time information.
SQLJ translator. Translates, or precompiles, the SQLJ source file (.sqlj file) into the
Java source file (.java file) and the profile (.ser file).
SQLSTATE. A value returned to MXCI or an embedded SQL program to indicate the results
of executing an SQL statement. A program can use conditional statements to check
the SQLSTATE value to determine the results of execution. The SQLSTATE variable
complies with the ANSI standard and is a five-character string with two parts: the first
part is a two-character class code, and the second part is a three-character subclass
code. See also SQLCODE.
SQL-92. The American National Standards Institute (ANSI) version of SQL (structured query
language) that describes a purely relational database model. SQL-92 has been
replaced with SQL:1999.
SQL:1999. The American National Standards Institute (ANSI) version of SQL (structured
query language) that describes an object-relational database model. SQL:1999 is an
updated version of the SQL-92 standard. SQL/MX uses SQL:1999 to define,
manipulate, and control its databases.