Micro Focus Studio Enterprise Edition Test Server
>
Programming
>
Mainframe Programming
>
SQL Option for DB2
>
How to...
>
SQL Wizard
>
Query Databases
Query Databases
Creating a Query
To create a query
Viewing Queries in SQL Edit Mode
Saving a Query
Opening a Saved Query
Running a Query
Viewing Results
Closing a Result Window
Example
Example
Setting Query Options
Choosing Columns
Moving Columns
Hiding Columns
Defining Conditions for a Single Column
Matching a Range of Values
Using AND and OR on One Column
Using AND and OR on Different Columns
Referring to Other Columns in Conditions
Including Calculations in Conditions
Selecting From a List of Values
Defining Computed Columns
Renaming Fields
Finding Distinct Values
Adding Extended Conditions (And and Where)
Specifying Sort Order
Retrieving Data From Two or More Tables
Displaying Table Names
Avoiding Cartesian Products
Prohibiting Cartesian Products
Manual Joins
Preventing Cartesian Products with Auto Joins
Non-equijoins
Outer Joins
Creating a Summary Query
Searching for Duplicate Values
Creating a Union
Creating a View
Creating a DELETE Statement
Creating an UPDATE Statement
Creating an INSERT Statement
Parent topic:
SQL Wizard
