Writing to a Disk File with SELECT

Batch Processing › Writing to a Disk File with SELECT

Writing to a Disk File with SELECT

This example routes the outcome of a SELECT statement to a disk file. To route your output to an output file, you must:

Set the access switch to olq
Specify the keyword OUTPUT and the name of the output file in your SELECT statement

Example:

To route your output to the OUTFILE output file, issue the following statements:

set access olq
select * from employee
 where emp-id-0415 eq 4500 output outfile

This example creates a sequential file containing departments and the name of each department's manager:

Input:
SET USER ABC PASS ABCPASS
SIGNON SS EMPSS01 DBN=EMPDEMO DICTNAME TESTDICT
SELECT * FROM DEPARTMENT, EMPLOYEE WHERE -
 DEPARTMENT.DEPT-HEAD-ID-0410 EQ EMPLOYEE.EMP-ID-0415 -
 OUTPUT OUTFILE

Output:
        OLQ RELEASE 16.0                  DATE: 96.267 TIME: 11:00 PAGE: 0001
            Copyright (C) 2003 CA, Inc.

OLQ 107017 00  CA OLQ Release 16.0
OLQ 107019 00  Copyright(C) 2003 CA, Inc.
  SET USER ABC PASS ????????
  SIGNON SS EMPSS01 DBN=EMPDEMO DICTNAME TESTDICT

OLQ 100021 00  Ready to retrieve data from subschema IDMSNWKA
OLQ 100022 00  Schema:    EMPSCHM           Version:       1
OLQ 100023 00  Database name:    EMPDEMO
OLQ 100025 00  Dictionary name:  TESTDICT
SELECT * FROM DEPARTMENT, EMPLOYEE WHERE -
OLQ 092022 00  Continuation line accepted
DEPARTMENT.DEPT-HEAD-ID-0410 EQ EMPLOYEE.EMP-ID-0415 -
OLQ 092022 00  Continuation line accepted
OUTPUT OUTFILE
OLQ 149018 00
File name Field name                     Offset   Size Dec no  Data type
OUTFILE   DEPT-ID-0410                     0000   0004   0000   UNSIGNED ZONE
OUTFILE   DEPT-NAME-0410                   0004   0045          CHARACTER
OUTFILE   DEPT-HEAD-ID-0410                0049   0004   0000   UNSIGNED ZONE
OUTFILE   EMP-ID-0415                      0053   0004   0000   UNSIGNED ZONE
OUTFILE   EMP-FIRST-NAME-0415              0057   0010          CHARACTER
OUTFILE   EMP-LAST-NAME-0415               0067   0015          CHARACTER
OUTFILE   EMP-STREET-0415                  0082   0020          CHARACTER
OUTFILE   EMP-CITY-0415                    0102   0015          CHARACTER
OUTFILE   EMP-STATE-0415                   0117   0002          CHARACTER
OUTFILE   EMP-ZIP-FIRST-FIVE-0415          0119   0005          CHARACTER
OUTFILE   EMP-ZIP-LAST-FOUR-0415           0124   0004          CHARACTER
OUTFILE   EMP-PHONE-0415                   0128   0010   0000   UNSIGNED ZONE
OUTFILE   STATUS-0415                      0138   0002          CHARACTER
OUTFILE   SS-NUMBER-0415                   0140   0009   0000   UNSIGNED ZONE
OUTFILE   START-YEAR-0415                  0149   0002   0000   UNSIGNED ZONE
OUTFILE   START-MONTH-0415                 0151   0002   0000   UNSIGNED ZONE
OUTFILE   START-DAY-0415                   0153   0002   0000   UNSIGNED ZONE
OUTFILE   TERMINATION-YEAR-0415            0155   0002   0000   UNSIGNED ZONE
OUTFILE   TERMINATION-MONTH-0415           0157   0002   0000   UNSIGNED ZONE
OUTFILE   TERMINATION-DAY-0415             0159   0002   0000   UNSIGNED ZONE
OUTFILE   BIRTH-YEAR-0415                  0161   0002   0000   UNSIGNED ZONE
OUTFILE   BIRTH-MONTH-0415                 0163   0002   0000   UNSIGNED ZONE
OUTFILE   BIRTH-DAY-0415                   0165   0002   0000   UNSIGNED ZONE