<HTML><HEAD>
 <title>Index: ASN.IBMSNAP_PRUNCNTLX1</title>
<LINK REL="stylesheet" TYPE="text/css" HREF="./../../style/style.css">
<SCRIPT SRC="./../../style/vs70.js"></SCRIPT>
<SCRIPT SRC="./../../style/vs70link.js"></SCRIPT>
</HEAD><BODY id='bodyID'>
<div id="nsbanner">
<div id="bannerrow1">
<P CLASS="page-header">&nbsp;
<img src="./../../style/index.ico">Index: ASN.IBMSNAP_PRUNCNTLX1</P></div></div>
<DIV id="nstext" valign="bottom">
<p class='page-sub-header'><a name="_Toc685883755" > Properties</a></p>
<table  border=1 cellpadding=1 cellspacing=1 >
<tr>
  <td valign=top nowrap class='td_header_min'>Name:</td>
  <td>IBMSNAP_PRUNCNTLX1&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Schema:</td>
  <td><a href="./../../schema/main/823519054.html">ASN</a>&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Table schema:</td>
  <td><a href="./../../schema/main/823519054.html">ASN</a>&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Table:</td>
  <td><a href="./../../table/main/1657074713.html">IBMSNAP_PRUNCNTL</a>&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Unique rule:</td>
  <td>UNIQUE&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Type:</td>
  <td>REGULAR&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Create time:</td>
  <td>01.07.2006&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Tablespace:</td>
  <td><a href="./../../tablespace/main/197214335.html">TSASNCA</a>&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Description:</td>
  <td>&nbsp;</td>
</tr>
 </table>
<p class='page-sub-header'><a name="_Toc510030008" > Columns</a></p>
<table border=1 class='table_list' >
<tr class='tr_header' width='1'>
<td valign=top nowrap><b></b></td>
<td valign=top nowrap><b>Colname</b></td>
<td valign=top nowrap><b>Order</b></td>
</tr>
<tr>
<td valign="top" class="td_min">
<img src="./../../style/column.ico">&nbsp;</td>
<td valign=top>
MAP_ID&nbsp;</td>
<td valign=top>
ASCENDING&nbsp;</td>
</tr>
    </table>
<span class="objects_number">Total: 1 column(s)</span>
<p class='page-sub-header'><a name="_Toc268357481" > Autherisations</a></p>
<table border=1 class='table_list' >
<tr class='tr_header' width='1'>
<td valign=top nowrap><b></b></td>
<td valign=top nowrap><b>Grantor</b></td>
<td valign=top nowrap><b>Grantee</b></td>
<td valign=top nowrap><b>Authorities</b></td>
</tr>
<tr>
<td valign="top" class="td_min">
<img src="./../../style/permission.ico">&nbsp;</td>
<td valign=top>
SYSIBM&nbsp;</td>
<td valign=top>
<a href="./../../user/main/63392434.html">USER</a>&nbsp;</td>
<td valign=top>
CONTROL=HELD&nbsp;</td>
</tr>
    </table>
<span class="objects_number">Total: 1 autherisation(s)</span>
<p class='page-sub-header'><a name="_Toc685883755" > SQL</a></p>
<p class="pre">
<span class=keyword>CREATE</span> <span class=keyword>UNIQUE</span> <span class=keyword>INDEX</span> <span class=string>"ASN&nbsp;&nbsp;&nbsp;&nbsp; "</span>.<span class=string>"IBMSNAP_PRUNCNTLX1"</span> <span class=keyword>ON</span> <span class=string>"ASN&nbsp;&nbsp;&nbsp;&nbsp; "</span>.<span class=string>"IBMSNAP_PRUNCNTL"</span> <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(<span class=string>"MAP_ID"</span> <span class=keyword>ASC</span>);<br>
</p>
<p class="page-sub-header">See Also</p>
<a class="see_also_href" href="./../../database_indexes_list/main/1379905910.html">List of indexes</a><br>
<br>
<br>
</div>
</body>
</html>