Using Program DBFIND to Search Multiple View Reports for a Text String.

Document ID : KB000054156
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

Program DBFIND provides the capability to search multiple reports, on DASD in a View database, for a string of characters.

Solution

It is possible to search multiple reports that reside on DASD in a View database for a string of characters using the SARSAM program DBFIND.

Here are the View 11.0 elements necessary for the function:

  • PTF QO88602

  • DBFIND is a program to demonstrate how CA-View's Database Access Method (SARSAM) can be used to retrieve specialized information from reports that are on the primary DASD of the database.

  • PTF QI88569

  • JCL used to run the DBFIND function:
     //STEP1      EXEC PGM=DBFIND,PARM='VIEW.DB1';     <=== Modify DB name
     //STEPLIB    DD DISP=SHR,DSN=VIEW.CAILIB          <=== Modify, if used
     //SYSPRINT DD SYSOUT=*                          
     //SYSIN      DD *                                 
     /control cards                                  
     /*
  • Control card format:

       /FIND ID=report_id VALUE='string'

       Where:

       ID       - is the Report ID to be searched.
                    It may specify a trailing wildcard(*).
                   ID=* will search all reports.

       VALUE - is the character string used to search each specified report data line.
                      Only reports which are resident on primary DASD will be searched.

NOTE: If security is implemented on the database, the user must have Read access to any report that will be searched.