tailieunhanh - SQL VISUAL QUICKSTART GUIDE- P5

SQL VISUAL QUICKSTART GUIDE- P5:SQL (pronounced es-kyoo-el) is the standard programming language for creating, updating, and retrieving information that is stored in databases. With SQL, you can turn your ordinary questions (“Where do our customers live?”) into statements that your database system can understand (SELECT DISTINCT city, state FROM customers;) | Chapter 1 IBM DB2 IBM DB2 is a commercial DBMS that supports very large databases and numbers of transactions. It runs on many operating systems and hardware platforms and is complex enough to require a full-time database administrator DBA to run and maintain it. Learn about DB2 products at db2 and download a free 90-day trial copy of DB2 or a permanently free copy of IBM DB2 Express-C. This book covers DB2 but also includes tips for earlier versions back to . To determine which version of DB2 you re running run the DB2 command-line command db2level or run the query SELECT service_level FROM . To run SQL programs use the Command Center graphical tool in DB2 the Command Editor graphical tool in DB2 or the db2 command-line processor CLP . IBM DB2 20 DBMS Specifics Figure A ready-to-run SELECT statement in Command Center. Figure The results of the SELECT statement. To use Command Center DB2 1. Start Command Center. This procedure varies by platform. In Windows for example choose Start All Programs IBM DB2 Command Line Tools Command Center. In Unix and Linux use the command db2cctr. Alternatively if Control Center is open choose Tools Command Center or click UJ. 2. Choose the command-type SQL Statements and DB2 CLP Commands. 3. Click the Interactive tab. 4. In the Database Connection box click I expand the object tree until you find the Databases folder select a database and then click OK. 5. To run SQL interactively in the Command box type or paste an SQL statement Figure . or To run an SQL script click the Scripts tab choose Script Import navigate to and select the script file and then click OK. 6. Click 0 or press Ctrl Enter. or Choose Interactive Execute or Script Execute. Interactive-SQL results appear in the Results tab Figure . SQL-script results appear in the box below the Script box. IBM DB2 21 Chapter 1 IBM DB2 To use Command Editor DB2 1. Start Command Editor. This procedure .