Version 8.1.4
 —  DBA Reference Summary  —

Adabas Utilities

Utility Function Use to...
ADAACK ACCHECK Check the address converter for a specific file or range of files or for a specific ISN or range of ISNs.
ADACDC Produce a file containing the delta of all changes made to the database over the period covered by the input protection logs. You can also use this utility to produce a file that lists each individual insert and delete transaction made to the database over the period covered by the input protection logs (without producing a delta of these changes).
ADACMP COMPRESS Edit and compress data records that are to be loaded into the database.
ADACMP DECOMPRESS Decompress individual files in the Adabas database.
ADACNV CONVERT Convert a database to higher Adabas version.
ADACNV REVERT Revert a database to a lower Adabas version.
ADADBS ADD Add a new data set to the Associator or Data Storage.
ADADBS ALLOCATE Allocate an extent of a specific size for an address converter, Data Storage, or normal or upper index.
ADADBS CHANGE Change the standard length or format of a field.
ADADBS CVOLSER Print the Adabas file extents on a given volume.
ADADBS DEALLOCATE Deallocate a file extent for an address converter, Data Storage, or normal index or upper index.
ADADBS DECREASE Decrease the size of the last data set currently being used for the Associator or Data Storage.
ADADBS DELCP Delete checkpoint records.
ADADBS DELETE Delete a file from a database.
ADADBS DSREUSE Activate or deactivate the reuse of Data Storage blocks for a file.
ADADBS ENCODEF Change the file encoding of a file.
ADADBS INCREASE Increase the size of the last data set currently being used for the Associator or Data Storage.
ADADBS ISNREUSE Reuse ISNs in a database.
ADADBS MODFCB Modify various parameters for a non-system Adabas file.
ADADBS MUPEX Set the maximum count for MU and PE fields in a database.
ADADBS NEWFIELD: Add one or more fields to a file.
ADADBS ONLINVERT Start an online invert process.
ADADBS ONLREORFASSO Start an online process to reorder the Associator of specified files.
ADADBS ONLREORFDATA Start an online process to reorder the Data Storage of specified files.
ADADBS ONLREORFILE Start an online process to reorder the Associator and Data Storage of specified files.
ADADBS OPERCOM Issue operator commands to the Adabas nucleus.
ADADBS PRIORITY Set or change the Adabas priority of a user.
ADADBS RECORDSPANNING Enable or disable record spanning for a file.
ADADBS RECOVER Recover allocated space by rebuilding the free space table (FST).
ADADBS REFRESH Set a file to empty status.
ADADBS REFRESHSTATS Reset the statistical values maintained by the Adabas nucleus for its current session.
ADADBS RELEASE Release a descriptor from the descriptor space.
ADADBS RENAME Rename a file or database.
ADADBS RENUMBER Change the number of a file in the database.
ADADBS REPLICATION Activate or deactivate replication for an Adabas database file.
ADADBS REPTOR Activate, deactivate, open, or close an Event Replicator for Adabas resource.
ADADBS RESETDIB Reset entries in the active utility list.
ADADBS RESETPPT Resets the PPT blocks on the Associator data set.
ADADBS SPANCOUNT Count and display the number of records in a file that are spanned.
ADADBS TRANSACTIONS Suspend and resume update transaction processing for the database.
ADADBS UNCOUPLE Uncouple files in the database.
ADADCK DSCHECK Check Data Storage and the Data Storage space table (DSST) of specified files in the database.
ADADEF DEFINE Define a database and checkpoint file.
ADADEF MODIFY Change field encodings.
ADADEF NEWWORK Define a Work file.
ADAFRM Format Adabas database components.
ADAICK ACCHECK Check the address converter of a specified database file.
ADAICK ASSOPRINT Print and dump Associator blocks.
ADAICK BATCH Set the printout width to 132 characters per line.
ADAICK DATAPRINT Print and dump Data Storage blocks for specified RABNs.
ADAICK DSCHECK Print and dump the content of Data Storage records in a file.
ADAICK DUMP Request that blocks be printed in dump format.
ADAICK FCBPRINT Print and dump the file control block (FCB) of a file.
ADAICK FDTPRINT Print and dump the field definition table of a file.
ADAICK GCBPRINT Print and dump the general control blocks (GCBs).
ADAICK ICHECK Check the index against the address converter.
ADAICK INT Request that blocks be printed in interpreted print format.
ADAICK NIPRINT Print and dump the normal index for a file.
ADAICK NOBATCH Set the print width to 80 characters per line.
ADAICK NODUMP Suppress dump print format.
ADAICK NOINT Suppress interpreted print format.
ADAICK PPTPRINT Print and dump the parallel participant table (PPT).
ADAICK UIPRINT Print and dump the upper index for a file.
ADAINV COUPLE Define one descriptor for each of two files to be coupled.
ADAINV INVERT Create descriptors, subdescriptors, superdescriptors, hyperdescriptors, phonetic descriptors or collation descriptors for existing fields in a file.
ADALOD LOAD Load a file into the database.
ADALOD UPDATE Add or delete a large number of records (ISNs) to or from an existing file.
ADAMER Run the ADAM estimation. This utility produces statistics that indicate the number of Data Storage accesses required to find and read a record when using an ADAM descriptor.
ADAORD REORASSO Reorder the Associator.
ADAORD REORDATA Reorder Data Storage.
ADAORD REORDB Reorder the database.
ADAORD REORFASSO Reorder the Associator for a single file.
ADAORD REORFDATA Reorder Data Storage for a single file.
ADAORD REORFILE Reorder a file.
ADAORD RESTRUCTUREDB Restructure the database.
ADAORD RESTRUCTUREF Restructure single files.
ADAORD STORE: Store Files Load one or more files into an existing database using output produced by the ADAORD RESTRUCTURE functions.
ADAPLP Print data protection records from the protection log (PLOG) or Work data sets.
ADAPRI Print the contents of a block (or range of blocks) contained in the Associator, Data Storage, Work, temp, sort, multiple data set command log, multiple data set protection log, or the recovery log data set.
ADARAI CHKDB Check that the recovery status of the nucleus is the status specified by the CHKDB function (active or inactive).
ADARAI DISABLE Disable recovery logging by setting the RLOG table (control block) to inactive status.
ADARAI LIST View the recovery log contents in table form.
ADARAI PREPARE Initialize and start recovery logging to the recovery log.
ADARAI RECOVER Build a recovery job stream for recovering the Adabas database or selected database files.
ADARAI REMOVE Disable recovery logging by updating the Associator GCBs to indicate that recovery logging (that is, the Recovery Aid) is no longer active in the database, and that information will no longer be recorded in the recover log (RLOG).
ADAREP Request a database status report.
ADARES BACKOUT SIBA Back out updates applied between two specified checkpoints using the sequential protection log (SIBA).
ADARES BACKOUT DPLOG or MPLOG Back out updates applied between two checkpoints contained on the same dual or multiple protection log.
ADARES CLCOPY Copy the dual command log.
ADARES COPY Copy a sequential protection log or save tape.
ADARES MERGE CLOG Merge nucleus cluster command logs.
ADARES PLCOPY Copy protection log data to a sequential data set.
ADARES REGENERATE Reapply all the updates performed between two checkpoints.
ADARES REPAIR Repair one or more Data Storage blocks, using the protection log and the output of the ADASAV utility.
ADASAV RESTONL Restore a database from a database SAVE data set created while the Adabas nucleus was active.
ADASAV RESTONL FILES Restore files to their original RABNs in an existing database. Files are restored from a file or database SAVE data set created while the Adabas nucleus was active.
ADASAV RESTONL FMOVE Restore files to any free space in an existing database. Files are restored from a file or database SAVE data set created while the Adabas nucleus was active.
ADASAV RESTONL GCB Restore the general control blocks (GCBs), Associator RABNs 3-30 of the database, the checkpoint file, the security file (if present), and all specified files. These file structures are restored from a database SAVE data set created while the Adabas nucleus was active.
ADASAV RESTORE Restore a database from a database SAVE data set created while the Adabas nucleus was inactive.
ADASAV RESTORE FILES Restore files to their original RABNs in an existing database. Files are restored from a file or database SAVE data set created while the Adabas nucleus was inactive.
ADASAV RESTORE FMOVE Restore files to any free space in an existing database. Files are restored from a file or database SAVE data set created while the Adabas nucleus was inactive.
ADASAV RESTORE GCB Restore the general control blocks (GCBs), Associator RABNs 3-30 of the database, the checkpoint file, the security file (if present), and all specified files. These file structures are restored from a database SAVE data set created while the Adabas nucleus was inactive.
ADASAV RESTPLOG Restore changes contained in the protection log (PLOG) to the already restored database or files.
ADASAV SAVE Save the contents of the database to a sequential data set.
ADASAV SAVE FILES Save the contents of one or more files to a sequential data set.
ADASEL Select and decompress information in the Adabas sequential (SIBA) or dual/multiple (PLOG) protection log and write it to a print data set (DDDRUCK/ DRUCK) or a user-specified output data set.
ADAULD UNLOAD FILE Unload a specified Adabas file.
ADAVAL Validate any or all files within an Adabas database except the checkpoint and security files.
ADAWRK Produce reports from records in the autorestart area of Work part 1. This information can be used when the database autostart fails and the database will not come up. It can help you determine how to handle database recovery.
ADAZAP Display (in hexadecimal format) and optionally change the contents of the Associator, Data Storage, or Work data sets.
Field Definition Statements Define or modify a field definition. Field definition statements can be specified in various Adabas utility functions.

