STORE Data

Use the STORE command during display of query or dialog output to create a new personal table, complete with data. The correct format for the command is:

STORE table-name

Use a unique table name for the new table. 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.

Example

Enter the STORE command during output display:

 => store\testtbl
 DQ471I - ROWS FOUND: 000037
05/01/11                       DATAQUERY DEVELOPMENT                       PAGE     1
15:53:49                           EMPLOYEE REPORT                        DETAIL

    
                                TOTAL
  DEPARTMENT      YRS    COMPENSATION
  ----------  -------  --------------
          7        7      $18,647.30

  MAXIMUM YRS             7

          10      10      $20,010.00
                   7      $22,959.20
                   5      $19,260.25
                  12      $21,234.25

  MAXIMUM YRS            12

 -------------------------------- 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

Press Enter and see the following display.

 =>
DQ154I - THE TABLE WAS SAVED ALONG WITH THE ROWS SELECTED BY YOUR QUERY
 --------------------------------------------------------------------------DQTB0
 DATAQUERY:  STORE COMMAND

 STORE  TESTTBL
            (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

Access the new table just as you would any other personal table.