Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\doc\ohj\platform_extensions015.htm

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\doc\ohj\platform_extensions015.htm

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja">
<script src="./callback.js" type="text/javascript"></script>
<noscript>??????????????avaScript???????????????????????????????????????????????JavaScript??????????</noscript>
</head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Script-Type" content="text/javascript" />

<meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" />
<meta name="date" content="2009-06-04T0:46:17Z" />
<meta name="robots" content="noarchive" />
<meta name="doctitle" content="Implementing SQL-Based CMI Import for DB2 UDB" />
<meta name="relnum" content="11g Release 2 (11.2)" />
<meta name="partnum" content="E10582-01" />
<link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" />
<link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" />
<link rel="contents" href="toc.htm" title="Contents" type="text/html" />
<link rel="prev" href="platform_extensions014.htm" title="Previous" type="text/html" />
<link rel="next" href="platform_extensions016.htm" title="Next" type="text/html" />
<title>DB2 UDB??????SQL??????CMI????????????</title>
</head>
<body>
<div class="zz-skip-header"><a href="#BEGIN">??????????????</a></div>
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<col width="86%" />
<col width="*" />
<tr valign="bottom">
<td align="left"></td>
<td align="center"><a href="platform_extensions014.htm"> <img src="./dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a>&nbsp;</td>
<td align="center"><a href="platform_extensions016.htm"> <img src="./dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</span></a></td>
</tr>
</table>
<div class="sect2"><a id="sthref396" name="sthref396"></a>
<h1>DB2 UDB??????SQL??????CMI????????????</h1>
<a name="BEGIN" id="BEGIN"></a>
<p>SQL????????MI??????????B2 UDB??QL?????????????????????????????????????????B2??????????????????????????????????????????°?????????????????QL???????????????????????????????????????????????????????????????????????</p>
<p>CMI?°??????????????????????????????????????MI DEFINITION??????????????????????<a href="#CIHBJFCB">???: IBM DB2 UDB???????????????????</a>?????B2 UDB???????????????????????????????????????????????????????????????????????????????????????????????????????????????</p>
<div class="example"><a id="CIHBJFCB" name="CIHBJFCB"></a>
<p class="titleinexample">IBM DB2 UDB?????????????????</p>
<pre xml:space="preserve" class="oac_no_warn">
set platformname IBM_DB2_UDB
set platformdisplay "IBM DB2 CMI Api"
 
puts "Creating Platform $platformdisplay"
 
OMBCREATE PLATFORM '$platformname' SET PROPERTIES (BUSINESS_NAME) VALUES ('$platformdisplay')
OMBALTER PLATFORM '$platformname' SET PROPERTIES (DRIVER_CLASS,URI_TEMPLATE) VALUES ('com.ibm.db2.jcc.DB2Driver','jdbc:db2://Host:Port/Database Name')
OMBALTER PLATFORM '$platformname' SET PROPERTIES (LOCAL_OBJECT_MASK) VALUES ('%SCHEMA.%OBJECT')
OMBALTER PLATFORM '$platformname' SET PROPERTIES (DATE_MASK) VALUES ('TIMESTAMP')
OMBALTER PLATFORM '$platformname' SET PROPERTIES (DDLNULL) VALUES ('null')
OMBALTER PLATFORM '$platformname' SET PROPERTIES (NUMERIC_MASK) VALUES ('NUMERIC(%L,%P)')
OMBALTER PLATFORM '$platformname' SET PROPERTIES (VARCHAR_MASK) VALUES ('VARCHAR(%L)')
OMBALTER PLATFORM '$platformname' SET PROPERTIES (LOCAL_OBJECT_MASK) VALUES ('%SCHEMA.%OBJECT')
OMBALTER PLATFORM '$platformname' SET PROPERTIES (DEFAULT_MAX_NAME_LEN) VALUES ('30')
OMBALTER PLATFORM '$platformname' SET PROPERTIES (REMOTE_OBJECT_MASK) VALUES ('%SCHEMA.%OBJECT')
</pre></div>