ADAACK ACCHECK: Check Address Converter Against Data Storage

graphics/util_adaack_accheck.png

Top of page

ADACDC: Capture Delta Changes

graphics/util_adacdc.png

Top of page

ADACMP COMPRESS: Compress an Adabas File

graphics/util_adacmp_compress.png

Top of page

ADACMP DECOMPRESS: Decompress Adabas Files

graphics/util_adacmp_decompress.png

Top of page

Field Definition Statements

The following syntax must be followed when entering field definitions. A minimum of one and a maximum of 926 definitions may be specified.

Statement Type Syntax
Field and Group

graphics/util_fndef_fld.png

Periodic Group

graphics/util_fndef_grp.png

Collation descriptor

graphics/util_colde.png

Hyperdescriptor

graphics/util_hypde.png

Phonetic descriptor

graphics/util_phonde.png

Subdescriptor

graphics/util_subde.png

Subfield

graphics/util_subfn.png

Superdescriptor

graphics/util_supde.png

Superfield

graphics/util_supfn.png

User comments may be entered to the right of each definition. At least one blank must be present between a definition and any user comments.

Top of page

ADACNV CONVERT: Convert a Database to Higher Version

graphics/util_adacnv_convert.png

Top of page

ADACNV REVERT: Revert a Database to Lower Version

