dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part2
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part2 [2021/07/30 15:12] murphy |
dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part2 [2021/08/17 15:22] (current) murphy |
||
|---|---|---|---|
| Line 15: | Line 15: | ||
| ==== Scope ==== | ==== Scope ==== | ||
| - | //This part of ISO/IEC 9075 defines the [[dido:public:ra:xapend:xapend.a_glossary:d:datastructure|data structures]] and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data.// | + | //This part of ISO/IEC 9075 defines the [[dido:public:ra:xapend:xapend.a_glossary:d:datastructure|data structures]] and basic operations on [[dido:public:ra:xapend:xapend.a_glossary:s:sql|SQL]]-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data.// |
| - | //This part of ISO/IEC 9075 specifies the syntax and semantics of a database language:// | + | //This part of ISO/IEC 9075 specifies the [[dido:public:ra:xapend:xapend.a_glossary:s:syntax|syntax]] and semantics of a database language:// |
| * //For specifying and modifying the structure and the integrity constraints of SQL-data.// | * //For specifying and modifying the structure and the integrity constraints of SQL-data.// | ||
| * //For declaring and invoking operations on SQL-data and cursors.// | * //For declaring and invoking operations on SQL-data and cursors.// | ||
| * //For declaring database language procedures.// | * //For declaring database language procedures.// | ||
| - | * //For embedding SQL-statements in a compilation unit that is otherwise written in a particular programming language (host language).// | + | * //For embedding SQL-statements in a compilation unit that is otherwise written in a particular [[dido:public:ra:xapend:xapend.a_glossary:p:programlang|programming language]] (host language).// |
| * //For deriving an equivalent compilation unit in the host language. In that equivalent compilation unit, each embedded SQL-statement has been replaced by one or more statements in the host language, some of which invoke an SQL externally-invoked procedure that, when executed, has an effect equivalent to executing the SQL-statement.// | * //For deriving an equivalent compilation unit in the host language. In that equivalent compilation unit, each embedded SQL-statement has been replaced by one or more statements in the host language, some of which invoke an SQL externally-invoked procedure that, when executed, has an effect equivalent to executing the SQL-statement.// | ||
| * //For direct invocation of SQL-statements.// | * //For direct invocation of SQL-statements.// | ||
| * //To support dynamic preparation and execution of SQL-statements.// | * //To support dynamic preparation and execution of SQL-statements.// | ||
| - | //This part of ISO/IEC 9075 provides a vehicle for portability of data definitions and compilation units between SQL-implementations.// | + | //This part of ISO/IEC 9075 provides a vehicle for [[dido:public:ra:xapend:xapend.a_glossary:p:portability|portability]] of data definitions and compilation units between SQL-implementations.// |
| //This part of ISO/IEC 9075 provides a vehicle for interconnection of SQL-implementations.// | //This part of ISO/IEC 9075 provides a vehicle for interconnection of SQL-implementations.// | ||
| - | //Implementations of this part of ISO/IEC 9075 can exist in environments that also support application programming languages, end-user query languages, report generator systems, data dictionary systems, program library systems, and distributed communication systems, as well as various tools for database design, data administration, and performance optimization.// | + | //Implementations of this part of ISO/IEC 9075 can exist in environments that also support application programming languages, end-user query languages, report generator systems, data dictionary systems, program library systems, and distributed communication systems, as well as various tools for database design, data administration, and [[dido:public:ra:xapend:xapend.a_glossary:p:performance|performance]] optimization.// |
| ==== See Also ==== | ==== See Also ==== | ||
dido/public/ra/xapend/xapend.b_stds/tech/iso/dblang_sql_part2.1627672344.txt.gz · Last modified: 2021/07/30 15:12 by murphy
