Purpose
Enter the DQL command to activate DQL Mode.
When to Use It
When you are operating in SQL Mode and want to change to DQL Mode.
Syntax
|
Enter |
With |
When You Want to: |
|---|---|---|
|
DQL |
No operand |
Change from SQL Mode to DQL Mode. |
Example
=> DQL PLACE THE CURSOR BY THE DESIRED NAME AND PRESS THE APPROPRIATE PFKEY ------------------------------------------------------------------------DQT10 DATAQUERY: DIRECTORY OF TABLES DATADICTIONARY BASE ID: 002 START WITH: __________________ ----------------------------------------------------------------------------- TABLE NAME | DESCRIPTION ----------------------------------------------------------------------------- ORG | ORGANIZATION INFORMATION STAFF | STAFF DATA PERSONNEL | EMPLOYEE INFORMATION RETIREMENT | RETIREMENT PLANNING
Result
=> ------------------------------------------------------------------------DQZ60 DATAQUERY: MAIN MENU - DQL MODE ENTER THE NUMBER OF THE DESIRED FUNCTION ===> _ 1. DIRECTORIES - Lists of Queries, Terms, Tables, and Saved Sets 2. CREATE - Query, Dialog or Term creation 3. GUIDE - Structured query creation 4. PDB - List, create and maintain personal tables 5. ADMINISTRATION - DATAQUERY system management 6. HELP - Display Help Information 7. OFF - DATAQUERY session termination
|
Copyright © 2014 CA.
All rights reserved.
|
|