graphics/util_adacnv_revert.png

Top of page

ADADBS ADD: Add Data Set

graphics/util_adadbs_add.png

Top of page

ADADBS ALLOCATE: Allocate File Extent

graphics/util_adadbs_allocate.png

Top of page

ADADBS CHANGE: Change Standard Length or Format of a Field

graphics/util_adadbs_change.png

Top of page

ADADBS CVOLSER: Print Adabas Extents on Given Volume

graphics/util_adadbs_cvolser.png

Top of page

ADADBS DEALLOCATE: Deallocate File Extent

graphics/util_adadbs_deallocate.png

Top of page

ADADBS DECREASE: Decrease Last Associator or Data Storage Data Set Size

graphics/util_adadbs_decrease.png

Top of page

ADADBS DELCP: Delete Checkpoint Records

graphics/util_adadbs_delcp.png

Top of page

ADADBS DELETE: Delete File

graphics/util_adadbs_delete.png

Top of page

ADADBS DSREUSE: Reuse Data Storage Blocks

graphics/util_adadbs_dsreuse.png

Top of page

ADADBS ENCODEF: Change File Encoding

graphics/util_adadbs_encodef.png

Top of page

ADADBS INCREASE: Increase Last Associator or Data Storage Data Set Size

graphics/util_adadbs_increase.png

