56 lines
4.7 KiB
HTML
56 lines
4.7 KiB
HTML
|
<?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="task" />
|
||
|
|
<meta name="DC.Title" content="Use the Create SQL Package (CRTSQLPKG) command" />
|
||
|
|
<meta name="abstract" content="You can enter the Create SQL Package (CRTSQLPKG) command to create an SQL package from a compiled distributed relational database program. You can also use this command to replace an SQL package that was created previously." />
|
||
|
|
<meta name="description" content="You can enter the Create SQL Package (CRTSQLPKG) command to create an SQL package from a compiled distributed relational database program. You can also use this command to replace an SQL package that was created previously." />
|
||
|
|
<meta name="DC.subject" content="application program, creating an SQL package, SQL package, creating with, CRTSQLPKG, command, CRTSQLPKG (Create Structured Query Language Package), Create Structured Query Language Package (CRTSQLPKG), command, CL, CRTSQLPKG (Create Structured Query Language Package), Create Structured Query Language Package (CRTSQLPKG), structured query language package, creating" />
|
||
|
|
<meta name="keywords" content="application program, creating an SQL package, SQL package, creating with, CRTSQLPKG, command, CRTSQLPKG (Create Structured Query Language Package), Create Structured Query Language Package (CRTSQLPKG), command, CL, CRTSQLPKG (Create Structured Query Language Package), Create Structured Query Language Package (CRTSQLPKG), structured query language package, creating" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1wrkpkg.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1defaultc.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/crtsqlpkg.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="rbal1sqlpkg" />
|
||
|
|
<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>Use the Create SQL Package (CRTSQLPKG) command</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbal1sqlpkg"><a name="rbal1sqlpkg"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Use the <span class="cmdname">Create SQL Package (CRTSQLPKG)</span> command</h1>
|
||
|
|
<div><p>You can enter the <span class="cmdname">Create SQL Package (CRTSQLPKG)</span> command
|
||
|
|
to create an SQL package from a compiled distributed relational database program.
|
||
|
|
You can also use this command to replace an SQL package that was created previously.</p>
|
||
|
|
<div class="section"> <p>A new SQL package is created on the relational
|
||
|
|
database defined by the RDB parameter. The new SQL package has the same name
|
||
|
|
and is placed in the same library as specified on the PKG parameter of the
|
||
|
|
CRTSQL<em>xxx</em> command. </p>
|
||
|
|
<p>You do not need the <span class="keyword">DB2<sup>®</sup> UDB Query Manager and SQL Development Kit</span> licensed
|
||
|
|
program to create an SQL package on an application server (AS).</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<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 class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="rbal1defaultc.htm" title="You can specify a default collection name to be used by an SQL program by supplying this name for the DFTRDBCOL parameter on the CRTSQLxxx command when you precompile the program.">Default collection name</a></div>
|
||
|
|
<div><a href="../cl/crtsqlpkg.htm">Create Structured Query Language Package (CRTSQLPKG) command</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|