To run commands and SQL statements::

1.To open an embedded Command Editor, expand the Control Center object tree until you find a DB2 database. Right-click the object and select Query from the pop-up menu. A Command Editor tile opens in the Control Center.

2.To open a stand-alone Command Editor from the Start menu, select Programs —> IBM DB2 —> [DB2 copy name] —> Command Line Tools —> Command Editor.

3.Select a target database to connect to. Targets that currently have connections or have had connections during the current session are listed in the Target drop-down list. If your target is not listed, click Add and select a target from those available on the Specify Target window. You can also type the connect to database statement.

4.In the top pane, type the commands or SQL statements that you want to execute.

5.You can select commands and statements previously executed in this session

from the History window. Click to open the History window.

6.You can execute commands and statements stored in a file. Click to locate the file using the file browser Open window.

7.You can specify the character to be used as the termination character for your statements and commands in the Statement termination character field. This termination character will override the character that you may have specified in the Tool Settings notebook.

8.For scripts containing CREATE PROCEDURE or CREATE TRIGGER statements, it is suggested that a termination character other than a semicolon be used, as the body of these statements might themselves contain one or more semicolons.

9.When stored procedures are using the same character as a delimiter, as this would cause execution problems.

10.Click to execute the commands or statements.

11.

Click

to generate a graphical representation of the access plan for

 

explainable SQL statements (for example, SELECT, INSERT, and UPDATE). An

 

access plan indicates the order of operations for accessing requested data.

12.

Click

to execute explainable SQL statements and generate access

 

plans. The availability of push buttons changes depending on the database

 

target for your commands.

13.View the execution results. Command results are displayed in the output area of the Commands page, while SQL results are returned on the Query Results page. The access plan appears in graphical form on the Access Plan page.

14.Optional: The results from the most recently executed SQL statement are displayed on the Query Results page. To change the value in any cell, highlight the value and modify it. If the Automatically commit updates check box is selected, changes made to a cell are committed immediately when focus shifts off its row. If the check box is not selected, then click Commit to commit your changes, or click Rollback to rollback any uncommitted changes.

15.You can also add, modify, and delete rows in the table.

48Getting started with DB2 installation and administration

Page 55 Page 57
Page 56
Image 56
IBM VERSION 9 manual To run commands and SQL statements
Page 55 Page 57

VERSION 9 specifications

IBM VERSION 9 is a significant advancement in IBM's product line, boasting a range of features and technologies designed to enhance performance, security, and usability in enterprise environments. This version marks a pivotal shift, focusing on integrating artificial intelligence, cloud computing, and advanced data analytics into its core functionalities.

One of the standout features of IBM VERSION 9 is its enhanced artificial intelligence capabilities. With built-in AI tools, users can leverage machine learning algorithms and natural language processing to automate tasks, gain insights from data, and improve decision-making processes. These capabilities are not only geared towards data scientists but are also accessible to business analysts who may not possess deep technical skills, thereby democratizing access to AI-driven analytics.

Another defining characteristic is the robust cloud integration. IBM VERSION 9 seamlessly supports hybrid cloud architectures, allowing organizations to operate across private and public cloud environments with ease. This flexibility enables businesses to optimize their resources, manage workloads more efficiently, and ensure data is stored and processed in the most suitable environment. Enhanced security protocols and data encryption mechanisms further ensure that sensitive information remains protected both on-premises and in the cloud.

The release also emphasizes improved performance optimizations, utilizing cutting-edge technologies such as in-memory computing and parallel processing. These enhancements result in faster data processing speeds and reduced latency, ultimately leading to improved user experiences across applications. Additionally, the system supports a variety of programming languages, allowing developers to use their preferred tools while building applications that harness the full potential of IBM VERSION 9.

User experience is another area that received attention in this version. The interface has been streamlined and made more intuitive, enabling users to navigate through features and functionalities easily. Training resources and documentation have also been improved, providing comprehensive support to ensure users can maximize the capabilities of IBM VERSION 9 without steep learning curves.

In summary, IBM VERSION 9 brings together a suite of advanced features, including enhanced AI capabilities, robust cloud integration, improved performance, and a user-friendly interface, making it a powerful tool for modern enterprises seeking to harness technology for competitive advantage. With these innovations, IBM continues to position itself as a leader in the tech industry, addressing the evolving needs of businesses worldwide.
Top Page Image Contents