Top of page

ADADBS ISNREUSE: Reuse ISNs

graphics/util_adadbs_isnreuse.png

Top of page

ADADBS MODFCB: Modify File Parameters

graphics/util_adadbs_modfcb.png

Top of page

ADADBS MUPEX: Set Maximum Count for MU and PE Fields

graphics/util_adadbs_mupex.png

Top of page

ADADBS NEWFIELD: Add New Field

graphics/util_adadbs_newfield.png

Top of page

ADADBS ONLINVERT: Start Online Invert Process

graphics/util_adadbs_onlinvert.png

Top of page

ADADBS ONLREORFASSO: Start Online Reorder Associator for Files

graphics/util_adadbs_onlreorfasso.png

Top of page

ADADBS ONLREORFDATA: Start Online Reorder Data for Files

graphics/util_adadbs_onlreorfdata.png

Top of page

ADADBS ONLREORFILE: Start Online Reorder Associator and Data for Files

graphics/util_adadbs_onlreorfile.png

Top of page

ADADBS OPERCOM: Issue Adabas Operator Commands

graphics/util_adadbs_opercom.png

Operator Commands Supported by ADADBS OPERCOM

The following Adabas operator commands can be used in the ADADBS OPERCOM utility function:

Top of page

ADADBS PRIORITY: Change User Priority

graphics/util_adadbs_priority.png

Top of page

ADADBS RECORDSPANNING: Enable or Disable Record Spanning

graphics/util_adadbs_recordspanning.png

Top of page

ADADBS RECOVER: Recover Space

graphics/util_adadbs_recover.png

Top of page

ADADBS REFRESH: Set File to Empty Status

graphics/util_adadbs_refresh.png

Top of page

ADADBS REFRESHSTATS: Reset Statistical Values

graphics/util_adadbs_refreshstats.png

Top of page

ADADBS RELEASE: Release Descriptor

graphics/util_adadbs_release.png

Top of page

ADADBS RENAME: Rename a File or Database

graphics/util_adadbs_rename.png

Top of page

ADADBS RENUMBER: Change File Number

graphics/util_adadbs_renumber.png

Top of page

ADADBS REPLICATION: Activating or Deactivating Replication

graphics/util_adadbs_replication.png

Top of page

ADADBS REPTOR: Activating, Deactivate, Open or Close an Event Replicator for Adabas Resource

graphics/util_adadbs_reptor.png

Top of page

ADADBS RESETDIB: Reset Entries in Active Utility List

graphics/util_adadbs_resetdib.png

Top of page

ADADBS RESETPPT: Reset PPT Blocks

graphics/util_adadbs_resetppt.png

Top of page

ADADBS SPANCOUNT: Count Spanned Records

graphics/util_adadbs_spancount.png

Top of page

ADADBS TRANSACTIONS: Suspend and Resume Update Transaction Processing

graphics/util_adadbs_transactions.png

Top of page

ADADBS UNCOUPLE: Uncouple Files

graphics/util_adadbs_uncouple.png

Top of page

ADADCK DSCHECK: Check Data Storage and DSST

graphics/util_adadck_dscheck.png

Top of page

ADADEF DEFINE: Define a Database and Checkpoint File

graphics/util_adadef_define.png

Top of page

ADADEF MODIFY: Change File Encodings

