PASSW= operand1
|
This document covers the following topics:
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
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
.
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.
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 RUNThe password value will not appear in the printed output. |
This statement is not valid for DL/I and DB2 databases.
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
( The password specified with the A password specified with a specific database access statement applies only to that statement, not to any subsequent statement. |
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
PERSONNEL NAME ID --------- -------------------- 50005800 ADAM 50005600 MORENO 50005500 BLOND 50005300 MAIZIERE 50004900 CAOUDAL