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.apis_5.4.0.1/qbnlpgmi.htm

2747 lines
82 KiB
HTML
Raw Permalink Blame History

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Copyright" content="Copyright (c) 2006 by IBM Corporation">
<title>List ILE Program Information (QBNLPGMI) API</title>
<!-- Begin Header Records ========================================== -->
<!-- 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. -->
<!-- QBNLPGM SCRIPT A converted by B2H R4.1 (346) (CMS) by HOLTJM at -->
<!-- RCHVMW2 on 5 Feb 1999 at 11:13:41 -->
<!-- Change History: -->
<!-- YYMMDD USERID Change description -->
<!--File Edited by Kersten Nov 2001 -->
<!--End Header Records -->
<link rel="stylesheet" type="text/css" href="../rzahg/ic.css">
</head>
<body>
<a name="Top_Of_Page"></a>
<!-- Java sync-link -->
<script type="text/javascript" language="Javascript" src="../rzahg/synch.js">
</script>
<h2>List ILE Program Information (QBNLPGMI) API</h2>
<div class="box" style="width: 80%;">
<br>
&nbsp;&nbsp;Required Parameter Group:<br>
<!-- iddvc RMBR -->
<br>
<table width="100%">
<tr>
<td align="center" valign="top" width="10%">1</td>
<td align="left" valign="top" width="50%">Qualified user space name</td>
<td align="left" valign="top" width="20%">Input</td>
<td align="left" valign="top" width="20%">Char(20)</td>
</tr>
<tr>
<td align="center" valign="top">2</td>
<td align="left" valign="top">Format name</td>
<td align="left" valign="top">Input</td>
<td align="left" valign="top">Char(8)</td>
</tr>
<tr>
<td align="center" valign="top">3</td>
<td align="left" valign="top">Qualified ILE program name</td>
<td align="left" valign="top">Input</td>
<td align="left" valign="top">Char(20)</td>
</tr>
<tr>
<td align="center" valign="top">4</td>
<td align="left" valign="top">Error Code</td>
<td align="left" valign="top">I/O</td>
<td align="left" valign="top">Char(*)</td>
</tr>
</table>
<br>
&nbsp;&nbsp;Default Public Authority: *USE<br>
<!-- iddvc RMBR -->
<br>
&nbsp;&nbsp;Threadsafe: No<br>
<!-- iddvc RMBR -->
<br>
</div>
<p>The List ILE Program Information (QBNLPGMI) API gives information about ILE
programs, similar to the Display Program (DSPPGM) command. The information is
placed in a user space specified by you.</p>
<p>If an original program model (OPM) program is specified for the qualified
ILE program name, an error is returned and the user space is not changed.</p>
<p>You can use the QBNLPGMI API to:</p>
<ul>
<li>List modules bound into an ILE program</li>
<li>List service programs bound to an ILE program</li>
<li>List data items exported to the activation group</li>
<li>List data item imports that are resolved by weak exports that were exported
to the activation group</li>
<li>List copyrights of an ILE program</li>
</ul>
<h3>Authorities and Locks</h3>
<dl>
<dt><em>User Space Authority</em></dt>
<dd>*CHANGE</dd>
<dt><em>User Space Library Authority</em></dt>
<dd>*EXECUTE</dd>
<dt><em>User Space Lock</em></dt>
<dd>*EXCLRD</dd>
<dt><em>Program Authority for PGML0100 and PGML0110 Formats</em></dt>
<dd>*USE</dd>
<dt><em>Program Authority for other Formats</em></dt>
<dd>*READ</dd>
<dt><em>Program Library Authority</em></dt>
<dd>*EXECUTE</dd>
<dt><em>Program Lock</em></dt>
<dd>*SHRRD</dd>
</dl>
<h3>Required Parameter Group</h3>
<dl>
<dt><strong>Qualified user space name</strong></dt>
<dd>INPUT; CHAR(20)
<p>The user space that is to receive the ILE program information. The first 10
characters contain the user space name, and the second 10 characters contain
the name of the library where the user space is located. The library name can
be a specific library name or one of these special values:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*CURLIB</em></td>
<td align="left" valign="top">The job's current library</td>
</tr>
<tr>
<td align="left" valign="top"><em>*LIBL</em></td>
<td align="left" valign="top">The library list</td>
</tr>
</table>
<br>
</dd>
<dt><strong>Format name</strong></dt>
<dd>INPUT; CHAR(8)
<p>The content and format of the information to be returned about the specified
programs. One of the following format names may be used:</p>
<table cellpadding="5">
<!-- cols="25 75" -->
<tr>
<td align="left" valign="top"><em><a href="#HDRPGMF1">PGML0100</a></em></td>
<td align="left" valign="top">ILE program module (*MODULE) information.</td>
</tr>
<tr>
<td align="left" valign="top"><em><a href="#HDRPGMF110">PGML0110</a></em></td>
<td align="left" valign="top">Variable length ILE program module (*MODULE)
information.
<p><strong>Note:</strong> Do not use the generic header entry size for format
PGML0110. Use the Size of this entry field returned in this format for the size
of each entry.</p>
</td>
</tr>
<tr>
<td align="left" valign="top"><em><a href="#HDRPGMF2">PGML0200</a></em></td>
<td align="left" valign="top">ILE service program (*SRVPGM) information.</td>
</tr>
<tr>
<td align="left" valign="top"><em><a href="#HDRPGMF3">PGML0300</a></em></td>
<td align="left" valign="top">Data items exported to the activation group
(*ACTGRPEXP).</td>
</tr>
<tr>
<td align="left" valign="top"><em><a href="#HDRPGMF4">PGML0400</a></em></td>
<td align="left" valign="top">Data item imports resolved by weak exports that
were exported to the activation group (*ACTGRPIMP).</td>
</tr>
<tr>
<td align="left" valign="top"><em><a href="#HDRPGMF5">PGML0500</a></em></td>
<td align="left" valign="top">ILE program copyright (*COPYRIGHT)
information.</td>
</tr>
</table>
<br>
</dd>
<dt><strong>Qualified ILE program name</strong></dt>
<dd>INPUT; CHAR(20)
<p>The name of the ILE program for which the information is to be listed. The
first 10 characters contain the ILE program name, and the second 10 characters
contain the name of the library where the ILE program is located.</p>
<p>The ILE program name can be a specific ILE program name or one of the
following special values:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*ALL</em></td>
<td align="left" valign="top">All ILE programs</td>
</tr>
<tr>
<td align="left" valign="top"><em>generic*</em></td>
<td align="left" valign="top">All ILE programs that begin with this generic
prefix. For example, WRK* would include all ILE programs that begin with
WRK.</td>
</tr>
</table>
<p>The library name can be a specific library name or one of these special
values:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*ALL</em></td>
<td align="left" valign="top">All libraries in the system</td>
</tr>
<tr>
<td align="left" valign="top"><em>*ALLUSR</em></td>
<td align="left" valign="top">All non-system libraries. For information on the
libraries included, see <a href="../apiref/genericlibname.htm#allusr">*ALLUSR</a> in Generic library names.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*CURLIB</em></td>
<td align="left" valign="top">The job's current library</td>
</tr>
<tr>
<td align="left" valign="top"><em>*LIBL</em></td>
<td align="left" valign="top">The library list</td>
</tr>
<tr>
<td align="left" valign="top"><em>*USRLIBL</em></td>
<td align="left" valign="top">Libraries listed in the user portion of the
library list</td>
</tr>
</table>
<br>
</dd>
<dt><strong>Error code</strong></dt>
<dd>I/O; CHAR(*)
<p>The structure in which to return error information. For the format of the
structure, see <a href="../apiref/error.htm#hdrerrcod">Error Code Parameter</a>.</p>
</dd>
</dl>
<br>
<h3><a name="HDRFLDLST2">Format of the Generated List</a></h3>
<p>The user space contains:</p>
<ul>
<li>A user area</li>
<li>A generic header</li>
<li>An input parameter section</li>
<li>A header section</li>
<li>A list data section</li>
</ul>
<p>For details about the user area and generic header, see <a href="../apiref/usf.htm">
User Space Format for List APIs</a>. For descriptions of each field in the list
returned, see <a href="#HDRPGMFD2">Field Descriptions</a>.</p>
<br>
<h3><a name="HDRPGMI2">Input Parameter Section</a></h3>
<table border width="80%">
<tr>
<th align="center" valign="bottom" colspan="2">Offset</th>
<th align="left" valign="bottom" rowspan="2">Type</th>
<th align="left" valign="bottom" rowspan="2">Field</th>
</tr>
<tr>
<th align="center" valign="bottom">Dec</th>
<th align="center" valign="bottom">Hex</th>
</tr>
<tr>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="LEFT" valign="TOP" width="20%">CHAR(10)</td>
<td align="LEFT" valign="TOP" width="60%">User space name specified</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">10</td>
<td align="CENTER" valign="TOP">A</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">User space library name specified</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">20</td>
<td align="CENTER" valign="TOP">14</td>
<td align="LEFT" valign="TOP">CHAR(8)</td>
<td align="LEFT" valign="TOP">Format name specified</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">28</td>
<td align="CENTER" valign="TOP">1C</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Program name specified</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">38</td>
<td align="CENTER" valign="TOP">26</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Program library name specified</td>
</tr>
</table>
<br>
<br>
<h3>Header Section</h3>
<table border width="80%">
<tr>
<th align="center" valign="bottom" colspan="2">Offset</th>
<th align="left" valign="bottom" rowspan="2">Type</th>
<th align="left" valign="bottom" rowspan="2">Field</th>
</tr>
<tr>
<th align="center" valign="bottom">Dec</th>
<th align="center" valign="bottom">Hex</th>
</tr>
<tr>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="LEFT" valign="TOP" width="20%">CHAR(10)</td>
<td align="LEFT" valign="TOP" width="60%">User space name used</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">10</td>
<td align="CENTER" valign="TOP">A</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">User space library name used</td>
</tr>
</table>
<br>
<br>
<h3><a name="HDRPGMF1">PGML0100 Format</a></h3>
<p>The PGML0100 format includes information on all the modules that are bound
into the programs specified. The modules will be listed in the user space in
the order the modules are bound into the program. You must have a program
authority of *USE to use this format. The following table shows how this
information for each module is organized. For detailed descriptions of the
fields in the list, see <a href="#HDRPGMFD2">Field Descriptions</a>.</p>
<table border width="80%">
<tr>
<th align="center" valign="bottom" colspan="2">Offset</th>
<th align="left" valign="bottom" rowspan="2">Type</th>
<th align="left" valign="bottom" rowspan="2">Field</th>
</tr>
<tr>
<th align="center" valign="bottom">Dec</th>
<th align="center" valign="bottom">Hex</th>
</tr>
<tr>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="LEFT" valign="TOP" width="20%">CHAR(10)</td>
<td align="LEFT" valign="TOP" width="60%">Program name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">10</td>
<td align="CENTER" valign="TOP">A</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Program library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">20</td>
<td align="CENTER" valign="TOP">14</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Bound module name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">30</td>
<td align="CENTER" valign="TOP">1E</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Bound module library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">40</td>
<td align="CENTER" valign="TOP">28</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Source file name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">50</td>
<td align="CENTER" valign="TOP">32</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Source file library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">60</td>
<td align="CENTER" valign="TOP">3C</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Source file member name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">70</td>
<td align="CENTER" valign="TOP">46</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Module attribute</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">80</td>
<td align="CENTER" valign="TOP">50</td>
<td align="LEFT" valign="TOP">CHAR(13)</td>
<td align="LEFT" valign="TOP">Module creation date and time</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">93</td>
<td align="CENTER" valign="TOP">5D</td>
<td align="LEFT" valign="TOP">CHAR(13)</td>
<td align="LEFT" valign="TOP">Source file updated date and time</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">106</td>
<td align="CENTER" valign="TOP">6A</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Sort sequence table name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">116</td>
<td align="CENTER" valign="TOP">74</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Sort sequence table library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">126</td>
<td align="CENTER" valign="TOP">7E</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Language identifier</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">136</td>
<td align="CENTER" valign="TOP">88</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Optimization level</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">140</td>
<td align="CENTER" valign="TOP">8C</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Maximum optimization level</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">144</td>
<td align="CENTER" valign="TOP">90</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Debug data</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">154</td>
<td align="CENTER" valign="TOP">9A</td>
<td align="LEFT" valign="TOP">CHAR(6)</td>
<td align="LEFT" valign="TOP">Release module created on</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">160</td>
<td align="CENTER" valign="TOP">A0</td>
<td align="LEFT" valign="TOP">CHAR(6)</td>
<td align="LEFT" valign="TOP">Release module created for</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">166</td>
<td align="CENTER" valign="TOP">A6</td>
<td align="LEFT" valign="TOP">CHAR(20)</td>
<td align="LEFT" valign="TOP">Reserved</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">186</td>
<td align="CENTER" valign="TOP">BA</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">User-modified</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">187</td>
<td align="CENTER" valign="TOP">BB</td>
<td align="LEFT" valign="TOP">CHAR(13)</td>
<td align="LEFT" valign="TOP">Licensed program</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">200</td>
<td align="CENTER" valign="TOP">C8</td>
<td align="LEFT" valign="TOP">CHAR(5)</td>
<td align="LEFT" valign="TOP">PTF number</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">205</td>
<td align="CENTER" valign="TOP">CD</td>
<td align="LEFT" valign="TOP">CHAR(6)</td>
<td align="LEFT" valign="TOP">APAR ID</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">211</td>
<td align="CENTER" valign="TOP">D3</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Creation data</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">212</td>
<td align="CENTER" valign="TOP">D4</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Module CCSID</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">216</td>
<td align="CENTER" valign="TOP">D8</td>
<td align="LEFT" valign="TOP">CHAR(8)</td>
<td align="LEFT" valign="TOP">Object control level</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">224</td>
<td align="CENTER" valign="TOP">E0</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Enable performance collection</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">225</td>
<td align="CENTER" valign="TOP">E1</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Profiling data</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">235</td>
<td align="CENTER" valign="TOP">EB</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Reserved</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">236</td>
<td align="CENTER" valign="TOP">EC</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Number of procedures</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">240</td>
<td align="CENTER" valign="TOP">F0</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Number of procedures block reordered</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">244</td>
<td align="CENTER" valign="TOP">F4</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Number of procedures block-order measured</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">248</td>
<td align="CENTER" valign="TOP">F8</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Teraspace storage enabled</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">249</td>
<td align="CENTER" valign="TOP">F9</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Storage model</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">250</td>
<td align="CENTER" valign="TOP">FA</td>
<td align="LEFT" valign="TOP">CHAR(74)</td>
<td align="LEFT" valign="TOP">Reserved</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">324</td>
<td align="CENTER" valign="TOP">144</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Number of SQL statements</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">328</td>
<td align="CENTER" valign="TOP">148</td>
<td align="LEFT" valign="TOP">CHAR(18)</td>
<td align="LEFT" valign="TOP">Relational database</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">346</td>
<td align="CENTER" valign="TOP">15A</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Commitment control</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">356</td>
<td align="CENTER" valign="TOP">164</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Allow copy of data</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">366</td>
<td align="CENTER" valign="TOP">16E</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Close SQL cursors</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">376</td>
<td align="CENTER" valign="TOP">178</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Naming convention</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">386</td>
<td align="CENTER" valign="TOP">182</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Date format</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">396</td>
<td align="CENTER" valign="TOP">18C</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Date separator</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">397</td>
<td align="CENTER" valign="TOP">18D</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Time format</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">407</td>
<td align="CENTER" valign="TOP">197</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Time separator</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">408</td>
<td align="CENTER" valign="TOP">198</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Delay PREPARE</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">418</td>
<td align="CENTER" valign="TOP">1A2</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Allow blocking</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">428</td>
<td align="CENTER" valign="TOP">1AC</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Default collection name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">438</td>
<td align="CENTER" valign="TOP">1B6</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">SQL package name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">448</td>
<td align="CENTER" valign="TOP">1C0</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">SQL package library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">458</td>
<td align="CENTER" valign="TOP">1CA</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Dynamic user profile</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">468</td>
<td align="CENTER" valign="TOP">1D4</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">SQL sort sequence table name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">478</td>
<td align="CENTER" valign="TOP">1DE</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">SQL sort sequence table library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">488</td>
<td align="CENTER" valign="TOP">1E8</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">SQL language identifier</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">498</td>
<td align="CENTER" valign="TOP">1F2</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Connection method</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">508</td>
<td align="CENTER" valign="TOP">1FC</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">SQL path length</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">512</td>
<td align="CENTER" valign="TOP">200</td>
<td align="LEFT" valign="TOP">CHAR(3483)</td>
<td align="LEFT" valign="TOP">SQL path</td>
</tr>
</table>
<br>
<br>
<h3><a name="HDRPGMF110">PGML0110 Format</a></h3>
<p>The PGML0110 format includes information on all the modules that are bound
into the programs specified. The modules will be listed in the user space in
the order the modules are bound into the program. You must have a program
authority of *USE to use this format. The following table shows how this
information for each module is organized. For detailed descriptions of the
fields in the list, see <a href="#HDRPGMFD2">Field Descriptions</a>.</p>
<p><strong>Note:</strong> Do not use the generic header entry size for this
format. Use the Size of this entry field returned in this format for the size
of each entry.</p>
<table border width="80%">
<tr>
<th align="center" valign="bottom" colspan="2">Offset</th>
<th align="left" valign="bottom" rowspan="2">Type</th>
<th align="left" valign="bottom" rowspan="2">Field</th>
</tr>
<tr>
<th align="center" valign="bottom">Dec</th>
<th align="center" valign="bottom">Hex</th>
</tr>
<tr>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="LEFT" valign="TOP" width="20%">BINARY(4)</td>
<td align="LEFT" valign="TOP" width="60%">Size of this entry</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">4</td>
<td align="CENTER" valign="TOP">4</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Program name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">14</td>
<td align="CENTER" valign="TOP">E</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Program library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">24</td>
<td align="CENTER" valign="TOP">18</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Bound module name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">34</td>
<td align="CENTER" valign="TOP">22</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Bound module library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">44</td>
<td align="CENTER" valign="TOP">2C</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Source file name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">54</td>
<td align="CENTER" valign="TOP">36</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Source file library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">64</td>
<td align="CENTER" valign="TOP">40</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Source file member name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">74</td>
<td align="CENTER" valign="TOP">4A</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Module attribute</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">84</td>
<td align="CENTER" valign="TOP">54</td>
<td align="LEFT" valign="TOP">CHAR(13)</td>
<td align="LEFT" valign="TOP">Module creation date and time</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">97</td>
<td align="CENTER" valign="TOP">61</td>
<td align="LEFT" valign="TOP">CHAR(13)</td>
<td align="LEFT" valign="TOP">Source file updated date and time</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">110</td>
<td align="CENTER" valign="TOP">6E</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Sort sequence table name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">120</td>
<td align="CENTER" valign="TOP">78</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Sort sequence table library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">130</td>
<td align="CENTER" valign="TOP">82</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Language identifier</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">140</td>
<td align="CENTER" valign="TOP">8C</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Optimization level</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">144</td>
<td align="CENTER" valign="TOP">90</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Maximum optimization level</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">148</td>
<td align="CENTER" valign="TOP">94</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Debug data</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">158</td>
<td align="CENTER" valign="TOP">9E</td>
<td align="LEFT" valign="TOP">CHAR(6)</td>
<td align="LEFT" valign="TOP">Release module created on</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">164</td>
<td align="CENTER" valign="TOP">A4</td>
<td align="LEFT" valign="TOP">CHAR(6)</td>
<td align="LEFT" valign="TOP">Release module created for</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">170</td>
<td align="CENTER" valign="TOP">AA</td>
<td align="LEFT" valign="TOP">CHAR(20)</td>
<td align="LEFT" valign="TOP">Reserved</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">190</td>
<td align="CENTER" valign="TOP">BE</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">User-modified</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">191</td>
<td align="CENTER" valign="TOP">BF</td>
<td align="LEFT" valign="TOP">CHAR(13)</td>
<td align="LEFT" valign="TOP">Licensed program</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">204</td>
<td align="CENTER" valign="TOP">CC</td>
<td align="LEFT" valign="TOP">CHAR(5)</td>
<td align="LEFT" valign="TOP">PTF number</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">209</td>
<td align="CENTER" valign="TOP">D1</td>
<td align="LEFT" valign="TOP">CHAR(6)</td>
<td align="LEFT" valign="TOP">APAR ID</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">215</td>
<td align="CENTER" valign="TOP">D7</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Creation data</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">216</td>
<td align="CENTER" valign="TOP">D8</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Module CCSID</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">220</td>
<td align="CENTER" valign="TOP">DC</td>
<td align="LEFT" valign="TOP">CHAR(8)</td>
<td align="LEFT" valign="TOP">Object control level</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">228</td>
<td align="CENTER" valign="TOP">E4</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Enable performance collection</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">229</td>
<td align="CENTER" valign="TOP">E5</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Profiling data</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">239</td>
<td align="CENTER" valign="TOP">EF</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Reserved</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">240</td>
<td align="CENTER" valign="TOP">F0</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Number of procedures</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">244</td>
<td align="CENTER" valign="TOP">F4</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Number of procedures block reordered</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">248</td>
<td align="CENTER" valign="TOP">F8</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Number of procedures block-order measured</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">252</td>
<td align="CENTER" valign="TOP">FC</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Teraspace storage enabled</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">253</td>
<td align="CENTER" valign="TOP">FD</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Storage model</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">254</td>
<td align="CENTER" valign="TOP">FE</td>
<td align="LEFT" valign="TOP">CHAR(2)</td>
<td align="LEFT" valign="TOP">Reserved</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">256</td>
<td align="CENTER" valign="TOP">100</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Offset to Licensed Internal Code options</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">260</td>
<td align="CENTER" valign="TOP">104</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Length of Licensed Internal Code options</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">264</td>
<td align="CENTER" valign="TOP">108</td>
<td align="LEFT" valign="TOP">CHAR(64)</td>
<td align="LEFT" valign="TOP">Reserved</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">328</td>
<td align="CENTER" valign="TOP">148</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Number of SQL statements</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">332</td>
<td align="CENTER" valign="TOP">14C</td>
<td align="LEFT" valign="TOP">CHAR(18)</td>
<td align="LEFT" valign="TOP">Relational database</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">350</td>
<td align="CENTER" valign="TOP">15E</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Commitment control</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">360</td>
<td align="CENTER" valign="TOP">168</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Allow copy of data</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">370</td>
<td align="CENTER" valign="TOP">172</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Close SQL cursors</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">380</td>
<td align="CENTER" valign="TOP">17C</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Naming convention</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">390</td>
<td align="CENTER" valign="TOP">186</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Date format</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">400</td>
<td align="CENTER" valign="TOP">190</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Date separator</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">401</td>
<td align="CENTER" valign="TOP">191</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Time format</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">411</td>
<td align="CENTER" valign="TOP">19B</td>
<td align="LEFT" valign="TOP">CHAR(1)</td>
<td align="LEFT" valign="TOP">Time separator</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">412</td>
<td align="CENTER" valign="TOP">19C</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Delay PREPARE</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">422</td>
<td align="CENTER" valign="TOP">1A6</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Allow blocking</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">432</td>
<td align="CENTER" valign="TOP">1B0</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Default collection name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">442</td>
<td align="CENTER" valign="TOP">1BA</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">SQL package name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">452</td>
<td align="CENTER" valign="TOP">1C4</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">SQL package library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">462</td>
<td align="CENTER" valign="TOP">1CE</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Dynamic user profile</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">472</td>
<td align="CENTER" valign="TOP">1D8</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">SQL sort sequence table name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">482</td>
<td align="CENTER" valign="TOP">1E2</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">SQL sort sequence table library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">492</td>
<td align="CENTER" valign="TOP">1EC</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">SQL language identifier</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">502</td>
<td align="CENTER" valign="TOP">1F6</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Connection method</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">512</td>
<td align="CENTER" valign="TOP">200</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">SQL path length</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">516</td>
<td align="CENTER" valign="TOP">204</td>
<td align="LEFT" valign="TOP">CHAR(3483)</td>
<td align="LEFT" valign="TOP">SQL path</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">1074</td>
<td align="CENTER" valign="TOP">432</td>
<td align="LEFT" valign="TOP">CHAR(*)</td>
<td align="LEFT" valign="TOP">Reserved</td>
</tr>
<tr>
<td align="LEFT" valign="TOP" colspan="4">Bound module information through
offsets</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">&nbsp;</td>
<td align="CENTER" valign="TOP">&nbsp;</td>
<td align="LEFT" valign="TOP">CHAR(*)</td>
<td align="LEFT" valign="TOP">Licensed Internal Code options</td>
</tr>
</table>
<br>
<br>
<h3><a name="HDRPGMF2">PGML0200 Format</a></h3>
<p>The PGML0200 format includes information on all the service programs that
are bound to the programs specified. The following table shows how this
information is organized. For detailed descriptions of the fields in the list,
see <a href="#HDRPGMFD2">Field Descriptions</a>.</p>
<table border width="80%">
<tr>
<th align="center" valign="bottom" colspan="2">Offset</th>
<th align="left" valign="bottom" rowspan="2">Type</th>
<th align="left" valign="bottom" rowspan="2">Field</th>
</tr>
<tr>
<th align="center" valign="bottom">Dec</th>
<th align="center" valign="bottom">Hex</th>
</tr>
<tr>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="LEFT" valign="TOP" width="20%">CHAR(10)</td>
<td align="LEFT" valign="TOP" width="60%">Program name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">10</td>
<td align="CENTER" valign="TOP">A</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Program library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">20</td>
<td align="CENTER" valign="TOP">14</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Bound service program name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">30</td>
<td align="CENTER" valign="TOP">1E</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Bound service program library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">40</td>
<td align="CENTER" valign="TOP">28</td>
<td align="LEFT" valign="TOP">CHAR(16)</td>
<td align="LEFT" valign="TOP">Bound service program signature</td>
</tr>
</table>
<br>
<br>
<h3><a name="HDRPGMF3">PGML0300 Format</a></h3>
<p>The PGML0300 format lists data items exported to the activation group. The
list data items are specified in the data export entry in the binding
specifications component when the module was created. The following table shows
how this information is organized. For detailed descriptions of the fields in
the list, see <a href="#HDRPGMFD2">Field Descriptions</a>.</p>
<table border width="80%">
<tr>
<th align="center" valign="bottom" colspan="2">Offset</th>
<th align="left" valign="bottom" rowspan="2">Type</th>
<th align="left" valign="bottom" rowspan="2">Field</th>
</tr>
<tr>
<th align="center" valign="bottom">Dec</th>
<th align="center" valign="bottom">Hex</th>
</tr>
<tr>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="LEFT" valign="TOP" width="20%">CHAR(10)</td>
<td align="LEFT" valign="TOP" width="60%">Program name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">10</td>
<td align="CENTER" valign="TOP">A</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Program library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">20</td>
<td align="CENTER" valign="TOP">14</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Size of data item export</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">24</td>
<td align="CENTER" valign="TOP">18</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Data item export name CCSID</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">28</td>
<td align="CENTER" valign="TOP">1C</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Data item export name length</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">32</td>
<td align="CENTER" valign="TOP">20</td>
<td align="LEFT" valign="TOP">CHAR(256)</td>
<td align="LEFT" valign="TOP">Data item export name</td>
</tr>
</table>
<br>
<br>
<h3><a name="HDRPGMF4">PGML0400 Format</a></h3>
<p>The PGML0400 format lists data item imports that were resolved by weak
exports that had been exported to an activation group. The following table
shows how this information is organized. For detailed descriptions of the
fields in the list, see <a href="#HDRPGMFD2">Field Descriptions</a>.</p>
<table border width="80%">
<tr>
<th align="center" valign="bottom" colspan="2">Offset</th>
<th align="left" valign="bottom" rowspan="2">Type</th>
<th align="left" valign="bottom" rowspan="2">Field</th>
</tr>
<tr>
<th align="center" valign="bottom">Dec</th>
<th align="center" valign="bottom">Hex</th>
</tr>
<tr>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="LEFT" valign="TOP" width="20%">CHAR(10)</td>
<td align="LEFT" valign="TOP" width="60%">Program name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">10</td>
<td align="CENTER" valign="TOP">A</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Program library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">20</td>
<td align="CENTER" valign="TOP">14</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Data item import name CCSID</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">24</td>
<td align="CENTER" valign="TOP">18</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Data item import name length</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">28</td>
<td align="CENTER" valign="TOP">1C</td>
<td align="LEFT" valign="TOP">CHAR(256)</td>
<td align="LEFT" valign="TOP">Data item import name</td>
</tr>
</table>
<br>
<br>
<h3><a name="HDRPGMF5">PGML0500 Format</a></h3>
<p>The PGML0500 format includes copyright information for the ILE programs
specified. The following table shows how this information is organized. For
detailed descriptions of the fields in the list, see <a href="#HDRPGMFD2">Field
Descriptions</a>.</p>
<table border width="80%">
<tr>
<th align="center" valign="bottom" colspan="2">Offset</th>
<th align="left" valign="bottom" rowspan="2">Type</th>
<th align="left" valign="bottom" rowspan="2">Field</th>
</tr>
<tr>
<th align="center" valign="bottom">Dec</th>
<th align="center" valign="bottom">Hex</th>
</tr>
<tr>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="CENTER" valign="TOP" width="10%">0</td>
<td align="LEFT" valign="TOP" width="20%">CHAR(10)</td>
<td align="LEFT" valign="TOP" width="60%">Program name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">10</td>
<td align="CENTER" valign="TOP">A</td>
<td align="LEFT" valign="TOP">CHAR(10)</td>
<td align="LEFT" valign="TOP">Program library name</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">20</td>
<td align="CENTER" valign="TOP">14</td>
<td align="LEFT" valign="TOP">CHAR(4)</td>
<td align="LEFT" valign="TOP">Reserved</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">24</td>
<td align="CENTER" valign="TOP">18</td>
<td align="LEFT" valign="TOP">BINARY(4)</td>
<td align="LEFT" valign="TOP">Copyright length</td>
</tr>
<tr>
<td align="CENTER" valign="TOP">28</td>
<td align="CENTER" valign="TOP">1C</td>
<td align="LEFT" valign="TOP">CHAR(256)</td>
<td align="LEFT" valign="TOP">Copyright</td>
</tr>
</table>
<br>
<br>
<h3><a name="HDRPGMFD2">Field Descriptions</a></h3>
<p><strong>Allow blocking.</strong> Whether blocking will be used to improve
the performance of certain SQL statements. The possible values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*NONE</em></td>
<td align="left" valign="top">Blocking is not used.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*READ</em></td>
<td align="left" valign="top">Blocking is used for read-only cursors when
running COMMIT(*NONE) and there are no EXECUTE or EXECUTE IMMEDIATE
statements.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*ALLREAD</em></td>
<td align="left" valign="top">Blocking is used for all read-only cursors when
running COMMIT(*NONE) or COMMIT(*CHG).</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>Allow copy of data.</strong> Whether a copy of the data can be used
in the implementation of an SQL query. The possible values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*NO</em></td>
<td align="left" valign="top">A copy of the data cannot be used.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*YES</em></td>
<td align="left" valign="top">A copy of the data can be used when needed.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*OPTIMIZE</em></td>
<td align="left" valign="top">The system determines whether a copy of the data
is used for optimal performance.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>APAR ID.</strong> The module was changed as the result of the
authorized program analysis report (APAR) with this identification number. This
is blank if the module was not changed at bind time.</p>
<p><strong>Bound module library name.</strong> The name of the library
containing the module bound into this program at bind time.</p>
<p><strong>Bound module name.</strong> The name of the module bound into this
program. This is a copy of the module that was bound into this program. It is
not the *MODULE object on the system.</p>
<p><strong>Bound service program library name.</strong> The name of the library
containing the service program bound to the program at bind time. This is the
library name in which the activation expects to find the service program at run
time. Hexadecimal zeros indicate the library list is used at the time the
service program is needed.</p>
<p><strong>Bound service program name.</strong> The name of the service program
bound to the program.</p>
<p><strong>Bound service program signature.</strong> The current signature of
the service program at the time it was bound to the program.</p>
<p><strong>Close SQL cursors.</strong> Specifies when SQL cursors are
implicitly closed and SQL-prepared statements are implicitly discarded. The
possible values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*ENDMOD</em></td>
<td align="left" valign="top">When the module ends.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*ENDACTGRP</em></td>
<td align="left" valign="top">When the activation group is deleted.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>Commitment control.</strong> The level of commitment control that
was specified on the SQL precompile. The possible values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*NONE</em></td>
<td align="left" valign="top">No commitment control was specified on the SQL
precompile. Uncommitted changes in other jobs can be seen.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*CHG</em></td>
<td align="left" valign="top">Objects referred to in SQL COMMENT ON, CREATE,
DROP, GRANT, LABEL ON, and REVOKE statements, and updated, deleted, or inserted
rows (records) are locked until the end of the unit of work (transaction).
Uncommitted changes in other jobs can be seen.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*CS</em></td>
<td align="left" valign="top">Objects referred to in SQL COMMENT ON, CREATE,
DROP, GRANT, LABEL ON, and REVOKE statements, and updated, deleted, and
inserted rows (records) are locked until the end of the unit of work
(transaction). A row (record) that is selected but not updated is locked until
the next row (record) is selected. Uncommitted changes in other jobs cannot be
seen.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*ALL</em></td>
<td align="left" valign="top">Objects referred to in SQL COMMENT ON, CREATE,
DROP, GRANT, LABEL ON, and REVOKE statements, and all rows selected, updated,
deleted, and inserted are locked until the end of the unit of work
(transaction). Uncommitted changes in other jobs cannot be seen.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>Connection method.</strong> The method used for establishing remote
connections when running distributed programs.</p>
<p>Special values that can be returned are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*RUW</em></td>
<td align="left" valign="top">Only one connection to a relational database is
allowed. Consecutive CONNECT statements result in the previous connection being
disconnected before a new connection is established.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*DUW</em></td>
<td align="left" valign="top">Connections to several relational databases are
allowed. Consecutive CONNECT statements to additional relational databases does
not result in disconnection of previous connects. SET CONNECTION can be used to
switch between connections. Read-only connections may result.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>Copyright.</strong> The copyright string included in this
program.</p>
<p><strong>Copyright length.</strong> The length of the copyright string.</p>
<p><strong>Creation data.</strong> Whether the bound module has all creation
data and if that data is
observable or unobservable.
</p>
<table cellpadding="5">
<!-- cols="5 95" -->
<tr>
<td align="left" valign="top"><em>0</em></td>
<td align="left" valign="top">*NO. Not all the creation data is present in the
bound module.</td>
</tr>
<tr>
<td align="left" valign="top"><em>1</em></td>
<td align="left" valign="top">*YES. The creation data is present in the bound
module and all of that data is observable.</td>
</tr>
<tr>
<td align="left" valign="top"><em>2</em></td>
<td align="left" valign="top">*UNOBS. The creation data is present in the bound
module but not all of that data is observable.</td>
</tr>
</table>
<p><strong>Data item export name.</strong> Data items that are exported to an
activation group. These data items can be used outside of the module or program
that they are defined in.</p>
<p><strong>Data item export name CCSID.</strong> The coded character set
identifier (CCSID) for the name of this data item export.</p>
<p><strong>Data item export name length.</strong> The length of the name of the
data export item.</p>
<p><strong>Data item import name.</strong> The name of the data item imports
that were resolved by weak exports that had been exported to the activation
group.</p>
<p><strong>Data item import name CCSID.</strong> The coded character set
identifier (CCSID) for the name of this data item import.</p>
<p><strong>Data item import name length.</strong> The length of the name of the
data import item.</p>
<p><strong>Date format.</strong> The format used when accessing date-result
columns through SQL. All output date fields are returned in this format. For
input date strings, the value you specify is used to determine whether the date
is a valid format. The values returned are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*USA</em></td>
<td align="left" valign="top">USA format (mm/dd/yyyy).</td>
</tr>
<tr>
<td align="left" valign="top"><em>*ISO</em></td>
<td align="left" valign="top">International Standards Organization format
(yyyy-mm-dd).</td>
</tr>
<tr>
<td align="left" valign="top"><em>*EUR</em></td>
<td align="left" valign="top">European format (dd.mm.yyyy).</td>
</tr>
<tr>
<td align="left" valign="top"><em>*JIS</em></td>
<td align="left" valign="top">Japanese Industrial Standard Christian Era
(yyyy-mm-dd).</td>
</tr>
<tr>
<td align="left" valign="top"><em>*MDY</em></td>
<td align="left" valign="top">Month/day/year format (mm/dd/yy).</td>
</tr>
<tr>
<td align="left" valign="top"><em>*DMY</em></td>
<td align="left" valign="top">Day/month/year format (dd/mm/yy).</td>
</tr>
<tr>
<td align="left" valign="top"><em>*YMD</em></td>
<td align="left" valign="top">Year/month/day format (yy/mm/dd).</td>
</tr>
<tr>
<td align="left" valign="top"><em>*JUL</em></td>
<td align="left" valign="top">Julian format (a numeric value from 1 to
365).</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>Date separator.</strong> The separator used when accessing
date-result columns. This information is blank if the module does not contain
SQL statements; however, the number of SQL statements field should be checked
to determine if the module contains SQL statements. This is because a blank may
be specified as a separator value.</p>
<p><strong>Debug data.</strong> Whether debug data was generated when this
module was created. If debug data exists, the module may be debugged using the
source debugger. The possible values are:</p>
<table cellpadding="5">
<!-- cols="10 90" -->
<tr>
<td align="left" valign="top"><em>*YES</em></td>
<td align="left" valign="top">Debug data was generated.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*NO</em></td>
<td align="left" valign="top">Debug data was not generated.</td>
</tr>
</table>
<p><strong>Default collection name.</strong> The collection name used for the
unqualified names of tables, views, indexes, and SQL packages. The possible
values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*NONE</em></td>
<td align="left" valign="top">There is no default collection name.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>Delay PREPARE.</strong> Whether SQL prepare processing can be
delayed until the statement is actually used. The possible values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*YES</em></td>
<td align="left" valign="top">Prepare processing can be delayed.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*NO</em></td>
<td align="left" valign="top">Prepare processing cannot be delayed.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>Dynamic user profile.</strong> The user profile used for dynamic SQL
statements. The following special values can be returned:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*USER</em></td>
<td align="left" valign="top">Local dynamic SQL statements are run under the
profile of the module's user. Distributed dynamic SQL statements are run under
the profile of the SQL package's user.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*OWNER</em></td>
<td align="left" valign="top">Local dynamic SQL statements are run under the
profile of the module's owner. Distributed dynamic SQL statements are run under
the profile of the SQL package's owner.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>Enable performance collection.</strong> The level of performance
collection enabled for this module. The following values can be returned:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top" nowrap><em>'00'X *NONE or '10'X *PEP</em></td>
<td align="left" valign="top">This gives the entry/exit information for the PEP
only. No entry/exit hooks in the module's internal procedures and no precall or
postcall hooks around calls to other procedures are included.
<p><strong>Note:</strong> If *NONE is shown and the module was created or
re-created on an iSeries server running Version 3 Release 6 Modification 0 prior to the
installation of PTF MF11968, the module will not have any performance
collection enabled. To enable performance collection, use one of the following
commands and specify ENBFPRCOL(*PEP):</p>
<ul>
<li>Change Module (CHGMOD)</li>
<li>Change Program (CHGPGM)</li>
<li>Change Service Program (CHGSRVPGM)</li>
</ul>
</td>
</tr>
<tr>
<td align="left" valign="top" nowrap><em>'50'X *ENTRYEXIT *NONLEAF</em></td>
<td align="left" valign="top">This gives the entry/exit information on all of
the non-leaf procedures in the module. This includes the PEP routine. This is
useful to capture information on most routines but not at the expense of
destroying the 'leaf-ness' of the leaf procedures.</td>
</tr>
<tr>
<td align="left" valign="top" nowrap><em>'70'X *ENTRYEXIT *ALLPRC</em></td>
<td align="left" valign="top">This gives the entry/exit information on all the
procedures of the module (including those that were leaf procedures). This
includes the PEP routine. This is useful to capture information on all
procedures.</td>
</tr>
<tr>
<td align="left" valign="top" nowrap><em>'D0'X *FULL *NONLEAF</em></td>
<td align="left" valign="top">This gives the entry/exit information on all the
procedures of the module that are not leaf procedures. This includes the PEP
routine. Precall and postcall hooks around calls to external procedures are
also included.</td>
</tr>
<tr>
<td align="left" valign="top"><em>'F0'X *FULL *ALLPRC</em></td>
<td align="left" valign="top">This gives the entry/exit information on all
procedures of the module (including those that were leaf procedures). This
includes the PEP routine. Precall and postcall hooks around calls to external
procedures are also included. This is useful to capture information on all
procedures.</td>
</tr>
</table>
<p><strong>Format name specified.</strong> The format used to return the ILE
program information to the user space.</p>
<p><strong>Language identifier.</strong> Returns the 3-character language
identifier used when the module was compiled. The following special values can
also be returned:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*JOBRUN</em></td>
<td align="left" valign="top">The language identifier associated with the job
at the time the program that the module is bound into runs.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain any language
identification information.</td>
</tr>
</table>
<p><strong>Length of Licensed Internal Code options.</strong> The size, in
two-byte characters, of the Licensed Internal Code options string. This will be
0 if no Licensed Internal Code options were used for this module.</p>
<p><strong>Licensed Internal Code options.</strong> The Licensed Internal Code
options that are in use by the module. This field is specified in UCS-2 (CCSID
13488).</p>
<p><strong>Licensed program.</strong> If the module was part of a licensed
program at bind time, this field shows the product number and the level of the
licensed program. This is blank if the module is not part of a licensed program
at bind time.</p>
<p><strong>Maximum optimization level.</strong> The highest level of
optimization this module could have at bind time. If observability has been
removed from the module, this maximum optimization level value might not be the
same as the one specified when the module was created. Possible values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>65535</em></td>
<td align="left" valign="top">The module is not restricted to a maximum
optimization level. It can be retranslated to any of the supported optimization
levels. 65535 is also known as *NOMAX.</td>
</tr>
<tr>
<td align="left" valign="top"><em>40</em></td>
<td align="left" valign="top">Maximum level of optimization. This level
includes all the optimizations performed at optimization level 30. In addition,
it includes optimization that disables call and instruction tracing. Thus,
tracing of modules created at this optimization level cannot be done.</td>
</tr>
<tr>
<td align="left" valign="top"><em>30</em></td>
<td align="left" valign="top">More optimization is performed in addition to
those performed at optimization level 20. Variables cannot be changed but can
be displayed while the program is being debugged. However, the displayed value
of the variable during debugging may not be its actual value. 30 is also known
as *FULL.</td>
</tr>
<tr>
<td align="left" valign="top"><em>20</em></td>
<td align="left" valign="top">Some optimization is performed on the generated
code. When the module optimized at this level is being debugged, the variables
can be displayed but not changed. This level improves the performance of the
module slightly over level 10. 20 is also known as *BASIC.</td>
</tr>
<tr>
<td align="left" valign="top"><em>10</em></td>
<td align="left" valign="top">No additional optimization is performed on the
generated code. Variables can be displayed and changed when the program is
being debugged. With no optimization of the code, this value provides the
lowest level of module performance. 10 is also known as *NONE.</td>
</tr>
</table>
<p><strong>Module attribute.</strong> The language used in the module. This
field can be blank (for example, when a module is created by a compilation
process internal to IBM).</p>
<p><strong>Module CCSID.</strong> The coded character set identifier (CCSID)
for this module.</p>
<p><strong>Module creation date and time.</strong> The date and time the module
was created. The creation date and time field is in the CYYMMDDHHMMSS format as
follows:</p>
<table cellpadding="5">
<!-- cols="10 90" -->
<tr>
<td align="left" valign="top"><em>C</em></td>
<td align="left" valign="top">Century, where 0 indicates years 19<em>xx</em>
and 1 indicates years 20<em>xx</em>.</td>
</tr>
<tr>
<td align="left" valign="top"><em>YY</em></td>
<td align="left" valign="top">Year</td>
</tr>
<tr>
<td align="left" valign="top"><em>MM</em></td>
<td align="left" valign="top">Month</td>
</tr>
<tr>
<td align="left" valign="top"><em>DD</em></td>
<td align="left" valign="top">Day</td>
</tr>
<tr>
<td align="left" valign="top"><em>HH</em></td>
<td align="left" valign="top">Hour</td>
</tr>
<tr>
<td align="left" valign="top"><em>MM</em></td>
<td align="left" valign="top">Minute</td>
</tr>
<tr>
<td align="left" valign="top"><em>SS</em></td>
<td align="left" valign="top">Second</td>
</tr>
</table>
<p><strong>Naming convention.</strong> The convention used for naming objects
in SQL statements. The possible values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*SQL</em></td>
<td align="left" valign="top">The SQL naming convention is used.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*SYS</em></td>
<td align="left" valign="top">The system naming convention is used.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>Number of procedures.</strong> The number of procedures defined in
the module. This number includes the program entry procedure (PEP), if one was
generated by the compiler for this module.</p>
<p><strong>Number of procedures block-order measured.</strong> The number of
procedures defined in the module that had block-order profiling data collected
at the time block-order profiling data was applied. If the module does not have
block-order profiling data applied, this value will be zero.</p>
<p><strong>Number of procedures block reordered.</strong> The number of
procedures defined in the module that are block reordered. If the module does
not have block-order profiling data applied, this value will be zero. This
value can decrease if the program that this bound module is contained in is
retranslated.</p>
<p><strong>Number of SQL statements.</strong> The number of SQL statements
contained in the module. This value is zero if the module does not contain SQL
statements.</p>
<p><strong>Object control level.</strong> The object control level for the
module at the time it was bound into this program. You can compare the object
control level of a module to the object control level of a listing to make sure
the listing matches the module.</p>
<p><strong>Offset to Licensed Internal Code options.</strong> The offset from
the beginning of the user space where the Licensed Internal Code options begin
for this bound module. This will be 0 if no Licensed Internal Code options were
used for this module.</p>
<p><strong>Optimization level.</strong> Optimization levels cause the
translator to produce machine code that reduces the amount of system resources
necessary to run the program. The more optimization, the more efficiently the
module runs on the system. Also, with more optimization you may not be able to
change or view variables that have been optimized. The possible values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>65535</em></td>
<td align="left" valign="top">The module is not restricted to a maximum
optimization level. It can be retranslated to any of the supported optimization
levels. 65535 is also known as *NOMAX.</td>
</tr>
<tr>
<td align="left" valign="top"><em>40</em></td>
<td align="left" valign="top">Maximum level of optimization. This level
includes all the optimizations performed at optimization level 30. In addition,
it includes optimization that disables call and instruction tracing. Thus,
tracing of modules created at this optimization level cannot be done.</td>
</tr>
<tr>
<td align="left" valign="top"><em>30</em></td>
<td align="left" valign="top">More optimization is performed in addition to
those performed at optimization level 20. Variables cannot be changed but can
be displayed while the program is being debugged. However, the displayed value
of the variable during debugging may not be its actual value. 30 is also known
as *FULL.</td>
</tr>
<tr>
<td align="left" valign="top"><em>20</em></td>
<td align="left" valign="top">Some optimization is performed on the generated
code. When the module optimized at this level is being debugged, the variables
can be displayed but not changed. This level improves the performance of the
module slightly over level 10. 20 is also known as *BASIC.</td>
</tr>
<tr>
<td align="left" valign="top"><em>10</em></td>
<td align="left" valign="top">No additional optimization is performed on the
generated code. Variables can be displayed and changed when the program is
being debugged. With no optimization of the code, this value provides the
lowest level of module performance. 10 is also known as *NONE.</td>
</tr>
</table>
<p><strong>Profiling data.</strong> The profiling data attribute for the module
bound into this program. Possible values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*NOCOL</em></td>
<td align="left" valign="top">The collection of profiling data is not enabled
and block-order profiling data is not applied to the module bound into this
program.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*COL</em></td>
<td align="left" valign="top">The collection of profiling data is enabled. Any
applied block-order profiling data has been removed for the module bound into
this program.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*APYBLKORD</em></td>
<td align="left" valign="top">Block-order profiling data is applied to the
module bound into this program. See the number of procedures block reordered
field for the current number of procedures in this module that are block
reordered.</td>
</tr>
</table>
<p><strong>Program library name.</strong> The name of the library containing
the program.</p>
<p><strong>Program library name specified.</strong> The program library name
that was passed to this API on the call in the qualified ILE program name and
library parameter.</p>
<p><strong>Program name.</strong> The name of the program.</p>
<p><strong>Program name specified.</strong> The program name that was passed to
this API on the call in the qualified ILE program name and library
parameter.</p>
<p><strong>PTF number.</strong> The program temporary fix (PTF) that resulted
in the creation of the module. This field is blank for user-created
modules.</p>
<p><strong>Relational database.</strong> The default relational database that
was specified on the SQL precompile. A nonblank value other than *LOCAL
specifies the name of the relational database to be resolved through the
relational database directory. The following special values can be
returned:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*LOCAL</em></td>
<td align="left" valign="top">The module can only access data on the local
system.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>Release module created for.</strong> The version, release, and
modification level of the operating system for which the module was created.
The field has a VvRrMm format, where:</p>
<table cellpadding="5">
<!-- cols="5 95" -->
<tr>
<td align="left" valign="top"><em>Vv</em></td>
<td align="left" valign="top">The character V is followed by a 1-character
version number.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Rr</em></td>
<td align="left" valign="top">The character R is followed by a 1-character
release level.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Mm</em></td>
<td align="left" valign="top">The character M is followed by a 1-character
modification level.</td>
</tr>
</table>
<p><strong>Release module created on.</strong> The version, release, and
modification level of the operating system on which the module was created. The
field has a VvRrMm format, where:</p>
<table cellpadding="5">
<!-- cols="5 95" -->
<tr>
<td align="left" valign="top"><em>Vv</em></td>
<td align="left" valign="top">The character V is followed by a 1-character
version number.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Rr</em></td>
<td align="left" valign="top">The character R is followed by a 1-character
release level.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Mm</em></td>
<td align="left" valign="top">The character M is followed by a 1-character
modification level.</td>
</tr>
</table>
<p><strong>Reserved.</strong> An ignored field.</p>
<p><strong>Size of data item export.</strong> The size, in bytes, of the data
item export.</p>
<p><strong>Size of this entry.</strong> The size, in bytes, of this entry.</p>
<p><strong>Sort sequence table library name.</strong> The name of the library
that is used to locate the sort sequence table. This information is blank if
the module does not contain any sort sequence information or a special value
was returned for the sort sequence table name. The following special values can
be returned:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*LIBL</em></td>
<td align="left" valign="top">The sort sequence table is found in the library
list when the ILE program runs this module.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*CURLIB</em></td>
<td align="left" valign="top">The sort sequence table is found in the current
library when the ILE program runs this module.</td>
</tr>
</table>
<p><strong>Sort sequence table name.</strong> The name of the sort sequence
table and the library used when the module was compiled. This does not apply to
SQL statements in the module. The following special values can be returned:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*HEX</em></td>
<td align="left" valign="top">No sort sequence is used.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*JOBRUN</em></td>
<td align="left" valign="top">The sort sequence is the sort sequence value
associated with the job at the time the ILE program runs this module.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*LANGIDSHR</em></td>
<td align="left" valign="top">The shared sort sequence for the language
identifier is used.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*LANGIDUNQ</em></td>
<td align="left" valign="top">The unique sort sequence for the language
identifier is used.</td>
</tr>
</table>
<table cellpadding="5">
<!-- cols="10 90" -->
<tr>
<td align="LEFT" valign="TOP"><strong>Note:</strong></td>
<td align="LEFT" valign="TOP">This sort sequence table does not apply to SQL
statements.</td>
</tr>
</table>
<p><strong>Source file library name.</strong> The name of the library that
contains the source file used to create the module. The field is blank if no
source file was used to create the module.</p>
<p><strong>Source file member name.</strong> The name of the member in the
source file. The field is blank if no source file was used to create the
module.</p>
<p><strong>Source file name.</strong> The name of the source file used to
create the module. The field is blank if no source file was used to create the
module.</p>
<p><strong>Source file updated date and time.</strong> The date and time the
member in the source file was last updated. The field is in the same format as
the module creation date and time field. The field is blank if no source file
was used to create the module.</p>
<p><strong>SQL language identifier.</strong> Returns the 3-character language
identifier used when the module was compiled. This information is blank if the
module does not contain any language identification information. The following
possible special value can also be returned:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*JOBRUN</em></td>
<td align="left" valign="top">The language identifier is the LANGID associated
with the job at the time the module is run.</td>
</tr>
</table>
<p><strong>SQL package library name.</strong> The name of the library the SQL
package is in.</p>
<p><strong>SQL package name.</strong> The name of the SQL package created on
the relational database specified on the RDB parameter of the command that
created this module. The possible values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*NONE</em></td>
<td align="left" valign="top">There is no default collection name.</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>SQL path.</strong> The list of libraries used during resolution of
functions and data types within SQL statements. The list is in the form of
repeating library names, each surrounded by double quotes and separated by
commas. Even though 3843 bytes are reserved, the path's length is determined by
the SQL path length entry.</p>
<p><strong>SQL path length.</strong> The length, in bytes, of the SQL path.</p>
<p><strong>SQL sort sequence table library name.</strong> The name of the
library that is used to locate the SQL sort sequence table. This information is
blank if the module does not contain any SQL sort sequence information or a
special value was returned for the SQL sort sequence table name. The following
special values can be returned:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*LIBL</em></td>
<td align="left" valign="top">The SQL sort sequence table is found by looking
in the library list.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*CURLIB</em></td>
<td align="left" valign="top">The SQL sort sequence table is found by looking
in the current library.</td>
</tr>
</table>
<p><strong>SQL sort sequence table name.</strong> The name of the table name
used when the module was compiled. This information is blank if the module does
not contain any SQL sort sequence information. The following special values can
be returned:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*HEX</em></td>
<td align="left" valign="top">No SQL sort sequence is used for the SQL
statements.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*JOBRUN</em></td>
<td align="left" valign="top">The SQL sort sequence is the SRTSEQ value
associated with the job at the time the SQL statements within the module are
run.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*LANGIDSHR</em></td>
<td align="left" valign="top">The shared SQL sort sequence for the language
identifier (LANGID) is used for the SQL statements.</td>
</tr>
<tr>
<td align="left" valign="top"><em>*LANGIDUNQ</em></td>
<td align="left" valign="top">The unique SQL sort sequence for the language
identifier (LANGID) is used for the SQL statements.</td>
</tr>
</table>
<p><strong>Storage model.</strong> Where the automatic and static storage for
this bound module is allocated at run time. The following values can be
returned:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top" nowrap>0 *SNGLVL</td>
<td align="left" valign="top">Automatic and static storage are allocated from
single-level storage.</td>
</tr>
<tr>
<td align="left" valign="top" nowrap>1 *TERASPACE</td>
<td align="left" valign="top">Automatic and static storage are allocated from
teraspace.</td>
</tr>
<tr>
<td align="left" valign="top" nowrap>2 *INHERIT</td>
<td align="left" valign="top">Automatic and static storage are allocated from
either single-level storage or teraspace, depending on the activation.</td>
</tr>
</table>
<p><strong>Teraspace storage enabled.</strong> The teraspace storage capability
for this bound module. Possible values are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top" nowrap><em>'00'X *NO</em></td>
<td align="left" valign="top">The module bound to this program is not teraspace
storage enabled.</td>
</tr>
<tr>
<td align="left" valign="top"><em>'80'X *YES</em></td>
<td align="left" valign="top">The module bound to this program is teraspace
storage enabled.</td>
</tr>
</table>
<p><strong>Time format.</strong> The format used when accessing time-result
columns through SQL. All output time fields are returned in this format. The
values returned are:</p>
<table cellpadding="5">
<!-- cols="15 85" -->
<tr>
<td align="left" valign="top"><em>*USA</em></td>
<td align="left" valign="top">USA format (hh:mm a.m. or p.m.).</td>
</tr>
<tr>
<td align="left" valign="top"><em>*ISO</em></td>
<td align="left" valign="top">International Standards Organization format
(hh.mm.ss).</td>
</tr>
<tr>
<td align="left" valign="top"><em>*EUR</em></td>
<td align="left" valign="top">European format (hh.mm.ss).</td>
</tr>
<tr>
<td align="left" valign="top"><em>*JIS</em></td>
<td align="left" valign="top">Japanese Industrial Standard Christian Era
(hh.mm.ss).</td>
</tr>
<tr>
<td align="left" valign="top"><em>*HMS</em></td>
<td align="left" valign="top">Hours/minutes/seconds format (hh:mm:ss).</td>
</tr>
<tr>
<td align="left" valign="top"><em>Blank</em></td>
<td align="left" valign="top">The module does not contain SQL statements.</td>
</tr>
</table>
<p><strong>Time separator.</strong> The separator used when accessing
time-result columns. This information is blank if the module does not contain
SQL statements; however, the number of SQL statements field should be checked
to determine if the module contains SQL statements. This is because a blank may
be specified as a separator value.</p>
<p><strong>User-modified.</strong> Whether the module was changed by the user
at bind time. The possible values are:</p>
<table cellpadding="5">
<!-- cols="5 95" -->
<tr>
<td align="left" valign="top"><em>0</em></td>
<td align="left" valign="top">The user did not change the module.</td>
</tr>
<tr>
<td align="left" valign="top"><em>1</em></td>
<td align="left" valign="top">The user changed the module.</td>
</tr>
</table>
<p><strong>User space library name specified.</strong> The user space library
name that was passed to this API on the call in the qualified user space name
parameter.</p>
<p><strong>User space library name used.</strong> The name of the library that
contains the user space that receives the ILE program information
requested.</p>
<p><strong>User space name specified.</strong> The user space name that was
passed to this API on the call in the qualified user space name parameter.</p>
<p><strong>User space name used.</strong> The name of the user space that
receives the ILE program information requested.
</p>
<br>
<h3>Error Messages</h3>
<table width="100%" cellpadding="5">
<!-- cols="15 85" -->
<tr>
<th align="left" valign="top">Message ID</th>
<th align="left" valign="top">Error Message Text</th>
</tr>
<tr>
<td width="15%" valign="top">CPF24B4 E</td>
<td width="85%" valign="top">Severe error while addressing parameter list.</td>
</tr>
<tr>
<td align="left" valign="top">CPF3C20 E</td>
<td align="left" valign="top">Error found by program &amp;1.</td>
</tr>
<tr>
<td align="left" valign="top">CPF3C21 E</td>
<td align="left" valign="top">Format name &amp;1 is not valid.</td>
</tr>
<tr>
<td align="left" valign="top">CPF3C90 E</td>
<td align="left" valign="top">Literal value cannot be changed.</td>
</tr>
<tr>
<td align="left" valign="top">CPF3CAA E</td>
<td align="left" valign="top">List is too large for user space &amp;1.</td>
</tr>
<tr>
<td align="left" valign="top">CPF3CF1 E</td>
<td align="left" valign="top">Error code parameter not valid.</td>
</tr>
<tr>
<td align="left" valign="top">CPF5CF5 E</td>
<td align="left" valign="top">&amp;1 in library &amp;2 not bound program.</td>
</tr>
<tr>
<td align="left" valign="top">CPF5CF6 E</td>
<td align="left" valign="top">Program name &amp;1 not valid special value.</td>
</tr>
<tr>
<td align="left" valign="top">CPF811A E</td>
<td align="left" valign="top">User space &amp;4 in &amp;9 damaged.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9570 E</td>
<td align="left" valign="top">Error occurred creating or accessing debug
data.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9801 E</td>
<td align="left" valign="top">Object &amp;2 in library &amp;3 not found.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9802 E</td>
<td align="left" valign="top">Not authorized to object &amp;2 in &amp;3.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9803 E</td>
<td align="left" valign="top">Cannot allocate object &amp;2 in library
&amp;3.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9804 E</td>
<td align="left" valign="top">Object &amp;2 in library &amp;3 damaged.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9806 E</td>
<td align="left" valign="top">Cannot perform function for object &amp;2 in
library &amp;3.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9807 E</td>
<td align="left" valign="top">One or more libraries in library list
deleted.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9808 E</td>
<td align="left" valign="top">Cannot allocate one or more libraries on library
list.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9810 E</td>
<td align="left" valign="top">Library &amp;1 not found.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9811 E</td>
<td align="left" valign="top">Program &amp;1 in library &amp;2 not found.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9820 E</td>
<td align="left" valign="top">Not authorized to use library &amp;1.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9821 E</td>
<td align="left" valign="top">Not authorized to program &amp;1 in library
&amp;2.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9830 E</td>
<td align="left" valign="top">Cannot assign library &amp;1.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9838 E</td>
<td align="left" valign="top">User profile storage limit exceeded.</td>
</tr>
<tr>
<td align="left" valign="top">CPF9872 E</td>
<td align="left" valign="top">Program or service program &amp;1 in library
&amp;2 ended. Reason code &amp;3.</td>
</tr>
</table>
<br>
<hr>
API introduced: V2R3
<hr>
<center>
<table cellpadding="2" cellspacing="2">
<tr align="center">
<td valign="middle" align="center"><a href="#Top_Of_Page">Top</a> | <a href=
"pgm1.htm">Program and CL Command APIs</a> | <a href="aplist.htm">APIs by
category</a></td>
</tr>
</table>
</center>
</body>
</html>
Reference in New Issue View Git Blame Copy Permalink