153 lines
18 KiB
HTML
153 lines
18 KiB
HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
|
|
<html>
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
|
|
<meta name="Copyright" content="Copyright (c) 2006 by IBM Corporation">
|
|
<title>Structured Query Language (SQL) APIs</title>
|
|
<!-- Begin Header Records ========================================== -->
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
|
<!-- US Government Users Restricted Rights -->
|
|
<!-- Use, duplication or disclosure restricted by -->
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
|
<!-- Change History: -->
|
|
<!-- YYMMDD USERID Change description -->
|
|
<!-- 030218 JETAYLOR new for V5R3 -->
|
|
<!-- 030501 JETAYLOR replaced API and Exit listings with -->
|
|
<!-- pagegenerator output from javascript array -->
|
|
<!-- 031106 JETAYLOR replaced API and/or Exit listings with -->
|
|
<!-- pagegenerator output from javascript array -->
|
|
<!-- End Header Records -->
|
|
<link rel="stylesheet" type="text/css" href="../rzahg/ic.css">
|
|
</head>
|
|
<body>
|
|
<!--Java sync-link ================================================= -->
|
|
<script language="Javascript" src="../rzahg/synch.js" type="text/javascript">
|
|
</script>
|
|
|
|
|
|
|
|
<h2>Structured Query Language (SQL)APIs</h2>
|
|
|
|
<p>The SQL APIs are:</p>
|
|
<!-- ***** NOTE ***** Do not manually update text or links in this section. -->
|
|
<!-- Updates made in this section *will* be overlaid by automated tools -->
|
|
<!-- Notify User Technologies of needed updates to be made in XML for API finder.-->
|
|
<!--***************API BEGIN PASTE***************-->
|
|
<ul>
|
|
<li><A HREF="../db2/rbafzmstlabelon.htm">Add or replace labels in catalog descriptions</A> (LABEL) adds or replaces labels in the catalog descriptions of tables, views, aliases, packages, or columns.</li>
|
|
<li><A HREF="../db2/rbafzmstholdloc.htm">Allow LOB locator to retain association with value</A> (HOLD LOCATOR) allows a LOB locator variable to retain its association with a value beyond a unit of work.</li>
|
|
<li><A HREF="../db2/rbafzmstatabl.htm">Alter a table</A> (ALTER TABLE) alters the description of a table.</li>
|
|
<li><A HREF="../db2/rbafzmstsetpath.htm">Assign value to CURRENT PATH special register</A> (SET PATH) changes the value of the CURRENT PATH special register.</li>
|
|
<li><A HREF="../db2/rbafzmstsetschema.htm">Assign value to CURRENT SCHEMA special register</A> (SET SCHEMA) changes the value of the CURRENT SCHEMA special register.</li>
|
|
<li><A HREF="../db2/rbafzmstassignstmt.htm">Assign value to parameter or variable</A> (assignment-statement) assigns a value to an SQL parameter or SQL variable.</li>
|
|
<li><A HREF="../db2/rbafzmstsetinto.htm">Assign values to a host variable</A> (SET variable) produces a result table consisting of at most one row and assigns the values in that row to host variables.</li>
|
|
<li><A HREF="../db2/rbafzmstsettranv.htm">Assign values to a transition variable</A> (SET transition-variable) assigns values to a transition variable.</li>
|
|
<li><A HREF="../db2/rbafzmsthselin.htm">Assign values to host variables</A> (SELECT INTO) produces a result table consisting of at most one row, and assigns the values in that row to host variables.</li>
|
|
<li><A HREF="../db2/rbafzmstgotostmt.htm">Branch to user-defined label</A> (GOTO) branches to a user-defined label within an SQL routine or SQL trigger.</li>
|
|
<li><A HREF="../db2/rbafzmstcallsta.htm">Call a procedure</A> (CALL) calls a procedure.</li>
|
|
<li><A HREF="../db2/rbafzmstiteratestmt.htm">Cause flow of control to return to loop</A> (ITERATE) causes the flow of control to return to the beginning of a labelled loop.</li>
|
|
<li><A HREF="qsqchgdc.htm">Change Dynamic Default Collection</A> (QSQCHGDC) defines a default collection for unqualified table names in dynamically prepared statements or in dynamically executed statements.</li>
|
|
<li><A HREF="../db2/rbafzmstsettraj.htm">Change isolation level for unit of work</A> (SET TRANSACTION) sets the isolation level and read only attribute for the current unit of work.</li>
|
|
<li><A HREF="../db2/rbafzmstclosst.htm">Close a cursor</A> (CLOSE) closes a cursor.</li>
|
|
<li><A HREF="../db2/rbafzmstcomnt.htm">Comment on various objects</A> (COMMENT) replaces or adds a comment to the description of an alias, column, function, index, package, parameter, procedure, table, type or view.</li>
|
|
<li><A HREF="../db2/rbafzmstcon2t.htm">Connect to a server and establish rules (Type 2)</A> (CONNECT) connects an activation group within an application process to the identified server using the rules for application directed distributed unit of work.</li>
|
|
<li><A HREF="../db2/rbafzmstconj1.htm">Connect to server and establish rules (Type 1)</A> (CONNECT) connects an activation group within an application process to the identified server using the rules for remote unit of work.</li>
|
|
<li><A HREF="../db2/rbafzmstleavestmt.htm">Continue execution</A> (LEAVE) continues execution by leaving a block or loop.</li>
|
|
<li><A HREF="../db2/rbafzmstcrtudt.htm">Create a distinct type</A> (CREATE DISTINCT TYPE) defines a distinct type at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstcfso.htm">Create a function based on another existing function</A> (CREATE FUNCTION) creates a user-defined function, based on another existing scalar or column function, at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstcreatep.htm">Create a procedure</A> (CREATE PROCEDURE) defines a procedure at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstxcschema.htm">Create a schema and objects in that schema</A> (CREATE SCHEMA) defines a schema at the current server and optionally creates tables, views, aliases, indexes, and distinct types.</li>
|
|
<li><A HREF="../db2/rbafzmsthctabl.htm">Create a table</A> (CREATE TABLE) defines a table at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmsthctrigger.htm">Create a trigger</A> (CREATE TRIGGER) defines a trigger at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstcreatef.htm">Create a user-defined function</A> (CREATE FUNCTION) defines a user-defined function at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmsthcalias.htm">Create an alias</A> (CREATE ALIAS) defines an alias on a table, view, or member of a database file at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstcrtpef.htm">Create an external procedure</A> (CREATE PROCEDURE) defines an external procedure at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstcfsce.htm">Create an external scalar function</A> (CREATE FUNCTION) creates an external scalar function at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstcftbe.htm">Create an external table function</A> (CREATE FUNCTION) creates an external table function at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstxcindx.htm">Create an index on a table</A> (CREATE INDEX) creates an index on a table at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstcrtpsf.htm">Create an SQL procedure</A> (CREATE PROCEDURE) creates an SQL procedure at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstcfsc.htm">Create an SQL scalar function</A> (CREATE FUNCTION) creates an SQL scalar function at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstcftb.htm">Create an SQL table function</A> (CREATE FUNCTION) creates an SQL table function at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmsthcview.htm">Create view of table</A> (CREATE VIEW) creates a view on one or more tables or views at the current server.</li>
|
|
<li><A HREF="../db2/rbafzmstdclst.htm">Declare names identifying SQL statements</A> (DECLARE STATEMENT) is used for program documentation and declares names that are used to identify prepared SQL statements.</li>
|
|
<li><A HREF="../db2/rbafzmstdeclvar.htm">Declare subtype or CCSID</A> (DECLARE VARIABLE) is used to assign a subtype or CCSID other than the default to a host variable.</li>
|
|
<li><A HREF="../db2/rbafzmstdgtt.htm">Define a declared global temporary table</A> (DECLARE GLOBAL TEMPORARY TABLE) defines a declared temporary table for the current application process.</li>
|
|
<li><A HREF="../db2/rbafzmstwvrr.htm">Define actions to take on SQL return codes</A> (WHENEVER) specifies the action to be taken when a specified exception condition occurs.</li>
|
|
<li><A HREF="../db2/rbafzmstdclpef.htm">Define an external procedure</A> (DECLARE PROCEDURE) defines an external procedure.</li>
|
|
<li><A HREF="../db2/rbafzmsth2clcu.htm">Define an SQL cursor</A> (DECLARE CURSOR) defines an SQL cursor.</li>
|
|
<li><A HREF="../db2/rbafzmstdelst.htm">Delete rows from a table</A> (DELETE) deletes rows from a table or view.</li>
|
|
<li><A HREF="../db2/rbafzmstdescr.htm">Describe result columns</A> (DESCRIBE) obtains information about a prepared statement.</li>
|
|
<li><A HREF="../db2/rbafzmstdropst.htm">Drop an object</A> (DROP) drops an alias, function, index, package, procedure, schema, table, trigger, type, or view.</li>
|
|
<li><A HREF="../db2/rbafzmstc4comit.htm">End a unit of work</A> (COMMIT) ends a unit of work and commits the database changes made by that unit of work.</li>
|
|
<li><A HREF="../db2/rbafzmstrollbac.htm">End a unit of work</A> (ROLLBACK) ends a unit of work and back out all the relational database changes, or back out only the changes made after a savepoint was set.</li>
|
|
<li><A HREF="../db2/rbafzmstdiscon.htm">End connection</A> (DISCONNECT) ends one or more connections for unprotected conversations.</li>
|
|
<li><A HREF="../db2/rbafzmstsoption.htm">Establish options for processing SQL statements</A> (SET OPTION) establishes the processing options to be used for SQL statements.</li>
|
|
<li><A HREF="../db2/rbafzmsthselectstmt.htm">Execute a query</A> (SELECT) executes a query.</li>
|
|
<li><A HREF="../db2/rbafzmsthexeqt.htm">Execute prepared SQL statement</A> (EXECUTE) executes a prepared SQL statement.</li>
|
|
<li><A HREF="../db2/rbafzmstforstmt.htm">Execute statement for rows of a table</A> (FOR) executes a statement for each row of a table.</li>
|
|
<li><A HREF="qsqgnddl.htm">Generate Data Definition Language</A> (QSQGNDDL) generates the SQL data definition language statements required to recreate a database object.</li>
|
|
<li><A HREF="../db2/rbafzmstgntudtp.htm">Grant privilege on a distinct type</A> (GRANT) grants privileges on a distinct type.</li>
|
|
<li><A HREF="../db2/rbafzmstgntprc.htm">Grant privilege on a function or procedure</A> (GRANT) grants privileges on a function or procedure.</li>
|
|
<li><A HREF="../db2/rbafzmstgntpp.htm">Grant privilege on a package</A> (GRANT) grants privileges on a package.</li>
|
|
<li><A HREF="../db2/rbafzmstgnt.htm">Grant privileges on a table or view</A> (GRANT) grants privileges on tables or views.</li>
|
|
<li><A HREF="../db2/rbafzmstcompoundstmt.htm">Group statements in SQL routine</A> (compound-statement) groups other statements together in an SQL procedure.</li>
|
|
<li><A HREF="../db2/rbafzmsthsetrs.htm">Identify result sets in a procedure</A> (SET RESULT SET) identifies one or more result sets that can be returned from an external procedure when the procedure is called by a iSeries Access client, the SQL Call Level Interface, or when accessed from a remote system using DRDA.</li>
|
|
<li><A HREF="../db2/rbafzmstclucu.htm">Insert declarations into source program</A> (INCLUDE) inserts declarations or statements into a source program.</li>
|
|
<li><A HREF="../db2/rbafzmstbackup.htm">Insert rows into a table</A> (INSERT) inserts rows into a table or view.</li>
|
|
<li><A HREF="../db2/rbafzmstbegdcl.htm">Mark beginning of SQL declare section</A> (BEGIN DECLARE SECTION) marks the beginning of an SQL declare section.</li>
|
|
<li><A HREF="../db2/rbafzmsteds.htm">Mark end of SQL declare section</A> (END DECLARE SECTION) marks the end of an SQL declare section.</li>
|
|
<li><A HREF="../db2/rbafzmstdescrtb.htm">Obtain information about a table</A> (DESCRIBE TABLE) obtains information about a table or view.</li>
|
|
<li><A HREF="../db2/rbafzmstgetdiag.htm">Obtain information about SQL statement</A> (GET DIAGNOSTICS) obtains information about the previous SQL statement that was executed.</li>
|
|
<li><A HREF="../db2/rbafzmsthopen.htm">Open a cursor</A> (OPEN) opens a cursor.</li>
|
|
<li><A HREF="../db2/rbafzmstrele.htm">Place one or more connections in the release-pending state.</A> (RELEASE (Connection)) places one or more connections in the release-pending state.</li>
|
|
<li><A HREF="../db2/rbafzmstfets.htm">Position cursor on table</A> (FETCH) positions a cursor on a row of the result table, and can also assign values from one or more rows of the result table to host variables.</li>
|
|
<li><A HREF="../db2/rbafzmstpreph2.htm">Prepare an SQL statement for execution</A> (PREPARE) creates an executable form of an SQL statement from a character-string form of the statement.</li>
|
|
<li><A HREF="../db2/rbafzmstexim.htm">Prepare and execute an SQL statement</A> (EXECUTE IMMEDIATE) prepares and executes an SQL statement.</li>
|
|
<li><A HREF="../db2/rbafzmsth2lockt.htm">Prevent changing or using a table</A> (LOCK TABLE) prevents either concurrent processes from changing a table or prevents concurrent processes from using a table.</li>
|
|
<li><A HREF="qsqprced.htm">Process Extended Dynamic SQL</A> (QSQPRCED) processes Structured Query Language (SQL) extended dynamic statements in an SQL package object.</li>
|
|
<li><A HREF="../db2/rbafzmstifstmt.htm">Provide conditional execution</A> (IF) executes different sets of SQL statements based on the result of search conditions.</li>
|
|
<li><A HREF="../db2/rbafzmstvaluestmt.htm">Provide method to invoke function</A> (VALUES) provides a method to invoke a user-defined function from a trigger.</li>
|
|
<li><A HREF="../db2/rbafzmstrlssvpt.htm">Release savepoint within unit of work</A> (RELEASE SAVEPOINT) releases the identified savepoint and any subsequently established savepoints within a unit of work.</li>
|
|
<li><A HREF="../db2/rbafzmstfreeloc.htm">Remove association of LOB locator and its value</A> (FREE LOCATOR) removes the association between a LOB locator variable and its value.</li>
|
|
<li><A HREF="../db2/rbafzmstrena.htm">Rename a table, view, or index</A> (RENAME) renames a table, view, or index.</li>
|
|
<li><A HREF="../db2/rbafzmstloopstmt.htm">Repeat execution of a statement</A> (LOOP) repeats the execution of a statement or a group of statements.</li>
|
|
<li><A HREF="../db2/rbafzmstrepeatstmt.htm">Repeat execution of a statement</A> (REPEAT) executes a statement or group of statements until a search condition is true.</li>
|
|
<li><A HREF="../db2/rbafzmstwhilestmt.htm">Repeat execution of statement</A> (WHILE) repeats the execution of a statement while a specified condition is true.</li>
|
|
<li><A HREF="../db2/rbafzmstresignalstmt.htm">Resignal an error or warning condition</A> (RESIGNAL) is used within a handler to return an error or warning condition.</li>
|
|
<li><A HREF="../db2/rbafzmstreturnstmt.htm">Return from a routine</A> (RETURN) returns from a routine.</li>
|
|
<li><A HREF="../db2/rbafzmstrudtp.htm">Revoke distinct type privileges</A> (REVOKE) removes the privileges on a distinct type.</li>
|
|
<li><A HREF="../db2/rbafzmstrppro.htm">Revoke function or procedure privileges</A> (REVOKE) removes the privileges on a function or procedure.</li>
|
|
<li><A HREF="../db2/rbafzmstrppriv.htm">Revoke package privileges</A> (REVOKE) removes the privilege to execute statements in a package.</li>
|
|
<li><A HREF="../db2/rbafzmstrevoket.htm">Revoke table privileges</A> (REVOKE) removes privileges on a table or view.</li>
|
|
<li><A HREF="../db2/rbafzmstcasestmt.htm">Select path</A> (CASE) selects an execution path based on multiple conditions.</li>
|
|
<li><A HREF="../db2/rbafzmstsvpt.htm">Set a savepoint within unit of work</A> (SAVEPOINT) sets a savepoint within a unit of work to identify a point in time within the unit of work to which relational database changes can be rolled back.</li>
|
|
<li><A HREF="../db2/rbafzmstetconj.htm">Set connection to establish server</A> (SET CONNECTION) establishes the current server of the activation group by identifying one of its existing connections.</li>
|
|
<li><A HREF="../db2/rbafzmstsignalstmt.htm">Signals an error or warning condition</A> (SIGNAL) causes an error or warning to be returned with the specified SQLSTATE and optional message text.</li>
|
|
<li><A HREF="../db2/rbafzmstvalinto.htm">Specify a result table</A> (VALUES INTO) produces a result table consisting of at most one row and assigns the values in that row to host variables.</li>
|
|
<li><A HREF="sqludf_append.htm">SQL LOB Append to Locator</A> (sqludf_append()) appends data to the end of the LOB data the locator represents.</li>
|
|
<li><A HREF="sqludf_create_locator.htm">SQL LOB Create Locator</A> (sqludf_create_locator()) creates a LOB locator.</li>
|
|
<li><A HREF="sqludf_create_locator_with_ccsid.htm">SQL LOB Create Locator with CCSID</A> (sqludf_create_locator_with_ccsid()) creates a LOB locator with a given CCSID.</li>
|
|
<li><A HREF="sqludf_free_locator.htm">SQL LOB Free Locator</A> (sqludf_free_locator()) frees a LOB locator.</li>
|
|
<li><A HREF="sqludf_length.htm">SQL LOB Locator Length</A> (sqludf_length()) returns the length of the LOB data represented by a LOB locator.</li>
|
|
<li><A HREF="sqludf_substr.htm">SQL LOB Substring Locator</A> (sqludf_substr()) returns a substring of the LOB data the locator represents.</li>
|
|
<li><A HREF="qsqchks.htm">Syntax Check SQL Statement</A> (QSQCHKS) calls the DB2 for iSeries SQL parser to check the syntax of an SQL statement.</li>
|
|
<li><A HREF="../db2/rbafzmstupdt.htm">Update values of columns in rows of a table</A> (UPDATE) updates the values of specified columns in rows of a table or view.</li>
|
|
</ul>
|
|
<!--***************API END PASTE***************-->
|
|
|
|
<br>
|
|
|
|
|
|
<hr>
|
|
<center>
|
|
<table cellpadding="2" cellspacing="2">
|
|
<tr align="center">
|
|
<td valign="middle" align="center"><a href="#Top_Of_Page">Top</a> |
|
|
<a href= "file1.htm">Database and File APIs</a> |<a href=
|
|
"aplist.htm">APIs by category</a></td>
|
|
</tr>
|
|
</table>
|
|
</center>
|
|
</body>
|
|
</html>
|