Purpose
Use the STORE command to automatically create a personal table containing the output data of a query. CA Dataquery creates a query containing a CREATE TABLE command that becomes the active query. (The Personal Database Facility is not available to users of products installed with CA Datacom/AD.)
When to Use It
During display of the output of a query in either mode.
Syntax
|
Enter |
With |
When You Want to: |
|---|---|---|
|
STORE |
table-name |
Create a Personal Table containing query output. |
The table name should begin with an alphabetic character. You can use letters, numbers, and underscores (_) as part of the name. The maximum name length is 32 characters.
After creation, Datadictionary assigns the table an entity-name and that name appears on directories. Where duplicate names occur, Datadictionary may modify a name to make it unique. Also, any table you create is stored under your permanent SQL authorization ID, maintained by your CA Dataquery Administrator.
Example
=> STORE STAFF2 DQ471I - ROWS FOUND: 000037 01/03/2010 DATAQUERY SAMPLE PAGE 1 14:12:25 DOCUMENT-STORE-BIRDS DETAIL ID NAME DEPT JOB YEARS SALARY COMM -------- --------- -------- ----- -------- ----------- ----------- 00010 SANDERS 00020 MGR 00007 18357.50 00000.00 00020 PERNAL 00020 SALES 00008 18171.25 00612.45 00030 MARENGHI 00038 MGR 00005 17506.75 00000.00 00040 O'BRIEN 00038 SALES 00006 18006.00 00846.55 00050 HANES 00015 MGR 00010 20659.80 00000.00 00060 QUIGLEY 00038 SALES 00000 16808.30 00650.25 00070 ROTHMAN 00015 SALES 00007 16502.83 01152.00 00080 JAMES 00020 CLERK 00000 13504.60 00128.20 00090 KOONITZ 00042 SALES 00006 18001.75 01386.70 00100 PLOTZTZ 00042 MGR 00007 18352.80 00000.00 00110 NGAN 00015 CLERK 00005 12508.20 00206.60 00120 NAUGHTON 00038 CLERK 00000 12954.75 00180.00 -------------------------------- MORE .... ------------------------------------ <PF1> HELP <PF2> RETURN <PF3> TOTALS ONLY <PF4> DETAIL <PF5> NO TOTALS <PF6> STATS <PF7> BACKWARD <PF8> FORWARD <PF9> NOT USED <PF10> NOT USED <PF11> LEFT <PF12> RIGHT
Result
=> DQ154I - THE TABLE WAS SAVED ALONG WITH THE ROWS SELECTED BY YOUR QUERY ------------------------------------------------------------------------DQTB0 DATAQUERY: STORE COMMAND STORE STAFF3 (1) ----------------------------------------------------------------------------- (1) Enter a name for the table to be created which is unique for your private SQL Authorization ID. Press <ENTER> to create the table. ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN
|
Copyright © 2014 CA.
All rights reserved.
|
|