Step 5: Select Columns

Using GUIDE in SQL Mode › Creating a Sample Query › Sample Procedure › Step 5: Select Columns

Step 5: Select Columns

This section tells how to select columns for the sample query.

After you select a table and press <PF4> CONTINUE, you see this panel:

Output Row: Column Selection (DQIG0)

=> --------------------------------------------------------------------------DQIG0 DATAQUERY: OUTPUT ROW: COLUMN SELECTION QUERY NAME: SQLGUIDE ------------------------------------------------------------------------------- SELECT COLUMNS TO BE INCLUDED IN THE OUTPUT ROW BY PLACING ANY CHARACTER NEXT TO THE DESIRED NAMES. ------------------------------------------------------------------------------- SELECT|TABLE/COLUMN NAME | DESCRIPTION ------------------------------------------------------------------------------- | CAI_SLSHST_TBL | _ | ORD_ID | _ | ITM_ID | _ | ORD_DT | _ | ORD_YR | _ | ORD_MO | _ | ORD_DAY | _ | ORD_QTY | _ | SHIP_QTY | _ | UNIT_PRICE | _ | DISC_PCT | ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> CONTINUE <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY <PF7> BACKWARD <PF8> FORWARD

Facts

The following presents the facts needed to select columns for the sample query.

Output row: Query execution creates a result table that is made up of rows of found data.
Result of column selection: Your report will consist of data that CA Dataquery finds in each column you select on this panel.

Steps

The following describes the steps required for selecting output columns in creating the sample query.

Step 1: Decide which column should contain the data needed for the report.
Step 2: Type an X in the fields preceding ITM_ID, SHIP_QTY, and UNIT_PRICE.
Step 3: Press <PF4> CONTINUE.

Options

The following lists other things you could do during display of this panel.

Extend Column: Press <PF5> to see a panel with the definitions for each column in the table.
Display Query: Press <PF6> to see the query as it looks before column selection.
Select more or fewer columns: You can select as many columns as you like, as long as you select at least one.

Additional Information

The following provides additional information you might want to read about selecting tables.

SELECT clause

The portion of a query that lists the database columns that contain data wanted in the output. (SELECT clauses can perform several functions. For more information, see 1.)

Decision-making tips

Decision-making aids can include:

Reading the column description.
Using online aids described in Displaying Database Names and Structures.
Obtaining information from the CA Dataquery Administrator.
Looking at a portion of the data in a table you want to know about. You can use the DRAW command to write a query that reports on all columns and then execute that query.