graphics/util_adadef_modify.png

Top of page

ADADEF NEWWORK: Define a Work File

graphics/util_adadef_newwork.png

Top of page

ADAFRM: Format Adabas Database Components

To format the Associator (ASSO) or Data Storage (DATA) data sets, use this syntax:

graphics/util_adafrm_assofrm.png

To format the Work (WORK), command log (CLOG), protection log (PLOG), or sort (SORT) data sets, use this syntax:

graphics/util_adafrm_workfrm.png

To format the recovery log (RLOG), use this syntax:

graphics/util_adafrm_rlogfrm.png

To format the Temp (TEMP) data set, use this syntax:

graphics/util_adafrm_tempfrm.png

To reformat blocks of an existing Associator, Data Storage, or Work data set, use this syntax:

graphics/util_adafrm_assoreset.png

Top of page

ADAICK ACCHECK: Check Address Converter

graphics/util_adaick_accheck.png

Top of page

ADAICK ASSOPRINT: Print/Dump Associator Blocks

graphics/util_adaick_assoprint.png

Top of page

ADAICK BATCH: Set Printout Width to 132 Characters Per Line

graphics/util_adaick_batch.png

Top of page

ADAICK DATAPRINT: Print/Dump Data Storage Blocks

graphics/util_adaick_dataprint.png

Top of page

ADAICK DSCHECK: Print/Dump Content of Data Storage Record

graphics/util_adaick_dscheck.png

Top of page

ADAICK DUMP: Activate Dump Print Format

graphics/util_adaick_dump.png

Top of page

ADAICK FCBPRINT: Print/Dump File Control Block

graphics/util_adaick_fcbprint.png

Top of page

ADAICK FDTPRINT: Print/Dump Field Definition Table

graphics/util_adaick_fdtprint.png

Top of page

ADAICK GCBPRINT: Print/Dump General Control Blocks

graphics/util_adaick_gcbprint.png

Top of page

ADAICK ICHECK: Check Index Against Address Converter

graphics/util_adaick_icheck.png

Top of page

ADAICK INT: Activate Interpreted Print Format

graphics/util_adaick_int.png

Top of page

ADAICK NIPRINT: Print/Dump Normal Index

graphics/util_adaick_niprint.png

Top of page

ADAICK NOBATCH: Set Print Width to 80 Characters Per Line

graphics/util_adaick_nobatch.png

Top of page

ADAICK NODUMP: Suppress Dump Print Format

graphics/util_adaick_nodump.png

Top of page

ADAICK NOINT: Suppress Interpreted Format

graphics/util_adaick_noint.png

Top of page

ADAICK PPTPRINT: Print/Dump Parallel Participant Table

graphics/util_adaick_pptprint.png

Top of page

ADAICK UIPRINT: Print/Dump Upper Index

graphics/util_adaick_uiprint.png

Top of page

ADAINV COUPLE: Define File-Coupling Descriptors

graphics/util_adainv_couple.png

Top of page

ADAINV INVERT: Create Descriptors

graphics/util_adainv_invert.png

Top of page

ADALOD LOAD: Load a File

graphics/util_adalod_load.png

Top of page

ADALOD UPDATE: Add/Delete Records

graphics/util_adalod_update.png

Top of page

ADAMER Utility: ADAM Estimation

graphics/util_adamer.png

Top of page

ADAORD REORASSO: Reorder Associator

graphics/util_adaord_reorasso.png

Top of page

ADAORD REORDATA: Reorder Data Storage

graphics/util_adaord_reordata.png

Top of page

ADAORD REORDB: Reorder Database

graphics/util_adaord_reordb.png

Top of page

ADAORD REORFASSO: Reorder Associator for a Single File

graphics/util_adaord_reorfasso.png

Top of page

ADAORD REORFDATA: Reorder Data Storage for a Single File

graphics/util_adaord_reorfdata.png

Top of page

