friedkiwi/ibm-information-center
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
master
ibm-information-center/dist/eclipse/plugins/i5OS.ic.rzahf_5.4.0.1/rzahfaltermantable.htm

131 lines
9.1 KiB
HTML
Raw Permalink Normal View History

Add readme and dist folders
2024-04-02 14:02:31 +00:00
<?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="concept" />
<meta name="DC.Title" content="Alter and manage database objects" />
<meta name="abstract" content="The iSeries server provides both SQL and system methods for altering and managing the database objects you create. These links show you how to work with library, table, view, journal, alias, and index objects." />
<meta name="description" content="The iSeries server provides both SQL and system methods for altering and managing the database objects you create. These links show you how to work with library, table, view, journal, alias, and index objects." />
<meta name="DC.Relation" scheme="URI" content="rzahfdbadmin.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="rzahfaltermantable" />
<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>Alter and manage database objects</title>
</head>
<body id="rzahfaltermantable"><a name="rzahfaltermantable"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Alter and manage database objects</h1>
<div><p>The <span class="keyword">iSeries™</span> server
provides both SQL and system methods for altering and managing the database
objects you create. These links show you how to work with library, table,
view, journal, alias, and index objects.</p>
<p>There are several methods available for working with database objects.
You can use the <span class="keyword">iSeries</span> Navigator
interface, SQL methods, or the traditional file interface. The following table
shows the available options for each task. Click the appropriate “X” for more
information about performing the task.</p>
<p>The <span class="keyword">iSeries</span> Navigator tasks
are documented in the Online help. For more information about accessing <span class="keyword">iSeries</span> Navigator objects and using
Online help, see <a href="../rzatc/rzatccreateobj.htm"><span class="keyword">iSeries</span> Navigator database tasks</a>.</p>
<div class="p">
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><thead align="left"><tr><th align="left" valign="top" width="25%" id="d0e48">Task</th>
<th align="center" valign="top" width="25%" id="d0e50"><span class="keyword">iSeries</span> Navigator</th>
<th align="center" valign="top" width="25%" id="d0e55">SQL</th>
<th align="center" valign="top" width="25%" id="d0e57">Traditional file interface</th>
</tr>
</thead>
<tbody><tr><td valign="top" width="25%" headers="d0e48 ">Display table (file) attributes (catalog)</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "><a href="../db2/rbafzmstcatalog.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e57 "><a href="../dbp/rbafodfdes.htm">X</a></td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Drop database objects</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "><a href="../sqlp/rbafysqlpcdropping.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e57 "><a href="../cl/dltf.htm">X</a></td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Change schema (library) list</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "> </td>
<td align="center" valign="top" width="25%" headers="d0e57 "><a href="../cl/chglibl.htm">X</a></td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Add a column to a table</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "><a href="../sqlp/rbafyaddcol.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e57 "><a href="../cl/chgpf.htm">X</a></td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Add or alter an identity column</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "><a href="../sqlp/rbafysqlpidentity.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e57 "> </td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Change a table (file) definition</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "><a href="../sqlp/rbafyalter.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e57 "><a href="../dbp/rbafomngcom.htm">X</a></td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Copy a table (file)</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "> </td>
<td align="center" valign="top" width="25%" headers="d0e57 "><a href="../dbp/rbafocopytable.htm">X</a></td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Copy column definitions</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "> </td>
<td align="center" valign="top" width="25%" headers="d0e57 "> </td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Display contents of tables (files) and views</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "><a href="../sqlp/rbafyviewnt.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e57 "><a href="../dbp/rbaforddbf.htm">X</a></td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Display locked rows (records)</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "> </td>
<td align="center" valign="top" width="25%" headers="d0e57 "><a href="../dbp/rbafodsprcdlck.htm">X</a></td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Edit table (file) data</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "><a href="../sqlp/rbafydml.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e57 "><a href="../dbp/rbafoupdbr.htm">X</a></td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Move a table (file)</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "> </td>
<td align="center" valign="top" width="25%" headers="d0e57 "><a href="../dbp/rbafomovetable.htm">X</a></td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Reorganize a table (file)</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../dbp/rbaforrgton.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "> </td>
<td align="center" valign="top" width="25%" headers="d0e57 "><a href="../dbp/rbaforrgpf.htm">X</a></td>
</tr>
<tr><td valign="top" width="25%" headers="d0e48 ">Altering a sequence</td>
<td align="center" valign="top" width="25%" headers="d0e50 "><a href="../rzatc/rzatccreateobj.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e55 "><a href="../sqlp/rbafysequence.htm">X</a></td>
<td align="center" valign="top" width="25%" headers="d0e57 "> </td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzahfdbadmin.htm" title="See several topics that can help you to manage your database.">Database administration</a></div>
</div>
</div>
</body>
</html>
Reference in New Issue Copy Permalink