Examples of Batch

Displaying reports:

This example displays those employees whose employee ID numbers are less than or equal to 40.

Input:
SET USER ABC PASS ABCPASS
SET ACCESS OLQ
SIGNON DICT=TESTDICT SS=EMPSS01  DBN=EMPDEMO
SELECT * FROM EMPLOYEE WHERE EMP-ID-0415 LE 40 ORDER BY EMP-LAST-NAME-0415
DISPLAY COLS EMP-ID-0415 EMP-LAST-NAME-0415

Output page 1:
        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 EMPLOYEE WHERE EMP-ID-0415 LE 40
OLQ 098006 00 18 Whole lines and 0 partial lines in report.
OLQ 098007 00 18 Records read. 18 Records selected.
DISPLAY COLS EMP-ID-0415 EMP-LAST-NAME-0415

Output page 2:

                   EMPLOYEE.REPORT

EMP-ID-0415  EMP-LAST-NAME-0415
   7           BANK
  40           CRANE
  24           DOUGH
  32           FERNDALE
  29           GALLWAY
   3           GARFIELD
  28           GRANGER
  27           HEAROWITZ
  30           HENDON
  20           JACOBI
  19           JENSEN
  11           JENSON
  16           KLEWELLEN
  31           LIPSICH
  35           LITERATA
  15           MAKER
  23           O'HEARN
  12           PEOPLES
  21           TYRO