<p>?°???MI????????????????????????????</p>
<pre xml:space="preserve" class="oac_no_warn">
OMBCREATE CMI_DEFINITION 'DB2_IMPORT_SQL' USING DEFINITION_FILE 'c:\\platformdef2_miv.xml'
OMBALTER CMI_DEFINITION 'DB2_IMPORT_SQL' SET PROPERTIES (MIV_TYPE) VALUES ('Databases')
OMBALTER PLATFORM '$platformname' SET REF CMI_DEFINITION 'DB2_IMPORT_SQL'
</pre>
<p><code>platformdef2_miv.xml</code>???????????QL????????????????????????????????????????????????????????????????<a href="#CIHIJABJ">???: CMI???????????</a>?????MI??????????????????????????</p>
<div class="example"><a id="CIHIJABJ" name="CIHIJABJ"></a>
<p class="titleinexample">CMI?????????</p>
<pre xml:space="preserve" class="oac_no_warn">
&lt;?xml version="1.0"?&gt;
&lt;miv&gt;
 
&lt;miv_tables type="SQLStatement" default="true"&gt;
        SELECT rtrim(tabname) table_name 
        FROM syscat.tables  
        WHERE tabschema = &lt;Parameter name="owner"/&gt; 
                AND type = 'T'   
                AND status = 'N'   
        ORDER BY table_name
&lt;/miv_tables&gt;
 
 
&lt;miv_columns type="SQLStatement" default="true"&gt;
        SELECT rtrim(col.tabname) entity_name, 
               col.colno position, 
               rtrim(col.colname), 
               col.typename, 
               col.length, 
               col.length, 
               col.scale, 
               col.remarks, 
               col.nulls,
               '' datatypeowner,
               col.default,
               CHAR(col.codepage) charset,
               1 bytes_per_char,
               'N' use_char_semantics
        FROM syscat.columns col
        WHERE col.tabschema = &lt;Parameter name="owner"/&gt;
&lt;/miv_columns&gt;
 
&lt;miv_capabilities type="ResultSet"&gt;
        &lt;table_supported&gt;true&lt;/table_supported&gt;
        &lt;view_supported&gt;false&lt;/view_supported&gt;
        &lt;sequence_supported&gt;false&lt;/sequence_supported&gt;
        &lt;table_name_filter_supported&gt;true&lt;/table_name_filter_supported&gt;
        &lt;view_name_filter_supported&gt;false&lt;/view_name_filter_supported&gt;
        &lt;sequence_name_filter_supported&gt;false&lt;/sequence_name_filter_supported&gt;
        &lt;business_area_supported&gt;false&lt;/business_area_supported&gt;      
        &lt;business_area_table_supported&gt;false&lt;/business_area_table_supported&gt;    
        &lt;business_area_view_supported&gt;false&lt;/business_area_view_supported&gt;      
        &lt;business_area_sequence_supported&gt;false&lt;/business_area_sequence_supported&gt;      
        &lt;application_owner_supported&gt;true&lt;/application_owner_supported&gt;
        &lt;table_fklevel_supported&gt;false&lt;/table_fklevel_supported&gt;
        &lt;reimport_supported&gt;true&lt;/reimport_supported&gt;
        &lt;data_object_at_leaf_levels&gt;false&lt;/data_object_at_leaf_levels&gt;
        &lt;multiple_tree_supported&gt;false&lt;/multiple_tree_supported&gt;
&lt;/miv_capabilities&gt;
 
&lt;/miv&gt;
</pre></div>

<p>????????????????????????????????????????????????????IV??????????ML???????????SD????°???????????????????????????????????</p>
<p>??????????????????????????????????????????????????????????????????????????????DB2UDB?????????????????????????????????????????B2???????????????????????????°??????????????????????????°???????????<a href="wbdod90612.htm#CACCBIBI">??B2??DBC???????????</a>????????????????</p>
<p>???????QL????????????????????????????????????????????????????????????????????QL??????CMI?°??????????????????????????°???????????????????????</p>
</div>

<div class="footer">
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td align="left" width="86%"><a href="topicid:help_legalnotices_html"> <span class="copyrightlogo">Copyright&nbsp;(C)&nbsp;2009,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;All&nbsp;rights&nbsp;reserved.</span></a>
</td>
</tr>
</table>
</div>
</body>
</html>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de