<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html lang="en-us" xml:lang="en-us"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="security" content="public" /> <meta name="Robots" content="index,follow" /> <meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' /> <meta name="DC.Type" content="reference" /> <meta name="DC.Title" content="Manage an SQL package" /> <meta name="abstract" content="After an SQL package is created, you can manage it the same way you manage other objects on the iSeries server, with some restrictions." /> <meta name="description" content="After an SQL package is created, you can manage it the same way you manage other objects on the iSeries server, with some restrictions." /> <meta name="DC.subject" content="SQL package management, package management, SQL" /> <meta name="keywords" content="SQL package management, package management, SQL" /> <meta name="DC.Relation" scheme="URI" content="rbal1wrkpkg.htm" /> <meta name="DC.Relation" scheme="URI" content="rbal1dlt.htm" /> <meta name="DC.Relation" scheme="URI" content="rbal1modpack.htm" /> <meta name="DC.Relation" scheme="URI" content="rbal1droppack.htm" /> <meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" /> <meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" /> <meta name="DC.Format" content="XHTML" /> <meta name="DC.Identifier" content="rbal1sqlpack" /> <meta name="DC.Language" content="en-us" /> <!-- 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. --> <link rel="stylesheet" type="text/css" href="./ibmdita.css" /> <link rel="stylesheet" type="text/css" href="./ic.css" /> <title>Manage an SQL package</title> </head> <body id="rbal1sqlpack"><a name="rbal1sqlpack"><!-- --></a> <!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script> <h1 class="topictitle1">Manage an SQL package</h1> <div><p>After an SQL package is created, you can manage it the same way you manage other objects on the <span class="keyword">iSeries™ server</span>, with some restrictions.</p> <div class="section"><p>You can save and restore it, send it to other servers, and grant and revoke a user's authority to the package. You can also delete it by entering the <span class="cmdname">Delete Structured Query Language Package (DLTSQLPKG)</span> command or the DROP PACKAGE SQL statement.</p> </div> <div class="section"><p>When a distributed SQL program is created, the name of the SQL package and an internal consistency token are saved in the program. These are used at run time to find the SQL package and verify that the SQL package is correct for this program. Because the name of the SQL package is critical for running distributed SQL programs, an SQL package cannot be moved, renamed, duplicated, or restored to a different library.</p> </div> </div> <div> <ul class="ullinks"> <li class="ulchildlink"><strong><a href="rbal1dlt.htm">Delete an SQL package using the Delete SQL Package (DLTSQLPKG) command</a></strong><br /> You can use the <span class="cmdname">Delete Structured Query Language Package (DLTSQLPKG)</span> command to delete one or more SQL packages. You must enter the (<span class="cmdname">DLTSQLPKG</span>) command on the <span class="keyword">iSeries server</span> where the SQL package being deleted is located.</li> <li class="ulchildlink"><strong><a href="rbal1modpack.htm">Modify package authorizations</a></strong><br /> For any programs created on <span class="keyword">i5/OS™</span>, you can change the users that are authorized to use that package.</li> <li class="ulchildlink"><strong><a href="rbal1droppack.htm">Use the SQL DROP PACKAGE statement</a></strong><br /> The DROP PACKAGE statement includes the PACKAGE parameter for distributed relational database. You can issue the DROP PACKAGE statement by embedding it in a program or by using Interactive SQL.</li> </ul> <div class="familylinks"> <div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1wrkpkg.htm" title="An SQL package is an SQL object used specifically by distributed relational database applications. It contains control structures for each SQL statement that accesses data on an application server (AS).">Work with SQL packages</a></div> </div> </div> </body> </html>