Use the SQLMAINT option of the Interactive SQL Service Facility to maintain the CA Datacom Datadictionary source and output members. This section explains how to edit, execute, display, delete, and copy the source members in CA Datacom Datadictionary. It also explains how you display and delete output members using this option.
The source and output members are saved by CA Datacom Datadictionary in a Virtual Library System (VLS) member (the VLS is a library access method used to store panels, message members, control blocks, and user programs). The VLS is one of the CA IPC. The name of the VLS member is specified in the System Resource Table parameter DDOLSQL= (in the DDSYSTBL macro).
Note: For more information about DDOLSQL=, see the CA Datacom/DB Database and System Administration Guide. For more information on the Virtual Library System and the VLS Utility (VLSUTIL) that enables you to modify and maintain the VLS files at your site, see the CA IPC Implementation Guide.
When you select option 1 (SQLMAINT) on the Interactive SQL Service Facility panel, CA Datacom Datadictionary displays the following panel:
=> => => ------------------------------------------------------------------------------- Interactive SQL Service Facility SQLMAINT Enter desired option number ===> __ (There are 05 options on the menu) 1. EDIT Edit/Execute SQL members 2. DISPLAY Display source/output members 3. DELETE Delete source/output members 4. COPY Copy source members 5. END End SQLMAINT processing
Enter the number for the option you want to use and press Enter. CA Datacom Datadictionary displays the SQL Member Selection Criteria Fill-in Panel. The panel displays the option at the left of the panel and the fields needed for processing.
|
Copyright © 2014 CA.
All rights reserved.
|
|