193 lines
6.6 KiB
HTML
193 lines
6.6 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">
|
||
|
|
<title>Delete SQL Package (DLTSQLPKG)</title>
|
||
|
|
<link rel="stylesheet" type="text/css" href="../rzahg/ic.css">
|
||
|
|
</head>
|
||
|
|
<body bgcolor="white">
|
||
|
|
<script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<a name="DLTSQLPKG.Top_Of_Page"></a>
|
||
|
|
<h2>Delete SQL Package (DLTSQLPKG)</h2>
|
||
|
|
<table width="100%">
|
||
|
|
<tr>
|
||
|
|
<td valign="top" align="left"><b>Where allowed to run: </b>All environments (*ALL)<br>
|
||
|
|
<b>Threadsafe: </b>No
|
||
|
|
</td>
|
||
|
|
<td valign="top" align="right">
|
||
|
|
<a href="#DLTSQLPKG.PARAMETERS.TABLE">Parameters</a><br>
|
||
|
|
<a href="#DLTSQLPKG.COMMAND.EXAMPLES">Examples</a><br>
|
||
|
|
<a href="#DLTSQLPKG.ERROR.MESSAGES">Error messages</a></td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<div> <a name="DLTSQLPKG"></a>
|
||
|
|
<p>The Delete Structured Query Language Package (DLTSQLPKG) command is used to delete an SQL package or group of packages.
|
||
|
|
</p>
|
||
|
|
<p>DLTSQLPKG is a local command and must be used on the iSeries system where the SQL package being deleted is located.
|
||
|
|
</p>
|
||
|
|
<p>To delete an SQL package on a remote system that is also an iSeries system, use the Submit Remote Command (SBMRMTCMD) command to run the DLTSQLPKG command on the remote system.
|
||
|
|
</p>
|
||
|
|
<p>The user can do the following to delete an SQL package from a remote system that is not an iSeries system:
|
||
|
|
</p>
|
||
|
|
<ul>
|
||
|
|
<li>Use interactive SQL to run the CONNECT and DROP PACKAGE operations.
|
||
|
|
</li>
|
||
|
|
<li>Sign on the remote system and use a command local to that system.
|
||
|
|
</li>
|
||
|
|
<li>Create and run an SQL program that contains a DROP PACKAGE SQL statement.
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
<p><b>Restrictions:</b>
|
||
|
|
</p>
|
||
|
|
<ul>
|
||
|
|
<li>You cannot use the DLTSQLPKG command to delete an SQL package on a remote system. To delete an SQL package from a remote system, you can do one of the following:
|
||
|
|
<ul>
|
||
|
|
<li>Use interactive SQL to run the CONNECT and DROP PACKAGE statements.
|
||
|
|
</li>
|
||
|
|
<li>Sign on the remote system and use a command local to that system.
|
||
|
|
</li>
|
||
|
|
<li>Create and run an SQL program which contains a DROP PACKAGE SQL statement.
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>You must have object existence (*OBJEXIST) authority for the SQL package and read (*READ) authority for the library where the SQL package is located to use this command.
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#DLTSQLPKG.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
|
||
|
|
<div>
|
||
|
|
<h3><a name="DLTSQLPKG.PARAMETERS.TABLE">Parameters</a></h3>
|
||
|
|
<table border="1" cellpadding="4" cellspacing="0">
|
||
|
|
<!-- col1="10" col2="15" col3="30" col4="10" -->
|
||
|
|
<tr>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Keyword</th>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Description</th>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Choices</th>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Notes</th>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top" rowspan="3"><a href="#DLTSQLPKG.SQLPKG"><b>SQLPKG</b></a></td>
|
||
|
|
<td valign="top">SQL package</td>
|
||
|
|
<td valign="top"><i>Qualified object name</i></td>
|
||
|
|
<td valign="top" rowspan="3">Required, Positional 1</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top">Qualifier 1: SQL package</td>
|
||
|
|
<td valign="top"><i>Generic name, name</i></td>
|
||
|
|
</tr><tr>
|
||
|
|
<td valign="top">Qualifier 2: Library</td>
|
||
|
|
<td valign="top"><i>Name</i>, <b><u>*LIBL</u></b>, *CURLIB, *USRLIBL, *ALL, *ALLUSR</td>
|
||
|
|
</tr></table>
|
||
|
|
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#DLTSQLPKG.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
</div>
|
||
|
|
<div> <a name="DLTSQLPKG.SQLPKG"></a>
|
||
|
|
<h3>SQL package (SQLPKG)</h3>
|
||
|
|
<p>Specifies the SQL package to be deleted. Multiple SQL packages can be deleted by specifying a generic SQL package name.
|
||
|
|
</p>
|
||
|
|
<p><b>Qualifier 1: SQL package</b>
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b><i>generic-name</i></b></dt>
|
||
|
|
<dd>Specify the generic name of the SQL packages to be deleted. A generic name is a character string of one or more characters followed by an asterisk (*).
|
||
|
|
</dd>
|
||
|
|
<dt><b><i>name</i></b></dt>
|
||
|
|
<dd>Specify the name of the SQL package to be deleted.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<p><b>Qualifier 2: Library</b>
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b><u>*LIBL</u></b></dt>
|
||
|
|
<dd>All libraries in the library list for the current thread are searched until the first match is found.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<dl>
|
||
|
|
<dt><b>*CURLIB</b></dt>
|
||
|
|
<dd>The current library is searched. If no library is specified as the current library for the job, QGPL is used.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<dl>
|
||
|
|
<dt><b>*USRLIBL</b></dt>
|
||
|
|
<dd>If a current library entry exists in the library list for the current thread, the current library and the libraries in the user portion of the library list are searched. If there is no current library entry, only the libraries in the user portion of the library list are searched.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<dl>
|
||
|
|
<dt><b>*ALL</b></dt>
|
||
|
|
<dd>All libraries in the system, including QSYS, are searched.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<dl>
|
||
|
|
<dt><b>*ALLUSR</b></dt>
|
||
|
|
<dd>All user libraries are searched. All libraries with names that do not begin with the letter Q are searched except for the following:
|
||
|
|
<p>
|
||
|
|
<pre>
|
||
|
|
#CGULIB #DSULIB #SEULIB
|
||
|
|
#COBLIB #RPGLIB
|
||
|
|
#DFULIB #SDALIB
|
||
|
|
</pre>
|
||
|
|
</p>
|
||
|
|
<p>Although the following Qxxx libraries are provided by IBM, they typically contain user data that changes frequently. Therefore, these libraries are considered user libraries and are also searched:
|
||
|
|
</p>
|
||
|
|
<p>
|
||
|
|
<pre>
|
||
|
|
QDSNX QRCLxxxxx QUSRIJS QUSRVxRxMx
|
||
|
|
QGPL QSRVAGT QUSRINFSKR
|
||
|
|
QGPL38 QSYS2 QUSRNOTES
|
||
|
|
QMGTC QSYS2xxxxx QUSROND
|
||
|
|
QMGTC2 QS36F QUSRPOSGS
|
||
|
|
QMPGDATA QUSER38 QUSRPOSSA
|
||
|
|
QMQMDATA QUSRADSM QUSRPYMSVR
|
||
|
|
QMQMPROC QUSRBRM QUSRRDARS
|
||
|
|
QPFRDATA QUSRDIRCL QUSRSYS
|
||
|
|
QRCL QUSRDIRDB QUSRVI
|
||
|
|
</pre>
|
||
|
|
</p>
|
||
|
|
<ol>
|
||
|
|
<li>'xxxxx' is the number of a primary auxiliary storage pool (ASP).
|
||
|
|
</li>
|
||
|
|
<li>A different library name, in the format QUSRVxRxMx, can be created by the user for each previous release supported by IBM to contain any user commands to be compiled in a CL program for the previous release. For the QUSRVxRxMx user library, VxRxMx is the version, release, and modification level of a previous release that IBM continues to support.
|
||
|
|
</li>
|
||
|
|
</ol>
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<dl>
|
||
|
|
<dt><b><i>name</i></b></dt>
|
||
|
|
<dd>Specify the name of the library to be searched.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#DLTSQLPKG.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
<div><h3><a name="DLTSQLPKG.COMMAND.EXAMPLES">Examples</a> </h3>
|
||
|
|
<p>
|
||
|
|
<pre>
|
||
|
|
DLTSQLPKG SQLPKG(JONES)
|
||
|
|
</pre>
|
||
|
|
</p>
|
||
|
|
<p>This command deletes the SQL package JONES.
|
||
|
|
</p>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#DLTSQLPKG.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
<div><h3><a name="DLTSQLPKG.ERROR.MESSAGES">Error messages</a> </h3>
|
||
|
|
<p>None
|
||
|
|
</p>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#DLTSQLPKG.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
</body>
|
||
|
|
</html>
|