Purpose
The DQL Mode EXTRACT command creates a data table of the found set produced by executing a query. The data table can be used by other CA products such as CA Ideal, or by programs written at your site. The data table created cannot be used by CA Dataquery. Since the data base table is subject to database maintenance, the contents of the extracted data table may become outdated.
The size of an EXTRACT data set can be limited by the CA Dataquery Administrator. The size of the SET statement result can be limited in the System Option Table, causing the result to be zero (0). See the CA Dataquery Administrator about EXTRACT limits and see the CA Dataquery User Guide for additional information about sets and EXTRACT.
When to Use It
When you want to save the results of a query or dialog so it can be accessed by other programs.
Syntax
|
Enter |
With |
When You Want to: |
|---|---|---|
|
EXTRACT |
No operand |
Display the Extract Active Found Set panel to save a found set produced by executing a query. |
Example
=> EXTRACT 01/04/2010 DATAQUERY SAMPLE PAGE 14 13:01:47 DETAIL ORD-ID ITM-ID SHIP-QTY UNIT-PRICE AMT-SHIP ------ ---------- -------- ---------- -------------- 01008 C10000 0000002 00029.50 $59.00 C10001 0000004 00021.00 $84.00 C10002 0000006 00014.00 $84.00 C10005 0000002 00066.75 $133.50
Result
=> Enter set attributes and press PF3 to extract ------------------------------------------------------------------------DQA90 DATAQUERY: EXTRACT ACTIVE FOUND SET NAME: ________ PASSWORD: _________ DESCRIPTION: ______________ ---------------------------------------------------------------------------- ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> SAVE
|
Copyright © 2014 CA.
All rights reserved.
|
|