Previous Topic: Example JCL (Output to Disk)Next Topic: FILEIN (Concatenate Input)

EXTRACT (Extract Data Table) › EXTRACT › Sample Report: EXTRACT

Sample Report: EXTRACT

Date: mm/dd/ccyy    ********************************************************************************         Page:     1
                    *                                 CA Datacom/DB                                *
Time: hh.mm.ss      *                                General Utility                               *      Release: 12
                    *                   Copyright © 2009 CA. All rights reserved.                  *               SPnn
                    ********************************************************************************
 
                    CONTROL CARD(S)
                    .........1.........2.........3.........4.........5.........6.........7.........8
       Π           EXTRACT AREA=DEM,DBID=1,DTFNAME=OUT1DD,DEVICE=TAPE,TABLE=POL,SEQ=PHYSICAL
 
                    FUNCTION=EXTRACT
                      AREA=DEM
                       DBID=1
                       DEVICE=TAPE
                       DTFNAME=OUT1DD
                       SEQ=PHYSICAL
                       TABLE=POL
 
       Ž
Œ

The command exactly as entered.



An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.

Ž

Any messages related to syntax processing.

Date: mm/dd/ccyy    ********************************************************************************         Page:     2
                    *                                 CA Datacom/DB                                *
Time: hh.mm.ss      *                                General Utility                               *      Release: 12
                    *                   Copyright © 2009 CA. All rights reserved.                  *               SPnn
                    ******************************************************************************** Directory: PRODCXX
 
                     TABLE          RECORDS
 
                     PNC                 0
                     PNM                 0
                     POH                 0
                    POL                 4
 
                     TOTAL               4


Confirmation that four records were extracted from the requested table.