This section describes how to give the query a name, library status, and description.
After you select CREATE from the Main Menu, you see the following EDITOR panel (DQD10).
=> CREATION PANEL --------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR CURRENT TABLE: ________________________________ ------------------------------------------------------------------------------- NAME: _______________ TYPE: ______ STATUS: _______ DESCRIPTION: ___________________________________________________________ ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== .. .. .. .. .. .. .. .. .. =========================== B O T T O M ================================== ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> DISPLAY COLUMNS <PF4> DISPLAY KEYS <PF5> DISPLAY ALL <PF6> LIST TABLES <PF7> BACKWARD <PF8> FORWARD <PF9> TEMPLATE <PF10> VALIDATE <PF11> RIGHT/LEFT <PF12> PROCESS MODE
Facts
You are not required to name a query until you save it. However, if you want to validate or execute it, you must give it a type. You might as well identify the query as your first step.
These are the things you should know about identifying a query:
A query name must be unique within its assigned library and must be one word of 1 to 15 alphabetic characters, numbers, underscores, or special characters. Be sure to see Restrictions on Names for important restrictions on names.
Valid entries are QUERY or DIALOG. A dialog allows users to substitute variables in a query. For information about using the CA Dataquery EDITOR to create dialogs, see Creating Dialogs.
Valid entries are PRIVATE and PUBLIC. You can update and delete queries saved in your private library. If you assign a query to the public library, you cannot change or delete it once the query has been saved unless your site allows the author of a public query to change it. Contact your CA Dataquery Administrator for more information.
Note: If you chose to update a query you own, you may also need to update the report format. Some changes cause an error message to appear warning that the format does not match the query. Others, such as adding new columns or new ORDER BY statements, would not affect the report format verification process and therefore would not cause a message to appear. For information about changing the default report format when you change a query, see Modify an SQL Report Format.
A description should tell the query's purpose and note anything that makes it unique. It cannot exceed 60 characters in length.
Entries
Use the Tab key to move the cursor to each field in turn: NAME, TYPE, STATUS, and DESCRIPTION. The following chart shows the appropriate entries for the sample query.
|
Field |
Entry |
Explanation |
|---|---|---|
|
NAME |
SQLSAMPLE01 |
The name indicates that it is an SQL query and that it is the first sample query created. |
|
TYPE |
QUERY |
Self-explanatory. |
|
STATUS |
PUBLIC |
The query should be available to other users. |
|
DESCRIPTION |
SAMPLE BASIC QUERY |
Describes the query's purpose when its name is listed on a directory. |
How it Looks Now
The following illustration shows the completed identification fields for the sample query.
DATAQUERY: EDITOR CURRENT TABLE: ________________________________ ------------------------------------------------------------------------------- NAME: SQLSAMPLE01____ TYPE: QUERY_ STATUS: PUBLIC_ DESCRIPTION: SAMPLE BASIC QUERY_________________________________________ ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P =====================================
Options
You could include more information about the query itself in the description. For instance, you could list the columns reported or name the tables accessed in the query description. You could also make your queries PRIVATE until you are sure you want to share them with other users.
|
Copyright © 2014 CA.
All rights reserved.
|
|