ADAORD REORFILE: Reorder File

graphics/util_adaord_reorfile.png

Top of page

ADAORD RESTRUCTUREDB: Restructure Database

graphics/util_adaord_redb.png

Top of page

ADAORD RESTRUCTUREF: Restructure Single Files

graphics/util_adaord_ref.png

Top of page

ADAORD STORE: Store Files

graphics/util_adaord_store.png

Top of page

ADAPLP: Print Data Protection Records from PLOG/Work

graphics/util_adaplp.png

where type is one of the following:

graphics/util_adaplp_type.png

Top of page

ADAPRI: Print Selected Adabas Blocks

graphics/util_adapri.png

Top of page

ADARAI CHKDB: Check the Database Recovery Status

graphics/util_adarai_chkdb.png

Top of page

ADARAI DISABLE: Deactivate Recovery Logging

graphics/util_adarai_disable.png

Top of page

ADARAI LIST: Display Current RLOG Generations

graphics/util_adarai_list.png

Top of page

ADARAI PREPARE: Initialize and Start the RLOG

graphics/util_adarai_prepare.png

Top of page

ADARAI RECOVER: Build a Recovery Job Stream

graphics/util_adarai_recover.png

Top of page

ADARAI REMOVE: Remove the Recovery Aid

graphics/util_adarai_remove.png

Top of page

ADAREP: Request Database Status Report

graphics/util_adarep.png

Top of page

ADARES BACKOUT SIBA: Back Out Updates Using the Sequential Protection Log (SIBA)

graphics/util_adares_backout_plognum.png

Top of page

ADARES BACKOUT DPLOG or MPLOG: Back Out Updates Using the Dual or Multiple Protection Log

graphics/util_adares_backout_dplog.png

Top of page

ADARES CLCOPY: Copy Dual Command Log

graphics/util_adares_clcopy.png

Top of page

ADARES COPY: Copy a Sequential Protection Log or Save Tape

graphics/util_adares_copy.png

Top of page

ADARES MERGE CLOG: Merge Nucleus Cluster Command Logs

graphics/util_adares_merge.png

Top of page

ADARES PLCOPY: Copy Protection Log to Sequential Data Set

graphics/util_adares_plcopy.png

Top of page

ADARES REGENERATE: Regenerate Updates

graphics/util_adares_regenerate.png

Top of page

ADARES REPAIR: Repair Data Storage Blocks

graphics/util_adares_repair.png

Top of page

ADASAV RESTONL: Restore Database from Online Source

graphics/util_adasav_restonl.png

Top of page

ADASAV RESTONL FILES: Restore Files to Original RABNs from Online Source

graphics/util_adasav_restonl_files.png

Top of page

ADASAV RESTONL FMOVE: Restore Files to Any RABNs from Online Source

graphics/util_adasav_restonl_fmove.png

Top of page

ADASAV RESTONL GCB: Restore Database Incremental from Online Source

graphics/util_adasav_restonl_gcb.png

Top of page

ADASAV RESTORE: Restore Database from Offline Source

graphics/util_adasav_restore.png

Top of page

ADASAV RESTORE FILES: Restore Files to Original RABNs from Offline Source

graphics/util_adasav_restore_files.png

Top of page

ADASAV RESTORE FMOVE: Restore Files to Any RABNs from Offline Source

graphics/util_adasav_restore_fmove.png

Top of page

ADASAV RESTORE GCB: Restore Database Incremental from Offline Source

graphics/util_adasav_restore_gcb.png

Top of page

ADASAV RESTPLOG: Restore Protection Log Only

graphics/util_adasav_restplog.png

Top of page

ADASAV SAVE: Save Database

graphics/util_adasav_save.png

Top of page

ADASAV SAVE FILES: Save Specified Files

graphics/util_adasav_save_files.png

Top of page

ADASEL Utility: Select Protection Data

graphics/util_adasel.png

IF Statement

