PASSW

#### Search Results

Search

# PASSW

`PASSW=`operand1

This document covers the following topics:

- Function

- Restriction

- Syntax Description

- Example

Related Statements: `ACCEPT/REJECT` | `AT BREAK` | `AT START OF DATA` | `AT END OF DATA` | `BACKOUT TRANSACTION` | `BEFORE BREAK PROCESSING` | `DELETE` | `END TRANSACTION` | `FIND` | `HISTOGRAM` | `GET` | `GET SAME` | `GET TRANSACTION` | `LIMIT` | `PERFORM BREAK PROCESSING` | `READ` | `RETRY` | `STORE` | `UPDATE`

Belongs to Function Group: Database Access and Update

## Function

The `PASSW` statement is used to specify a default password for access to Adabas or VSAM files which have been password-protected.

Note
This password can be overwritten using the `PASSWORD` clause of the database access statements `FIND`, `GET`, `HISTOGRAM`, `READ`, `STORE`.

### Natural Security Considerations

In the security profile of a library, you can specify a default Adabas password (as described in the Natural Security documentation); this password applies to all database access statements for which neither an individual password is specified nor a `PASSW` statement applies. It applies within the library in whose security profile it is specified, and also remains in effect in other libraries you subsequently log on to and in whose security profiles no password is specified.

### Password Display Protection

If the password is specified as a constant, the `PASSW` statement should always be coded at the very beginning of a source-code line, and there should be no blank between the keyword `PASSW` and the equal sign; this ensures that the password is not visible/displayable in the source code of the program.

In TP mode: | You may enter the `PASSW` statement invisible by entering the terminal command `%*` before you type in the `PASSW` statement.
In batch mode: | A password may be provided by specifying the following statements in the line editor:
    EDT

     PASSW='password'
     END

    .E
    RUN
The password value will not appear in the printed output.

## Restriction

This statement is not valid for Db2 databases.

## Syntax Description

Operand Definition Table:

Operand | Possible Structure | Possible Formats | Referencing Permitted | Dynamic Definition
--- | --- | --- | --- | ---
`operand1` | C | S |  |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  | yes | no

Syntax Element Description:

Syntax Element | Description
--- | ---
`operand1` | Password: The password (`operand1`) may be specified as an alphanumeric constant or the content of an alphanumeric variable. It may consist of up to 8 characters, and must not contain special characters or embedded blanks. If the password is specified as a constant, it must be enclosed in apostrophes. The password specified with the `PASSW` statement applies to all database access statements (`FIND`, `GET`, `HISTOGRAM`, `READ`, `STORE`) for which no individual password is specified. It remains in effect until another password is specified in the execution of a subsequent `PASSW` statement or the Natural session is terminated. A password specified with a specific database access statement applies only to that statement, not to any subsequent statement.

## Example

Example Program `PWDEX1` with Password Display Protection (see above):

    ** Example 'PWDEX1': PASSW
    ************************************************************************
    DEFINE DATA LOCAL
    1 EMPLOY-VIEW VIEW OF EMPLOYEES
      2 PERSONNEL-ID
      2 NAME
    END-DEFINE
    *
    PASSW=                          Password not visible
    *
    LIMIT 5
    READ EMPLOY-VIEW
     DISPLAY NOTITLE PERSONNEL-ID NAME
    END-READ
    *
    END

#### Output of Program PWDEX1:

    PERSONNEL         NAME
       ID
    --------- --------------------

    50005800  ADAM
    50005600  MORENO
    50005500  BLOND
    50005300  MAIZIERE
    50004900  CAOUDAL

### On this page

- Function
- Restriction
- Syntax Description
- Example