| <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> </o:p></p> | |
| <p class=MsoNormal>The supported features include the following:<o:p></o:p></p> | |
| <p class=MsoNormal><o:p> </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> </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 -> Show View -> Others -> 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> </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> </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> </o:p></p> | |
| <p class=MsoNormal>To create a new connection using the Connection wizard:</p> | |
| <p class=MsoNormal><o:p> </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> </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"'> | |
| </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> </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"'> | |
| </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> </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> </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> </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> </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> </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> </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> </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> </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> </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> </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> </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 -> Browse</b>.</p> | |
| <p class=MsoNormal><o:p> </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> </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> </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> </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 -> New -> Others -> Data | |
| -> 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> </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> </o:p></p> | |
| </div> | |
| </body> | |
| </html> |