initial-contribution/IBM/evalGuides/DataToolsEval.html - www.eclipse.org/webtools - Git at Google

 <html xmlns:v="urn:schemas-microsoft-com:vml"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:w="urn:schemas-microsoft-com:office:word"
 xmlns="http://www.w3.org/TR/REC-html40">

 <head>
 <meta http-equiv=Content-Type content="text/html; charset=us-ascii">
 <meta name=ProgId content=Word.Document>
 <meta name=Generator content="Microsoft Word 10">
 <meta name=Originator content="Microsoft Word 10">
 <link rel=File-List href="DataToolsEval_files/filelist.xml">
 <link rel=Edit-Time-Data href="DataToolsEval_files/editdata.mso">
 <!--[if !mso]>
 <style>
 v\:* {behavior:url(#default#VML);}
 o\:* {behavior:url(#default#VML);}
 w\:* {behavior:url(#default#VML);}
 .shape {behavior:url(#default#VML);}
 </style>
 <![endif]-->
 <title>Getting Started.html</title>
 <!--[if gte mso 9]><xml>
  <o:DocumentProperties>
   <o:Author>Der Ping Chou</o:Author>
   <o:LastAuthor>Der Ping Chou</o:LastAuthor>
   <o:Revision>2</o:Revision>
   <o:TotalTime>348</o:TotalTime>
   <o:Created>2004-07-13T00:46:00Z</o:Created>
   <o:LastSaved>2004-07-13T00:46:00Z</o:LastSaved>
   <o:Pages>1</o:Pages>
   <o:Words>634</o:Words>
   <o:Characters>3618</o:Characters>
   <o:Company>IBM</o:Company>
   <o:Lines>30</o:Lines>
   <o:Paragraphs>8</o:Paragraphs>
   <o:CharactersWithSpaces>4244</o:CharactersWithSpaces>
   <o:Version>10.2625</o:Version>
  </o:DocumentProperties>
 </xml><![endif]--><!--[if gte mso 9]><xml>
  <w:WordDocument>
   <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
  </w:WordDocument>
 </xml><![endif]-->
 <link rel=Stylesheet type="text/css" media=all href="../theme/Master.css">
 <style>
 <!--
  /* Style Definitions */
  p.MsoNormal, li.MsoNormal, div.MsoNormal
 	{mso-style-parent:"";
 	margin:0in;
 	margin-bottom:.0001pt;
 	mso-pagination:widow-orphan;
 	font-size:12.0pt;
 	font-family:"Times New Roman";
 	mso-fareast-font-family:"Times New Roman";}
 h1
 	{mso-margin-top-alt:auto;
 	margin-right:0in;
 	mso-margin-bottom-alt:auto;
 	margin-left:0in;
 	mso-pagination:widow-orphan;
 	mso-outline-level:1;
 	font-size:24.0pt;
 	font-family:"Times New Roman";
 	font-weight:bold;}
 h2
 	{mso-margin-top-alt:auto;
 	margin-right:0in;
 	mso-margin-bottom-alt:auto;
 	margin-left:0in;
 	mso-pagination:widow-orphan;
 	mso-outline-level:2;
 	font-size:18.0pt;
 	font-family:"Times New Roman";
 	font-weight:bold;}
 h3
 	{mso-margin-top-alt:auto;
 	margin-right:0in;
 	mso-margin-bottom-alt:auto;
 	margin-left:0in;
 	mso-pagination:widow-orphan;
 	mso-outline-level:3;
 	font-size:13.5pt;
 	font-family:"Times New Roman";
 	font-weight:bold;}
 p
 	{mso-margin-top-alt:auto;
 	margin-right:0in;
 	mso-margin-bottom-alt:auto;
 	margin-left:0in;
 	mso-pagination:widow-orphan;
 	font-size:12.0pt;
 	font-family:"Times New Roman";
 	mso-fareast-font-family:"Times New Roman";}
 @page Section1
 	{size:8.5in 11.0in;
 	margin:1.0in 1.25in 1.0in 1.25in;
 	mso-header-margin:.5in;
 	mso-footer-margin:.5in;
 	mso-paper-source:0;}
 div.Section1
 	{page:Section1;}
  /* List Definitions */
  @list l0
 	{mso-list-id:216820099;
 	mso-list-template-ids:1277307288;}
 @list l0:level1
 	{mso-level-start-at:4;
 	mso-level-tab-stop:.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l1
 	{mso-list-id:347800264;
 	mso-list-template-ids:-978969588;}
 @list l1:level1
 	{mso-level-start-at:2;
 	mso-level-tab-stop:.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l2
 	{mso-list-id:628972938;
 	mso-list-template-ids:-1929337976;}
 @list l3
 	{mso-list-id:925764890;
 	mso-list-template-ids:-1763424008;}
 @list l3:level1
 	{mso-level-start-at:3;
 	mso-level-tab-stop:.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l4
 	{mso-list-id:926772034;
 	mso-list-template-ids:35409304;}
 @list l4:level1
 	{mso-level-number-format:bullet;
 	mso-level-text:\F0B7;
 	mso-level-tab-stop:.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;
 	mso-ansi-font-size:10.0pt;
 	font-family:Symbol;}
 @list l4:level2
 	{mso-level-tab-stop:1.0in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l4:level3
 	{mso-level-tab-stop:1.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l4:level4
 	{mso-level-tab-stop:2.0in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l4:level5
 	{mso-level-tab-stop:2.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l4:level6
 	{mso-level-tab-stop:3.0in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l4:level7
 	{mso-level-tab-stop:3.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l4:level8
 	{mso-level-tab-stop:4.0in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l4:level9
 	{mso-level-tab-stop:4.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l5
 	{mso-list-id:1310207450;
 	mso-list-template-ids:2115414768;}
 @list l5:level1
 	{mso-level-start-at:6;
 	mso-level-tab-stop:.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l6
 	{mso-list-id:1334600384;
 	mso-list-template-ids:1188730944;}
 @list l6:level1
 	{mso-level-tab-stop:.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l6:level2
 	{mso-level-tab-stop:1.0in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l6:level3
 	{mso-level-tab-stop:1.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l6:level4
 	{mso-level-tab-stop:2.0in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l6:level5
 	{mso-level-tab-stop:2.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l6:level6
 	{mso-level-tab-stop:3.0in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l6:level7
 	{mso-level-tab-stop:3.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l6:level8
 	{mso-level-tab-stop:4.0in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l6:level9
 	{mso-level-tab-stop:4.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 @list l7
 	{mso-list-id:1546019837;
 	mso-list-template-ids:1367504666;}
 @list l7:level1
 	{mso-level-number-format:bullet;
 	mso-level-text:\F0B7;
 	mso-level-tab-stop:.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;
 	mso-ansi-font-size:10.0pt;
 	font-family:Symbol;}
 @list l8
 	{mso-list-id:2048412170;
 	mso-list-template-ids:1579335996;}
 @list l8:level1
 	{mso-level-start-at:5;
 	mso-level-tab-stop:.5in;
 	mso-level-number-position:left;
 	text-indent:-.25in;}
 ol
 	{margin-bottom:0in;}
 ul
 	{margin-bottom:0in;}
 -->
 </style>
 <!--[if gte mso 10]>
 <style>
  /* Style Definitions */
  table.MsoNormalTable
 	{mso-style-name:"Table Normal";
 	mso-tstyle-rowband-size:0;
 	mso-tstyle-colband-size:0;
 	mso-style-noshow:yes;
 	mso-style-parent:"";
 	mso-padding-alt:0in 5.4pt 0in 5.4pt;
 	mso-para-margin:0in;
 	mso-para-margin-bottom:.0001pt;
 	mso-pagination:widow-orphan;
 	font-size:10.0pt;
 	font-family:"Times New Roman";}
 </style>
 <![endif]-->
 <meta http-equiv=Content-Style-Type content="text/css">
 <!--[if gte mso 9]><xml>
  <o:shapedefaults v:ext="edit" spidmax="2050"/>
 </xml><![endif]--><!--[if gte mso 9]><xml>
  <o:shapelayout v:ext="edit">
   <o:idmap v:ext="edit" data="1"/>
  </o:shapelayout></xml><![endif]-->
 </head>

 <body lang=EN-US style='tab-interval:.5in'>

 <div class=Section1>

 <h1>Data Tools Evaluation Guide</h1>

 <h2>1.0 Introduction</h2>

 <p>The Data Tools contribution offers features to allow you to work with a
 variety of databases.<br>
 <br>
 You can connect to the database, load and view database objects, sample the contents
 of tables, and execute SQL statements and commands.<br>
 <br>
 This information will get you started using these features.</p>

 <h2>2.0 Getting Started</h2>

 <p>Before using the Data Tools components, you will need to have access to a
 supported database and the information required to connect to it. </p>

 <h2>3.0 Quick Tour</h2>

 <p>The following sections give step-by-step instructions on how to use the Data
 Tools functions.</p>

 <h3>3.1 Opening the Data Views</h3>

 <p>The Data Tools provides two views: the Database Explorer view and the DB
 Output view. </p>

 <p>The Database Explorer view is where you will create connections, view your
 database objects and launch actions from those objects. The DB Output view is
 where query results and messages are displayed.<br>
 <br>
 To open the Database Explorer view, select Window-&gt;Show view-&gt;Other-&gt;Data-&gt;
 Database Explorer.<br>
 To open the DB Output view, select Window-&gt;Show view-&gt;Other-&gt;Data-&gt;
 DB Output view.<br>
 Rearrange the views as follows:<br style='mso-special-character:line-break'>
 <![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
 <![endif]></p>

 <p><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600"
  o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f"
  stroked="f">
  <v:stroke joinstyle="miter"/>
  <v:formulas>
   <v:f eqn="if lineDrawn pixelLineWidth 0"/>
   <v:f eqn="sum @0 1 0"/>
   <v:f eqn="sum 0 0 @1"/>
   <v:f eqn="prod @2 1 2"/>
   <v:f eqn="prod @3 21600 pixelWidth"/>
   <v:f eqn="prod @3 21600 pixelHeight"/>
   <v:f eqn="sum @0 0 1"/>
   <v:f eqn="prod @6 1 2"/>
   <v:f eqn="prod @7 21600 pixelWidth"/>
   <v:f eqn="sum @8 21600 0"/>
   <v:f eqn="prod @7 21600 pixelHeight"/>
   <v:f eqn="sum @10 21600 0"/>
  </v:formulas>
  <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
  <o:lock v:ext="edit" aspectratio="t"/>
 </v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:221.25pt;
  height:315pt'>
  <v:imagedata src="DataToolsEval_files/image001.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=295 height=420
 src="DataToolsEval_files/image002.jpg" v:shapes="_x0000_i1025"><![endif]></p>

 <h3>3.2 Connecting to a Database</h3>

 <p><span style='color:red'>{Can add Connection screencaps in this section}</span><br>
 You can connect to a variety of database systems using the Connection Wizard.
 Once connected, the database metadata is loaded, allowing you to view the
 schemas, tables, columns and their data types.<br>
 <br>
 For example, if you have DB2 UDB v8.1 installed and the SAMPLE database
 created, you can follow these steps to connect and load its database metadata:</p>

 <ol start=1 type=1>
  <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
      mso-list:l6 level1 lfo3;tab-stops:list .5in'>Launch the Connection Wizard<br>
      The Connection Wizard can be launched from the New Connection item in the
      context menu of the Database Explorer (right mouse click on Database
      Explorer View). </li>
 </ol>

 <p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
 margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1026" type="#_x0000_t75"
  style='width:491.25pt;height:136.5pt'>
  <v:imagedata src="DataToolsEval_files/image003.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=655 height=182
 src="DataToolsEval_files/image004.jpg" v:shapes="_x0000_i1026"><![endif]></p>

 <ol start=2 type=1>
  <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
      mso-list:l6 level1 lfo3;tab-stops:list .5in'>Establish a Connection to a
      Database Page<br>
      Ensure the &quot;Choose a database manager and JDBC driver&quot; radio
      button is selected and press Next. </li>
 </ol>

 <p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
 margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1027" type="#_x0000_t75"
  style='width:479.25pt;height:436.5pt'>
  <v:imagedata src="DataToolsEval_files/image005.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=639 height=582
 src="DataToolsEval_files/image006.jpg" v:shapes="_x0000_i1027"><![endif]></p>

 <ol start=3 type=1>
  <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
      mso-list:l6 level1 lfo3;tab-stops:list .5in'>Specify Connection Parameters
      Page<br>
      In the Select a Database Manager tree, expand the DB2 Universal Database
      node and select V8.1. In the Alias field, type &quot;SAMPLE&quot;. Press
      the Test Connection button. After a successful connection, press Next.</li>
 </ol>

 <p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
 margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1028" type="#_x0000_t75"
  style='width:479.25pt;height:436.5pt'>
  <v:imagedata src="DataToolsEval_files/image007.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=639 height=582
 src="DataToolsEval_files/image008.jpg" v:shapes="_x0000_i1028"><![endif]></p>

 <ol start=4 type=1>
  <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
      mso-list:l6 level1 lfo3;tab-stops:list .5in'>Limit the Objects Retrieved
      from the Database catalog loading<br>
      On this page you can filter the database objects that are retrieved. To
      add a filter which excludes tables that start with &quot;C&quot;, press
      the Add button to the right of the Table and Routine filter grid. In the
      Add Object Filter dialog, select Table for the Target field, select NOT LIKE
      for the Predicate field and type &quot;C%&quot; (without the quotes) in
      the Predicate field, then press OK. Back in the main wizard page, click
      Next.<br>
      Note: If you are connecting to a database with a large number of database
      objects, it is important to filter appropriately to reduce the number of
      tables returned. </li>
 </ol>

 <p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
 margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1029" type="#_x0000_t75"
  style='width:353.25pt;height:135pt'>
  <v:imagedata src="DataToolsEval_files/image009.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=471 height=180
 src="DataToolsEval_files/image010.jpg" v:shapes="_x0000_i1029"><![endif]></p>

 <p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
 margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1030" type="#_x0000_t75"
  style='width:479.25pt;height:436.5pt'>
  <v:imagedata src="DataToolsEval_files/image011.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=639 height=582
 src="DataToolsEval_files/image012.jpg" v:shapes="_x0000_i1030"><![endif]></p>

 <ol start=5 type=1>
  <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
      mso-list:l6 level1 lfo3;tab-stops:list .5in'>Specify Connection Parameters
      Page <span style='color:red'>{Q: same name as a previous page? or is it
      because I'm on an older driver?}</span> <br>
      Press Next. </li>
 </ol>

 <p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
 margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1031" type="#_x0000_t75"
  style='width:479.25pt;height:436.5pt'>
  <v:imagedata src="DataToolsEval_files/image013.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=639 height=582
 src="DataToolsEval_files/image014.jpg" v:shapes="_x0000_i1031"><![endif]></p>

 <ol start=6 type=1>
  <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
      mso-list:l6 level1 lfo3;tab-stops:list .5in'>Summary Page<br>
      Review your settings and press Finish. The database metadata will load. </li>
 </ol>

 <p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
 margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1032" type="#_x0000_t75"
  style='width:479.25pt;height:436.5pt'>
  <v:imagedata src="DataToolsEval_files/image015.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=639 height=582
 src="DataToolsEval_files/image016.jpg" v:shapes="_x0000_i1032"><![endif]></p>

 <p>In the Database Explorer, you will see a tree structure representing your
 connection and the database objects retrieved. <br>
 <br>
 <!--[if gte vml 1]><v:shape id="_x0000_i1033" type="#_x0000_t75" style='width:483.75pt;
  height:318pt'>
  <v:imagedata src="DataToolsEval_files/image017.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=645 height=424
 src="DataToolsEval_files/image018.jpg" v:shapes="_x0000_i1033"><![endif]><span
 style='mso-spacerun:yes'>&nbsp;</span></p>

 <h3>3.3 Sampling Contents of a Table</h3>

 <p>You can sample the contents of a table and see its data appear in the DB
 Output view.</p>

 <p>To sample the data from a table, expand the connection, database, schema and
 Tables nodes in the Database Explorer. Using a table's context menu, select
 Sample Contents. This displays the table's data in the Results tab of the DB
 Output view.<br>
 <br>
 <!--[if gte vml 1]><v:shape id="_x0000_i1034" type="#_x0000_t75" style='width:488.25pt;
  height:320.25pt'>
  <v:imagedata src="DataToolsEval_files/image019.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=651 height=427
 src="DataToolsEval_files/image020.jpg" v:shapes="_x0000_i1034"><![endif]></p>

 <p><span style='color:red'><!--[if gte vml 1]><v:shape id="_x0000_i1035"
  type="#_x0000_t75" style='width:489.75pt;height:318pt'>
  <v:imagedata src="DataToolsEval_files/image021.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=653 height=424
 src="DataToolsEval_files/image022.jpg" v:shapes="_x0000_i1035"><![endif]><span
 style='mso-spacerun:yes'>&nbsp;</span></span></p>

 <h3>3.4 Executing SQL Statements and Commands</h3>

 <p>The Data Tools offer a way to execute SQL statements and commands through
 its SQL Scrapbook editor. <br>
 <br>
 To invoke the SQL Scrapbook, select Open SQL Scrapbook from the connection node
 context menu in the Database Explorer. The SQL Scrapbook opens in the editor
 area. Type a SQL statement or command then execute it by selecting Execute from
 the SQL menu or by selecting the Execute icon in the toolbar. <br>
 <br>
 <!--[if gte vml 1]><v:shape id="_x0000_i1036" type="#_x0000_t75" style='width:489.75pt;
  height:159.75pt'>
  <v:imagedata src="DataToolsEval_files/image023.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=653 height=213
 src="DataToolsEval_files/image024.jpg" v:shapes="_x0000_i1036"><![endif]><span
 style='color:red'><br style='mso-special-character:line-break'>
 <![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
 <![endif]><o:p></o:p></span></p>

 <p><!--[if gte vml 1]><v:shape id="_x0000_i1037" type="#_x0000_t75" style='width:489.75pt;
  height:479.25pt'>
  <v:imagedata src="DataToolsEval_files/image025.png" o:title=""/>
 </v:shape><![endif]--><![if !vml]><img width=653 height=639
 src="DataToolsEval_files/image026.jpg" v:shapes="_x0000_i1037"><![endif]></p>

 <h2>4.0 Known Problems</h2>

 <ul type=disc>
  <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
      mso-list:l4 level1 lfo11;tab-stops:list .5in'>CLOB and BLOB data types do
      not display well in the DB Output view.</li>
 </ul>

 <h2>5.0 Provide Feedback to Us</h2>

 <P>We encourage development/design feed back on the <A
 	href="https://dev.eclipse.org/mailman/listinfo/wtp-dev">wtp-dev</A> mailing list. You can subscribe to the list via <A
 	href="https://dev.eclipse.org/mailman/listinfo/wtp-dev">this link</A>.<BR>
 <BR>
 For usage questions,  discussion of bugs, and strange behaviour please post to the eclipse.webtools newsgroup. Information on the Web Tools Platform newsgroup can be found <A
 	href="http://www.eclipse.org/newsgroups/index.html">here</A>.</P>


 </div>

 </body>

 </html>
	<html xmlns:v="urn:schemas-microsoft-com:vml"
	xmlns:o="urn:schemas-microsoft-com:office:office"
	xmlns:w="urn:schemas-microsoft-com:office:word"
	xmlns="http://www.w3.org/TR/REC-html40">

	<head>
	<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
	<meta name=ProgId content=Word.Document>
	<meta name=Generator content="Microsoft Word 10">
	<meta name=Originator content="Microsoft Word 10">
	<link rel=File-List href="DataToolsEval_files/filelist.xml">
	<link rel=Edit-Time-Data href="DataToolsEval_files/editdata.mso">
	<!--[if !mso]>
	<style>
	v\:* {behavior:url(#default#VML);}
	o\:* {behavior:url(#default#VML);}
	w\:* {behavior:url(#default#VML);}
	.shape {behavior:url(#default#VML);}
	</style>
	<![endif]-->
	<title>Getting Started.html</title>
	<!--[if gte mso 9]><xml>
	<o:DocumentProperties>
	<o:Author>Der Ping Chou</o:Author>
	<o:LastAuthor>Der Ping Chou</o:LastAuthor>
	<o:Revision>2</o:Revision>
	<o:TotalTime>348</o:TotalTime>
	<o:Created>2004-07-13T00:46:00Z</o:Created>
	<o:LastSaved>2004-07-13T00:46:00Z</o:LastSaved>
	<o:Pages>1</o:Pages>
	<o:Words>634</o:Words>
	<o:Characters>3618</o:Characters>
	<o:Company>IBM</o:Company>
	<o:Lines>30</o:Lines>
	<o:Paragraphs>8</o:Paragraphs>
	<o:CharactersWithSpaces>4244</o:CharactersWithSpaces>
	<o:Version>10.2625</o:Version>
	</o:DocumentProperties>
	</xml><![endif]--><!--[if gte mso 9]><xml>
	<w:WordDocument>
	<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
	</w:WordDocument>
	</xml><![endif]-->
	<link rel=Stylesheet type="text/css" media=all href="../theme/Master.css">
	<style>
	<!--
	/* Style Definitions */
	p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
	h1
	{mso-margin-top-alt:auto;
	margin-right:0in;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	mso-pagination:widow-orphan;
	mso-outline-level:1;
	font-size:24.0pt;
	font-family:"Times New Roman";
	font-weight:bold;}
	h2
	{mso-margin-top-alt:auto;
	margin-right:0in;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	mso-pagination:widow-orphan;
	mso-outline-level:2;
	font-size:18.0pt;
	font-family:"Times New Roman";
	font-weight:bold;}
	h3
	{mso-margin-top-alt:auto;
	margin-right:0in;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	mso-pagination:widow-orphan;
	mso-outline-level:3;
	font-size:13.5pt;
	font-family:"Times New Roman";
	font-weight:bold;}
	p
	{mso-margin-top-alt:auto;
	margin-right:0in;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
	@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
	div.Section1
	{page:Section1;}
	/* List Definitions */
	@list l0
	{mso-list-id:216820099;
	mso-list-template-ids:1277307288;}
	@list l0:level1
	{mso-level-start-at:4;
	mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l1
	{mso-list-id:347800264;
	mso-list-template-ids:-978969588;}
	@list l1:level1
	{mso-level-start-at:2;
	mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l2
	{mso-list-id:628972938;
	mso-list-template-ids:-1929337976;}
	@list l3
	{mso-list-id:925764890;
	mso-list-template-ids:-1763424008;}
	@list l3:level1
	{mso-level-start-at:3;
	mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l4
	{mso-list-id:926772034;
	mso-list-template-ids:35409304;}
	@list l4:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;
	mso-ansi-font-size:10.0pt;
	font-family:Symbol;}
	@list l4:level2
	{mso-level-tab-stop:1.0in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l4:level3
	{mso-level-tab-stop:1.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l4:level4
	{mso-level-tab-stop:2.0in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l4:level5
	{mso-level-tab-stop:2.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l4:level6
	{mso-level-tab-stop:3.0in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l4:level7
	{mso-level-tab-stop:3.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l4:level8
	{mso-level-tab-stop:4.0in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l4:level9
	{mso-level-tab-stop:4.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l5
	{mso-list-id:1310207450;
	mso-list-template-ids:2115414768;}
	@list l5:level1
	{mso-level-start-at:6;
	mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l6
	{mso-list-id:1334600384;
	mso-list-template-ids:1188730944;}
	@list l6:level1
	{mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l6:level2
	{mso-level-tab-stop:1.0in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l6:level3
	{mso-level-tab-stop:1.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l6:level4
	{mso-level-tab-stop:2.0in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l6:level5
	{mso-level-tab-stop:2.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l6:level6
	{mso-level-tab-stop:3.0in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l6:level7
	{mso-level-tab-stop:3.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l6:level8
	{mso-level-tab-stop:4.0in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l6:level9
	{mso-level-tab-stop:4.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	@list l7
	{mso-list-id:1546019837;
	mso-list-template-ids:1367504666;}
	@list l7:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;
	mso-ansi-font-size:10.0pt;
	font-family:Symbol;}
	@list l8
	{mso-list-id:2048412170;
	mso-list-template-ids:1579335996;}
	@list l8:level1
	{mso-level-start-at:5;
	mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
	ol
	{margin-bottom:0in;}
	ul
	{margin-bottom:0in;}
	-->
	</style>
	<!--[if gte mso 10]>
	<style>
	/* Style Definitions */
	table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";}
	</style>
	<![endif]-->
	<meta http-equiv=Content-Style-Type content="text/css">
	<!--[if gte mso 9]><xml>
	<o:shapedefaults v:ext="edit" spidmax="2050"/>
	</xml><![endif]--><!--[if gte mso 9]><xml>
	<o:shapelayout v:ext="edit">
	<o:idmap v:ext="edit" data="1"/>
	</o:shapelayout></xml><![endif]-->
	</head>

	<body lang=EN-US style='tab-interval:.5in'>

	<div class=Section1>

	<h1>Data Tools Evaluation Guide</h1>

	<h2>1.0 Introduction</h2>

	<p>The Data Tools contribution offers features to allow you to work with a
	variety of databases.<br>
	<br>
	You can connect to the database, load and view database objects, sample the contents
	of tables, and execute SQL statements and commands.<br>
	<br>
	This information will get you started using these features.</p>

	<h2>2.0 Getting Started</h2>

	<p>Before using the Data Tools components, you will need to have access to a
	supported database and the information required to connect to it. </p>

	<h2>3.0 Quick Tour</h2>

	<p>The following sections give step-by-step instructions on how to use the Data
	Tools functions.</p>

	<h3>3.1 Opening the Data Views</h3>

	<p>The Data Tools provides two views: the Database Explorer view and the DB
	Output view. </p>

	<p>The Database Explorer view is where you will create connections, view your
	database objects and launch actions from those objects. The DB Output view is
	where query results and messages are displayed.<br>
	<br>
	To open the Database Explorer view, select Window->Show view->Other->Data->
	Database Explorer.<br>
	To open the DB Output view, select Window->Show view->Other->Data->
	DB Output view.<br>
	Rearrange the views as follows:<br style='mso-special-character:line-break'>
	<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
	<![endif]></p>

	<p><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600"
	o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f"
	stroked="f">
	<v:stroke joinstyle="miter"/>
	<v:formulas>
	<v:f eqn="if lineDrawn pixelLineWidth 0"/>
	<v:f eqn="sum @0 1 0"/>
	<v:f eqn="sum 0 0 @1"/>
	<v:f eqn="prod @2 1 2"/>
	<v:f eqn="prod @3 21600 pixelWidth"/>
	<v:f eqn="prod @3 21600 pixelHeight"/>
	<v:f eqn="sum @0 0 1"/>
	<v:f eqn="prod @6 1 2"/>
	<v:f eqn="prod @7 21600 pixelWidth"/>
	<v:f eqn="sum @8 21600 0"/>
	<v:f eqn="prod @7 21600 pixelHeight"/>
	<v:f eqn="sum @10 21600 0"/>
	</v:formulas>
	<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
	<o:lock v:ext="edit" aspectratio="t"/>
	</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:221.25pt;
	height:315pt'>
	<v:imagedata src="DataToolsEval_files/image001.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=295 height=420
	src="DataToolsEval_files/image002.jpg" v:shapes="_x0000_i1025"><![endif]></p>

	<h3>3.2 Connecting to a Database</h3>

	<p><span style='color:red'>{Can add Connection screencaps in this section}</span><br>
	You can connect to a variety of database systems using the Connection Wizard.
	Once connected, the database metadata is loaded, allowing you to view the
	schemas, tables, columns and their data types.<br>
	<br>
	For example, if you have DB2 UDB v8.1 installed and the SAMPLE database
	created, you can follow these steps to connect and load its database metadata:</p>

	<ol start=1 type=1>
	<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	mso-list:l6 level1 lfo3;tab-stops:list .5in'>Launch the Connection Wizard<br>
	The Connection Wizard can be launched from the New Connection item in the
	context menu of the Database Explorer (right mouse click on Database
	Explorer View). </li>
	</ol>

	<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1026" type="#_x0000_t75"
	style='width:491.25pt;height:136.5pt'>
	<v:imagedata src="DataToolsEval_files/image003.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=655 height=182
	src="DataToolsEval_files/image004.jpg" v:shapes="_x0000_i1026"><![endif]></p>

	<ol start=2 type=1>
	<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	mso-list:l6 level1 lfo3;tab-stops:list .5in'>Establish a Connection to a
	Database Page<br>
	Ensure the "Choose a database manager and JDBC driver" radio
	button is selected and press Next. </li>
	</ol>

	<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1027" type="#_x0000_t75"
	style='width:479.25pt;height:436.5pt'>
	<v:imagedata src="DataToolsEval_files/image005.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=639 height=582
	src="DataToolsEval_files/image006.jpg" v:shapes="_x0000_i1027"><![endif]></p>

	<ol start=3 type=1>
	<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	mso-list:l6 level1 lfo3;tab-stops:list .5in'>Specify Connection Parameters
	Page<br>
	In the Select a Database Manager tree, expand the DB2 Universal Database
	node and select V8.1. In the Alias field, type "SAMPLE". Press
	the Test Connection button. After a successful connection, press Next.</li>
	</ol>

	<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1028" type="#_x0000_t75"
	style='width:479.25pt;height:436.5pt'>
	<v:imagedata src="DataToolsEval_files/image007.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=639 height=582
	src="DataToolsEval_files/image008.jpg" v:shapes="_x0000_i1028"><![endif]></p>

	<ol start=4 type=1>
	<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	mso-list:l6 level1 lfo3;tab-stops:list .5in'>Limit the Objects Retrieved
	from the Database catalog loading<br>
	On this page you can filter the database objects that are retrieved. To
	add a filter which excludes tables that start with "C", press
	the Add button to the right of the Table and Routine filter grid. In the
	Add Object Filter dialog, select Table for the Target field, select NOT LIKE
	for the Predicate field and type "C%" (without the quotes) in
	the Predicate field, then press OK. Back in the main wizard page, click
	Next.<br>
	Note: If you are connecting to a database with a large number of database
	objects, it is important to filter appropriately to reduce the number of
	tables returned. </li>
	</ol>

	<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1029" type="#_x0000_t75"
	style='width:353.25pt;height:135pt'>
	<v:imagedata src="DataToolsEval_files/image009.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=471 height=180
	src="DataToolsEval_files/image010.jpg" v:shapes="_x0000_i1029"><![endif]></p>

	<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1030" type="#_x0000_t75"
	style='width:479.25pt;height:436.5pt'>
	<v:imagedata src="DataToolsEval_files/image011.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=639 height=582
	src="DataToolsEval_files/image012.jpg" v:shapes="_x0000_i1030"><![endif]></p>

	<ol start=5 type=1>
	<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	mso-list:l6 level1 lfo3;tab-stops:list .5in'>Specify Connection Parameters
	Page <span style='color:red'>{Q: same name as a previous page? or is it
	because I'm on an older driver?}</span> <br>
	Press Next. </li>
	</ol>

	<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1031" type="#_x0000_t75"
	style='width:479.25pt;height:436.5pt'>
	<v:imagedata src="DataToolsEval_files/image013.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=639 height=582
	src="DataToolsEval_files/image014.jpg" v:shapes="_x0000_i1031"><![endif]></p>

	<ol start=6 type=1>
	<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	mso-list:l6 level1 lfo3;tab-stops:list .5in'>Summary Page<br>
	Review your settings and press Finish. The database metadata will load. </li>
	</ol>

	<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1032" type="#_x0000_t75"
	style='width:479.25pt;height:436.5pt'>
	<v:imagedata src="DataToolsEval_files/image015.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=639 height=582
	src="DataToolsEval_files/image016.jpg" v:shapes="_x0000_i1032"><![endif]></p>

	<p>In the Database Explorer, you will see a tree structure representing your
	connection and the database objects retrieved. <br>
	<br>
	<!--[if gte vml 1]><v:shape id="_x0000_i1033" type="#_x0000_t75" style='width:483.75pt;
	height:318pt'>
	<v:imagedata src="DataToolsEval_files/image017.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=645 height=424
	src="DataToolsEval_files/image018.jpg" v:shapes="_x0000_i1033"><![endif]><span
	style='mso-spacerun:yes'> </span></p>

	<h3>3.3 Sampling Contents of a Table</h3>

	<p>You can sample the contents of a table and see its data appear in the DB
	Output view.</p>

	<p>To sample the data from a table, expand the connection, database, schema and
	Tables nodes in the Database Explorer. Using a table's context menu, select
	Sample Contents. This displays the table's data in the Results tab of the DB
	Output view.<br>
	<br>
	<!--[if gte vml 1]><v:shape id="_x0000_i1034" type="#_x0000_t75" style='width:488.25pt;
	height:320.25pt'>
	<v:imagedata src="DataToolsEval_files/image019.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=651 height=427
	src="DataToolsEval_files/image020.jpg" v:shapes="_x0000_i1034"><![endif]></p>

	<p><span style='color:red'><!--[if gte vml 1]><v:shape id="_x0000_i1035"
	type="#_x0000_t75" style='width:489.75pt;height:318pt'>
	<v:imagedata src="DataToolsEval_files/image021.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=653 height=424
	src="DataToolsEval_files/image022.jpg" v:shapes="_x0000_i1035"><![endif]><span
	style='mso-spacerun:yes'> </span></span></p>

	<h3>3.4 Executing SQL Statements and Commands</h3>

	<p>The Data Tools offer a way to execute SQL statements and commands through
	its SQL Scrapbook editor. <br>
	<br>
	To invoke the SQL Scrapbook, select Open SQL Scrapbook from the connection node
	context menu in the Database Explorer. The SQL Scrapbook opens in the editor
	area. Type a SQL statement or command then execute it by selecting Execute from
	the SQL menu or by selecting the Execute icon in the toolbar. <br>
	<br>
	<!--[if gte vml 1]><v:shape id="_x0000_i1036" type="#_x0000_t75" style='width:489.75pt;
	height:159.75pt'>
	<v:imagedata src="DataToolsEval_files/image023.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=653 height=213
	src="DataToolsEval_files/image024.jpg" v:shapes="_x0000_i1036"><![endif]><span
	style='color:red'><br style='mso-special-character:line-break'>
	<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
	<![endif]><o:p></o:p></span></p>

	<p><!--[if gte vml 1]><v:shape id="_x0000_i1037" type="#_x0000_t75" style='width:489.75pt;
	height:479.25pt'>
	<v:imagedata src="DataToolsEval_files/image025.png" o:title=""/>
	</v:shape><![endif]--><![if !vml]><img width=653 height=639
	src="DataToolsEval_files/image026.jpg" v:shapes="_x0000_i1037"><![endif]></p>

	<h2>4.0 Known Problems</h2>

	<ul type=disc>
	<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
	mso-list:l4 level1 lfo11;tab-stops:list .5in'>CLOB and BLOB data types do
	not display well in the DB Output view.</li>
	</ul>

	<h2>5.0 Provide Feedback to Us</h2>

	<P>We encourage development/design feed back on the <A
	href="https://dev.eclipse.org/mailman/listinfo/wtp-dev">wtp-dev</A> mailing list. You can subscribe to the list via <A
	href="https://dev.eclipse.org/mailman/listinfo/wtp-dev">this link</A>.<BR>
	<BR>
	For usage questions, discussion of bugs, and strange behaviour please post to the eclipse.webtools newsgroup. Information on the Web Tools Platform newsgroup can be found <A
	href="http://www.eclipse.org/newsgroups/index.html">here</A>.</P>


	</div>

	</body>

	</html>