Overriding Default Passwords in Specific Files

In this section:

SET PASSWORD Examples

Passwords for ADABAS files can be set from the command line or a FOCEXEC in FOCUS using the SET PASSWORD command. You can set default passwords for all files and/or databases. Specific passwords can be set for specific files which will override the default. The SET command overrides the password coded in the Access File.

The SET PASSWORD command remains valid throughout the FOCUS session.

The syntax is

ENGINE ADBSINX SET PASSWORD {OFF|password|DEFAULT} FILENO {ALL|fileno} DBNO {ALL|dbno}
ENGINE ADBSINX SET PASSWORD OFF
ENGINE ADBSINX SET PASSWORD DEFAULT

where:

password: Is the password, which can be from one to eight characters in length.
FILENO: Specifies the file number for which the password is set.
DBNO: Specifies the database or databases for which the password is set.
ALL: Indicates all files and/or databases used with the FILENO and DBNO parameters. If you want to use ALL for both FILENO and DBNO, issue this command before any other subsequent password commands. ALL overrides any prior settings.
dbno: Is any valid numeric database value between 0 and 255. The DBNO parameter indicates the actual database number.
fileno: Provides a file number, a list of file numbers, and/or a range of file numbers used with the FILENO parameter. Numbers and ranges can be combined by separating items with commas. Valid file numbers range between 0 and 255.
OFF: Clears all previous ADBSINX SET PASSWORD commands. The adapter does not use any passwords specified in the Access File. This command lets you access only those files that have no password security.
DEFAULT: Clears all previous ADBSINX SET PASSWORD commands and causes the adapter to use the password in the Access File.

To set a default password:

Issue the SET PASSWORD command using the ALL keyword for FILENO and/or DBNO.
Issue specific password requests by specifying particular file and/or database numbers (or ranges) in a subsequent SET PASSWORD command.

Note that subsequent requests are appended to previous requests. Changes are cumulative. The passwords can be issued from a FOCEXEC, which may be encrypted. Refer to the Describing Data manual for more information on encryption.

Top of page

SET PASSWORD Examples

To set a default password to MARY for all databases and all files, issue the following command:

ENGINE ADBSINX SET PASSWORD MARY FILENO ALL DBNO ALL

To set the password to DAN for all files in database number 150, issue the following command:

ENGINE ADBSINX SET PASSWORD DAN FILENO ALL DBNO 150

To set the password to BRUCE for specific files in database number 123, issue the following command:

ENGINE ADBSINX SET PASSWORD BRUCE FILENO 1,3-5,23,89-93 DBNO 123

To clear all previous ADBSINX SET PASSWORD commands, only allowing the user to access the files that have no password security, issue the following command:

ENGINE ADBSINX SET PASSWORD OFF

To clear all previous ADBSINX SET PASSWORD commands, causing the adapter to use the password in the Access File, issue the following command:

MVS ADBSINX SET PASSWORD DEFAULT

Information Builders