Google Git
Sign in
eclipse / www.eclipse.org / webtools / 13c61b8971cb027b489d5897463f9e6941d3a0fb / . / community / tutorials / RDBTutorial / RDBTutorial.html
blob: 31ebbf3ab9f2f1ec71e3f63c8890282af037c51d [file] [log] [blame]
<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:st1="urn:schemas-microsoft-com:office:smarttags"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<!--[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>WST</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[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>1784</o:TotalTime>
<o:Created>2005-02-19T06:52:00Z</o:Created>
<o:LastSaved>2005-02-19T06:52:00Z</o:LastSaved>
<o:Pages>1</o:Pages>
<o:Words>584</o:Words>
<o:Characters>3333</o:Characters>
<o:Company>IBM</o:Company>
<o:Lines>27</o:Lines>
<o:Paragraphs>7</o:Paragraphs>
<o:CharactersWithSpaces>3910</o:CharactersWithSpaces>
<o:Version>10.2625</o:Version>
</o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:UseFELayout/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if !mso]><object
classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object>
<style>
st1\:*{behavior:url(#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Courier;
panose-1:2 7 4 9 2 2 5 2 4 4;
mso-font-charset:0;
mso-generic-font-family:modern;
mso-font-format:other;
mso-font-pitch:fixed;
mso-font-signature:3 0 0 0 1 0;}
@font-face
{font-family:PMingLiU;
panose-1:2 1 6 1 0 1 1 1 1 1;
mso-font-alt:"Arial Unicode MS";
mso-font-charset:136;
mso-generic-font-family:auto;
mso-font-format:other;
mso-font-pitch:variable;
mso-font-signature:1 134742016 16 0 1048576 0;}
@font-face
{font-family:"\@PMingLiU";
panose-1:0 0 0 0 0 0 0 0 0 0;
mso-font-charset:136;
mso-generic-font-family:auto;
mso-font-format:other;
mso-font-pitch:variable;
mso-font-signature:1 134742016 16 0 1048576 0;}
/* 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:PMingLiU;}
h1
{mso-style-next:Normal;
margin-top:12.0pt;
margin-right:0in;
margin-bottom:3.0pt;
margin-left:0in;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:1;
font-size:16.0pt;
font-family:Arial;
mso-font-kerning:16.0pt;}
h3
{mso-style-link:"Heading 3 Char";
mso-style-next:Normal;
margin-top:12.0pt;
margin-right:0in;
margin-bottom:3.0pt;
margin-left:0in;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:3;
font-size:13.0pt;
font-family:Arial;}
span.Heading3Char
{mso-style-name:"Heading 3 Char";
mso-style-link:"Heading 3";
mso-ansi-font-size:13.0pt;
mso-bidi-font-size:13.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-fareast-font-family:PMingLiU;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
mso-ansi-language:EN-US;
mso-fareast-language:ZH-TW;
mso-bidi-language:AR-SA;
font-weight:bold;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@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:199588104;
mso-list-type:hybrid;
mso-list-template-ids:2088654226 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1
{mso-list-id:262808332;
mso-list-type:hybrid;
mso-list-template-ids:-1723032724 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2
{mso-list-id:377050404;
mso-list-type:hybrid;
mso-list-template-ids:1608701434 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l2:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l3
{mso-list-id:384645706;
mso-list-type:hybrid;
mso-list-template-ids:-1305694066 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l3:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l4
{mso-list-id:738476941;
mso-list-type:hybrid;
mso-list-template-ids:-2031159454 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l4:level1
{mso-level-tab-stop:.25in;
mso-level-number-position:left;
margin-left:.25in;
text-indent:-.25in;}
@list l5
{mso-list-id:845051182;
mso-list-type:hybrid;
mso-list-template-ids:1881680384 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l5:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6
{mso-list-id:1374689416;
mso-list-type:hybrid;
mso-list-template-ids:-1094386728 67698689 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l6:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.75in;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;
font-family:Symbol;}
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]-->
</head>
<body lang=EN-US style='tab-interval:.5in'>
<div class=Section1>
<h1 align=center style='text-align:center'>RDB Tutorial</h1>
<p class=MsoNormal>This document walks you through the relational database (RDB)
open source features in the Eclipse Web Tooling Project.<span
style='mso-spacerun:yes'>  </span>You must have either the RDB open source binaries
or the source code downloaded from the Eclipse Web site. </p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal>The supported features include the following:<o:p></o:p></p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal><b style='mso-bidi-font-weight:normal'>Connection Wizard</b>
– Create a live connection to the database server using the JDBC driver.</p>
<p class=MsoNormal><b style='mso-bidi-font-weight:normal'>Server Explorer</b> –
Support the live view of database server elements including tables, views, stored
procedures, and user-defined functions. In the Server Explorer, you can also
view a database sever in an offline mode.</p>
<p class=MsoNormal><b style='mso-bidi-font-weight:normal'>Data Browse</b> –
Browse table content from the connected database server.</p>
<p class=MsoNormal><b style='mso-bidi-font-weight:normal'>SQL Scrapbook</b> – A
SQL utility/editor which can be used to construct SQL commands to be executed
to a connected server in the Server Explorer.</p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal><span class=Heading3Char><span style='font-size:13.0pt'>Opening
the RDB related view</span></span><br style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></p>
<p class=MsoNormal>From the Window -&gt; Show View -&gt; Others -&gt; Server
Explorer, select <b style='mso-bidi-font-weight:normal'>DB Output</b> and <b
style='mso-bidi-font-weight:normal'>Server Explorer</b>.</p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal><!--[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="images/image001.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=295 height=420
src="images/image002.jpg" v:shapes="_x0000_i1025"><![endif]></p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal><span class=Heading3Char><span style='font-size:13.0pt'>Creating
a new connection using the Connection wizard</span></span></p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal>To create a new connection using the Connection wizard:</p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<ol style='margin-top:0in' start=1 type=1>
<li class=MsoNormal style='mso-list:l5 level1 lfo1;tab-stops:list .5in'>In the
Server Explorer window, right-click and select <b style='mso-bidi-font-weight:
normal'>New Connection</b>.</li>
<li class=MsoNormal style='mso-list:l5 level1 lfo1;tab-stops:list .5in'>Select
the database that you would like to connect to, and fill in the JDBC
connection information.</li>
</ol>
<p class=MsoNormal style='margin-left:.25in'><br>
Note: The Connection wizard in the milestone II release only uses the final <b
style='mso-bidi-font-weight:normal'>Connection</b> <b style='mso-bidi-font-weight:
normal'>URL</b> string and the <b style='mso-bidi-font-weight:normal'>JDBC
driver class </b>name to connect. The <b style='mso-bidi-font-weight:normal'>Test
Connection</b> and <b style='mso-bidi-font-weight:normal'>Next</b> buttons will
not show up unless all of the required information has been filled in.</p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal style='margin-left:.75in;text-indent:-.25in;mso-list:l6 level1 lfo2;
tab-stops:list .75in'><![if !supportLists]><span style='font-family:Symbol;
mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol'><span
style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]>To connect to a <st1:City><st1:place>Derby</st1:place></st1:City>
database:<br style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></p>
<p class=MsoNormal style='margin-left:.5in'><!--[if gte vml 1]><v:shape id="_x0000_i1026"
type="#_x0000_t75" style='width:6in;height:6in'>
<v:imagedata src="images/image003.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=576 height=576
src="images/image004.jpg" v:shapes="_x0000_i1026"><![endif]></p>
<p class=MsoNormal style='margin-left:.5in'><o:p>&nbsp;</o:p></p>
<p class=MsoNormal style='margin-left:.75in;text-indent:-.25in;mso-list:l6 level1 lfo2;
tab-stops:list .75in'><![if !supportLists]><span style='font-family:Symbol;
mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol'><span
style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]>To connect to the SQL Server 2000 database<span
class=GramE>:</span><br>
<br>
Note:<span style='mso-spacerun:yes'>  </span>If you are connecting to SQL
Server 2000 using the MS JDBC driver, you must specify the path to the three
required jar files (for example, <span class=SpellE>mssqlserver.jar</span>, <span
class=SpellE>msbase.jar</span>, and <span class=SpellE>msutil.jar</span>).</p>
<p class=MsoNormal style='margin-left:.5in'><br>
<!--[if gte vml 1]><v:shape id="_x0000_i1027" type="#_x0000_t75" style='width:6in;
height:6in'>
<v:imagedata src="images/image005.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=576 height=576
src="images/image006.jpg" v:shapes="_x0000_i1027"><![endif]></p>
<p class=MsoNormal style='margin-left:.5in'><o:p>&nbsp;</o:p></p>
<p class=MsoNormal style='margin-left:.25in'>3.<span style='mso-spacerun:yes'> 
</span><span style='mso-spacerun:yes'> </span>Click <b style='mso-bidi-font-weight:
normal'>Test Connection</b>.<o:p></o:p></p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal style='margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1028"
type="#_x0000_t75" style='width:330.75pt;height:109.5pt'>
<v:imagedata src="images/image007.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=441 height=146
src="images/image008.jpg" v:shapes="_x0000_i1028"><![endif]></p>
<p class=MsoNormal style='margin-left:.25in'><o:p>&nbsp;</o:p></p>
<ol style='margin-top:0in' start=3 type=1>
<li class=MsoNormal style='mso-list:l5 level1 lfo1;tab-stops:list .5in'>Click <b
style='mso-bidi-font-weight:normal'>Next</b>.</li>
<li class=MsoNormal style='mso-list:l5 level1 lfo1;tab-stops:list .5in'>Set
filters as appropriate.<span style='mso-spacerun:yes'>  </span>You can
also filter after the connection is made.<br>
<br>
In a future milestone, you will be able to filter schemas, tables, views,
stored procedures, and so on, from the folder in your Server Explorer.</li>
<li class=MsoNormal style='mso-list:l5 level1 lfo1;tab-stops:list .5in'>Click <b
style='mso-bidi-font-weight:normal'>Finish</b>.</li>
</ol>
<p class=MsoNormal style='margin-left:.25in'><o:p>&nbsp;</o:p></p>
<p class=MsoNormal style='margin-left:.25in'>In the Server Explorer, expand the
Server node and view the folders for schemas, tables, views, stored procedures,
and so on.</p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal style='margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1029"
type="#_x0000_t75" style='width:459pt;height:140.25pt'>
<v:imagedata src="images/image009.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=612 height=187
src="images/image010.jpg" v:shapes="_x0000_i1029"><![endif]></p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal><span class=Heading3Char><span style='font-size:13.0pt'>Reconnecting
to a server from the Server Explorer</span></span></p>
<p class=MsoNormal><br>
From the Server Explorer, you can reconnect to a server.<span
style='mso-spacerun:yes'>  </span>Right-click on the disconnected server, and
select <b style='mso-bidi-font-weight:normal'>Reconnect</b>.</p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1030" type="#_x0000_t75"
style='width:6in;height:132.75pt'>
<v:imagedata src="images/image011.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=576 height=177
src="images/image012.jpg" v:shapes="_x0000_i1030"><![endif]></p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal>Work offline in Server Explorer:<br style='mso-special-character:
line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></p>
<p class=MsoNormal>To save a new object in the Server Explorer, right-click a
server connection, and select <b style='mso-bidi-font-weight:normal'>Update
Offline Items</b>.<span style='mso-spacerun:yes'>  </span>Currently, the Server
Explorer only supports read-only mode.<span style='mso-spacerun:yes'> 
</span>You can get read/write mode by generating a DDL to run on the database
Server.</p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1031" type="#_x0000_t75"
style='width:6in;height:132pt'>
<v:imagedata src="images/image013.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=576 height=176
src="images/image014.jpg" v:shapes="_x0000_i1031"><![endif]></p>
<p class=MsoNormal><span class=Heading3Char><span style='font-size:13.0pt'><o:p>&nbsp;</o:p></span></span></p>
<p class=MsoNormal><span class=Heading3Char><span style='font-size:13.0pt'>Browse
Data feature<o:p></o:p></span></span></p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal>To browse data:</p>
<p class=MsoNormal><br>
In the Server Explorer, right-click a table, and select <b style='mso-bidi-font-weight:
normal'>Data -&gt; Browse</b>.</p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1039" type="#_x0000_t75"
style='width:468pt;height:143.25pt'>
<v:imagedata src="images/image015.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=624 height=191
src="images/image016.jpg" v:shapes="_x0000_i1039"><![endif]></p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal>Here is an example of a result set of a table with data:<br>
<span style='mso-spacerun:yes'> </span></p>
<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1032" type="#_x0000_t75"
style='width:459pt;height:147.75pt'>
<v:imagedata src="images/image017.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=612 height=197
src="images/image018.jpg" v:shapes="_x0000_i1032"><![endif]></p>
<p class=MsoNormal><span class=Heading3Char><span style='font-size:13.0pt'><o:p>&nbsp;</o:p></span></span></p>
<p class=MsoNormal><span class=Heading3Char><span style='font-size:13.0pt'>Opening
the SQL Scrapbook</span></span><br style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]><b><span style='font-size:13.0pt;font-family:Arial'><o:p></o:p></span></b></p>
<p class=MsoNormal>To open the SQL Scrapbook, you must have a project and a folder
created.<span style='mso-spacerun:yes'>  </span>You can open the SQL Scrapbook
in two different ways:</p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<ol style='margin-top:0in' start=1 type=1>
<li class=MsoNormal style='mso-list:l3 level1 lfo7;tab-stops:list .5in'>From
the Server Explorer, click the <b style='mso-bidi-font-weight:normal'>Open
SQL Scrapbook </b>icon.<br>
<br>
<!--[if gte vml 1]><v:shape id="_x0000_i1033" type="#_x0000_t75" style='width:6in;
height:122.25pt'>
<v:imagedata src="images/image019.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=576 height=163
src="images/image020.jpg" v:shapes="_x0000_i1033"><![endif]><br
style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></li>
<li class=MsoNormal style='mso-list:l3 level1 lfo7;tab-stops:list .5in'>Choose
a connection to associate your scrapbook with.<br>
<br>
<!--[if gte vml 1]><v:shape id="_x0000_i1034" type="#_x0000_t75" style='width:229.5pt;
height:170.25pt'>
<v:imagedata src="images/image021.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=306 height=227
src="images/image022.jpg" v:shapes="_x0000_i1034"><![endif]><br
style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></li>
<li class=MsoNormal style='mso-list:l3 level1 lfo7;tab-stops:list .5in'>Specify
a folder name and a name for your sqlpage file.<br style='mso-special-character:
line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></li>
</ol>
<p class=MsoNormal><u>OR<br style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]><o:p></o:p></u></p>
<ol style='margin-top:0in' start=1 type=1>
<li class=MsoNormal style='mso-list:l2 level1 lfo5;tab-stops:list .5in'>Select
the folder.</li>
<li class=MsoNormal style='mso-list:l2 level1 lfo5;tab-stops:list .5in'>Click <b
style='mso-bidi-font-weight:normal'>File -&gt; New -&gt; Others -&gt; Data
-&gt; SQL Scrapbook page</b>.<br style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></li>
</ol>
<p class=MsoNormal style='margin-left:.25in'><!--[if gte vml 1]><v:shape id="_x0000_i1035"
type="#_x0000_t75" style='width:375pt;height:375pt'>
<v:imagedata src="images/image023.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=500 height=500
src="images/image024.jpg" v:shapes="_x0000_i1035"><![endif]><br
style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></p>
<ol style='margin-top:0in' start=3 type=1>
<li class=MsoNormal style='mso-list:l2 level1 lfo5;tab-stops:list .5in'>Click <b
style='mso-bidi-font-weight:normal'>Next</b>.</li>
<li class=MsoNormal style='mso-list:l2 level1 lfo5;tab-stops:list .5in'>Type a
name for your sqlpage file.<span style='mso-spacerun:yes'>  </span>For
example, CreateTable.sqlpage.</li>
<li class=MsoNormal style='mso-list:l2 level1 lfo5;tab-stops:list .5in'>Click <b
style='mso-bidi-font-weight:normal'>Finish</b>.</li>
<li class=MsoNormal style='mso-list:l2 level1 lfo5;tab-stops:list .5in'>Click
the <b style='mso-bidi-font-weight:normal'>Select Connection</b> icon on
the toolbar to associate a connection to a SQL Scrapbook or a sqlpage
file.<span style='mso-spacerun:yes'>  </span>The Server Selection window
opens.<span style='mso-spacerun:yes'>  </span><br>
<br>
<!--[if gte vml 1]><v:shape id="_x0000_i1036" type="#_x0000_t75" style='width:372.75pt;
height:425.25pt'>
<v:imagedata src="images/image025.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=497 height=567
src="images/image026.jpg" v:shapes="_x0000_i1036"><![endif]><br
style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></li>
<li class=MsoNormal style='mso-list:l2 level1 lfo5;tab-stops:list .5in'>Select
a server, and click <b style='mso-bidi-font-weight:normal'>OK</b>.<br
style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></li>
</ol>
<p class=MsoNormal style='margin-left:.5in'><!--[if gte vml 1]><v:shape id="_x0000_i1037"
type="#_x0000_t75" style='width:229.5pt;height:170.25pt'>
<v:imagedata src="images/image021.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=306 height=227
src="images/image022.jpg" v:shapes="_x0000_i1037"><![endif]></p>
<p class=MsoNormal>You can now start typing a SQL statement in the SQL
scrapbook. <span style='mso-spacerun:yes'> </span>For example, <br
style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></p>
<p class=MsoNormal><span style='font-family:Courier'>Create table <span
class=SpellE>APP.Parent</span> (col1 integer not null, col2 <span class=GramE>char(</span>11),
primary key(col1))<br style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]><o:p></o:p></span></p>
<p class=MsoNormal>To run the SQL, click the <b style='mso-bidi-font-weight:
normal'>Execute the SQL statement</b> icon. <br style='mso-special-character:
line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></p>
<p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1038" type="#_x0000_t75"
style='width:441.75pt;height:282pt'>
<v:imagedata src="images/image027.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=589 height=376
src="images/image028.jpg" v:shapes="_x0000_i1038"><![endif]></p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
<p class=MsoNormal>After you run the SQL, the view is automatically
refreshed.<span style='mso-spacerun:yes'>  </span>If you want to manually
refresh the view, right-click the folder in the Server Explorer, and select <b
style='mso-bidi-font-weight:normal'>Refresh</b>.</p>
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
</div>
</body>
</html>