174 lines
11 KiB
HTML
174 lines
11 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="reference" />
|
||
|
|
<meta name="DC.Title" content="Display objects used by programs" />
|
||
|
|
<meta name="abstract" content="You can use the Display Program References (DSPPGMREF) command to determine which tables, data areas, and other programs are used by a program or SQL package. This information is only available for SQL packages and compiled programs and can be displayed, printed, or written to a database output file." />
|
||
|
|
<meta name="description" content="You can use the Display Program References (DSPPGMREF) command to determine which tables, data areas, and other programs are used by a program or SQL package. This information is only available for SQL packages and compiled programs and can be displayed, printed, or written to a database output file." />
|
||
|
|
<meta name="DC.subject" content="displaying, objects, command, DSPPGMREF (Display Program References), Display Program References (DSPPGMREF), command, CL, Display Program References (DSPPGMREF), program references" />
|
||
|
|
<meta name="keywords" content="displaying, objects, command, DSPPGMREF (Display Program References), Display Program References (DSPPGMREF), command, CL, Display Program References (DSPPGMREF), program references" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1admin.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1exdpr.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/dsppgmref.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/elem.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="rbal1dpref" />
|
||
|
|
<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>Display objects used by programs</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbal1dpref"><a name="rbal1dpref"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Display objects used by programs</h1>
|
||
|
|
<div><p>You can use the <span class="cmdname">Display Program References (DSPPGMREF)</span> command
|
||
|
|
to determine which tables, data areas, and other programs are used by a program
|
||
|
|
or SQL package. This information is only available for SQL packages and compiled
|
||
|
|
programs and can be displayed, printed, or written to a database output file.</p>
|
||
|
|
<div class="section"><p>When a program or package is created, the information about certain
|
||
|
|
objects used in the program or package is stored. This information is then
|
||
|
|
available for use with the <span class="cmdname">Display Program References (DSPPGMREF)</span> command.
|
||
|
|
Information retrieved can include: </p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><ul><li>The name of the program or package and its text description</li>
|
||
|
|
<li>The name of the library or collection containing the program or package</li>
|
||
|
|
<li>The number of objects referred to by the program package</li>
|
||
|
|
<li>The qualified name of the server object</li>
|
||
|
|
<li>The information retrieval dates</li>
|
||
|
|
<li>The object type of the referenced object</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>For files and tables, the record contains the following additional
|
||
|
|
fields: </p>
|
||
|
|
<ul><li>The name of the file or table in the program or package (possibly different
|
||
|
|
from the server object name if an override was in effect when the program
|
||
|
|
or package was created) <div class="note"><span class="notetitle">Note:</span> </div>
|
||
|
|
<p>Any overrides apply only on the application
|
||
|
|
requester (AR).</p>
|
||
|
|
</li>
|
||
|
|
<li>The program or package use of the file or table (input, output, update,
|
||
|
|
unspecified, or a combination of these four)</li>
|
||
|
|
<li>The number of record formats referenced, if any</li>
|
||
|
|
<li>The name of the record format used by the file or table and its record
|
||
|
|
format level identifier</li>
|
||
|
|
<li>The number of fields referenced for each format</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>Before the objects can be shown in a program, the user must have
|
||
|
|
*USE authority for the program. Also, of the libraries specified by the library
|
||
|
|
qualifier, only the libraries for which the user has read authority are searched
|
||
|
|
for the programs.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>The following table shows the objects for which the high-level
|
||
|
|
languages and utilities save information.</p>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div class="tablenoborder"><a name="rbal1dpref__rbal1lnut"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rbal1dpref__rbal1lnut" width="100%" frame="void" border="0" rules="none"><caption>Table 1. How high-level
|
||
|
|
languages save information about objects</caption><thead align="left"><tr><th align="left" valign="bottom" width="19.94949494949495%" id="d0e101">Language</th>
|
||
|
|
<th align="left" valign="bottom" width="19.94949494949495%" id="d0e103">Files</th>
|
||
|
|
<th align="left" valign="bottom" width="19.94949494949495%" id="d0e105">Programs</th>
|
||
|
|
<th align="left" valign="bottom" width="19.94949494949495%" id="d0e107">Data areas</th>
|
||
|
|
<th align="left" valign="bottom" width="20.2020202020202%" id="d0e109">See note</th>
|
||
|
|
</tr>
|
||
|
|
</thead>
|
||
|
|
<tbody><tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e101 ">CL</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e103 ">Yes</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e105 ">Yes</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e107 ">Yes</td>
|
||
|
|
<td align="left" valign="top" width="20.2020202020202%" headers="d0e109 ">1</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e101 ">COBOL/400<sup>®</sup> Language</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e103 ">Yes</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e105 ">Yes</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e107 ">No</td>
|
||
|
|
<td align="left" valign="top" width="20.2020202020202%" headers="d0e109 ">2</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e101 ">PL/I</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e103 ">Yes</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e105 ">Yes</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e107 ">N/A</td>
|
||
|
|
<td align="left" valign="top" width="20.2020202020202%" headers="d0e109 ">2</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e101 ">RPG/400<sup>®</sup> Language</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e103 ">Yes</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e105 ">No</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e107 ">Yes</td>
|
||
|
|
<td align="left" valign="top" width="20.2020202020202%" headers="d0e109 ">3</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e101 "><span class="keyword">DB2<sup>®</sup> UDB SQL</span></td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e103 ">Yes</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e105 ">N/A</td>
|
||
|
|
<td align="left" valign="top" width="19.94949494949495%" headers="d0e107 ">N/A</td>
|
||
|
|
<td align="left" valign="top" width="20.2020202020202%" headers="d0e109 ">4</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td colspan="5" align="left" valign="top" headers="d0e101 d0e103 d0e105 d0e107 d0e109 "> <div class="note"><span class="notetitle">Notes:</span> <ol><li>All server commands that refer to files, programs, or data areas specify
|
||
|
|
in the command definition that the information should be stored when the command
|
||
|
|
is compiled in a CL program. If a variable is used, the name of the variable
|
||
|
|
is used as the object name (for example, &FILE); If an expression is used,
|
||
|
|
the name of the object is stored as *EXPR. User-defined commands can also
|
||
|
|
store the information for files, programs, or data areas specified on the
|
||
|
|
commands. See the description of the FILE, PGM, and DTAARA parameters on the
|
||
|
|
PARM or ELEM command statements.</li>
|
||
|
|
<li>The program name is stored only when a literal is used for the program
|
||
|
|
name (this is a static call, for example, <samp class="codeph">CALL 'PGM1'</samp>), not
|
||
|
|
when a COBOL/400 identifier
|
||
|
|
is used for the program name (this is a dynamic call, for example, <samp class="codeph">CALL
|
||
|
|
PGM1</samp>).</li>
|
||
|
|
<li>The use of the local data area is not stored.</li>
|
||
|
|
<li>Information about SQL packages.</li>
|
||
|
|
</ol>
|
||
|
|
</div>
|
||
|
|
</td>
|
||
|
|
</tr>
|
||
|
|
</tbody>
|
||
|
|
</table>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>The stored file information contains an entry (a number) for the
|
||
|
|
type of use. In the database file output of the <span class="cmdname">Display Program References
|
||
|
|
(DSPPGMREF)</span> command (built when using the OUTFILE parameter), this
|
||
|
|
entry is a representation of one or more codes listed here. There can only
|
||
|
|
be one entry per object, so combinations are used. For example, a file coded
|
||
|
|
as a 7 would be used for input, output, and update. </p>
|
||
|
|
<dl><dt><strong>Code</strong></dt>
|
||
|
|
<dd><strong>Meaning</strong></dd>
|
||
|
|
<dt class="dlterm">1</dt>
|
||
|
|
<dd>Input</dd>
|
||
|
|
<dt class="dlterm">2</dt>
|
||
|
|
<dd>Output</dd>
|
||
|
|
<dt class="dlterm">3</dt>
|
||
|
|
<dd>Input and Output</dd>
|
||
|
|
<dt class="dlterm">4</dt>
|
||
|
|
<dd>Update</dd>
|
||
|
|
<dt class="dlterm">8</dt>
|
||
|
|
<dd>Unspecified</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1exdpr.htm">Example: Display program reference</a></strong><br />
|
||
|
|
To see what objects are used by an application requester (AR) program, you can enter a command as follows:</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1admin.htm" title="As an administrator for a distributed relational database, you are responsible for work being done on several servers.">Administration</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="../cl/dsppgmref.htm">Display Program References (DSPPGMREF) command</a></div>
|
||
|
|
<div><a href="../cl/elem.htm">Element definition (ELEM)</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|