graphics/util_adasel_if.png

DO Group

graphics/util_adasel_do.png

Value Criterion

graphics/util_adasel_valcrit.png

Output Instruction

graphics/util_adasel_output_instr.png

DISPLAY Statement

graphics/util_adasel_display.png

SET GLOBALS Statement

ADASEL global parameters override default table and buffer sizes. Overrides are in effect only for the ADASEL run in which the SET GLOBALS statement is specified.

If used, SET GLOBALS must be the first ADASEL input statement. Comment statements can precede it. The statement has the following syntax:

graphics/util_set_globals.png

No spaces are permitted between the parameter name, the equal sign, and the value. However, at least one space must separate parameters. Special characters are not permitted as separators. If multiple lines are used, the SET GLOBALS keyword must be repeated on each line. The first non-blank character string that does not begin with a parameter name terminates the SET GLOBALS statement. Thus, trailing comments are not permitted.

ADASEL provides the following global parameters. Default values are underscored.

Parameter Description
LST={len | 12000 }
Length of the statement table, which is used to store the translated ADASEL statements. Depending on its complexity, a statement is translated into one or more segments. Each segment is 44 bytes plus a value length. For example: IF BA EQ 'SMITH'... requires 49 bytes: 44 bytes plus 5 bytes for "SMITH". The default table size (12 ,000 bytes) handles approximately 200 segments. If the table size is exceeded, a SEL003 error occurs.
NCFLD={n | 10}
NCUPD={n | 10}
The maximum count of "field-name CHANGES" statements allowed in the selection query, and the maximum number of parallel updates during the original session. When a statement includes a CHANGES criterion, ADASEL uses a change pool with NCFLD * NCUPD entries to track changed field values. If this pool is too small, a SEL060 error occurs. In this case, it is necessary to increase one or both of the parameters and then rerun ADASEL.
NF={n | 20}
The maximum number of files that can be processed during a single ADASEL run. NF is used to allocate space for the FDT for each file processed. A SEL014 error occurs if the NF value is exceeded. This value is not related to the maximum number of output files (DDEXPAn/ EXPAn); although more than 20 files can be processed during an ADASEL run, a maximum of 20 output files can be written.
NIF={n | 20}
Number of nested IF levels permitted.
NOUSERABEND
If specified, ADASEL terminates with condition code 20 instead of a user abend 034 after an error is encountered.
NV={n | 100}
Number of field values. NV is used to allocate a table for the evaluation of field values. One entry is required for every field specified in the statements (including duplications). For example, the following statement requires two entries even though the same Adabas field name is used:
IF BA ='SMITH' 
    THEN OUTPUT TO EXPA1
ELSE IF BA ='SMYTH'  
    THEN OUTPUT TO EXPA2
LPV={n | 0}
Length of the PE-value table used in the evaluation of field values for a PE. Normally, ADASEL uses an estimated number of PE occurrences to compute the table size. If the table size is insufficient, a SEL047 error occurs; you can increase the table size using the global LPV parameter as indicated on the screen.
PS={n | 60}
The page size parameter is used to alter the number of lines printed before a new page is started. The minimum page size is 2; the maximum is 999.
LS={n | 80}
The line size parameter is used to alter the number of printed columns. If an output line is longer than the line size, the line is truncated at the nearest blank. The rest of the line is continued on the next output line, beginning in Column 1. The minimum line size is 1; the maximum is 132.

Example

SET GLOBALS LST=15000 NF=15
SET GLOBALS LS=132

Top of page

ADAULD UNLOAD FILE: Unload Specified File

graphics/util_adauld.png

Top of page

ADAVAL Utility: Validate the Database

graphics/util_adaval.png

Top of page

ADAWRK Utility: Work Area Recovery Reports

graphics/util_adawrk.png

Top of page

ADAZAP Utility: Display or Modify Asso, Data, and Work Data Sets

graphics/util_adazap.png

Top of page