Statements 1P3 and 1P3N

You use these statements to assign access authorization for individual records or groups of records in a table.

The records of a table are identified by primary-key values or primary-key-group values.

After a 1P1 statement you can specify either 1P3 statements or 1P3N statements, but not both. You can also use a 1P3/1P3N statement to assign authorization for the primary-key values of records the table does not yet contain but that are to be added subsequently.

The 1P3 statement allows you to assign authorization for an individual record or a group of records in a table.

1P3'BLANK''BLANK'b'BLANK'{ primary-key-value | Gprimary-key-group-value}[x]

The 1P3N statement assigns the access authorization b for all the records in a table except for those specified in the statement.

1P3N'BLANK'[b]{'BLANK'primary-key-value | Gprimary-key-group-value }[x]

b

Type of authorization: 1 for read 2 for update 3 for read and update 4 for delete 5 for read and update 6 for update and delete 7 for read, update and delete The type of authorization must always be specified for the 1P3 statement. If you specify several 1P3N statements after a 1P1 statement, only the first can contain the authorization type. This authorization type then applies to all subsequent 1P3N statements belonging to the same 1P1 statement.

primary-key-value

Specify a primary-key value (up to 64 characters). You can specify it in printable form or hexadecimal notation. For example, the primary-key value P19350 is X'D7F1F9F3F5F0' in hexadecimal notation. If the primary-key value begins with the string X', it must be specified in hexadecimal notation. If the primary key is longer than 64 characters, a follow-up statement is required (see x below). In this case, the primary-key value can only be specified in printable form.

G

The operand G applies access authorization to a primary-key group.

primary-key-group-value

Specify a primary-key-group value (up to 64 characters). It can be entered in printable form or hexadecimal notation. If it is longer than 64 characters, a followup statement is required. In this case, it must be specified in printable form.

x

Flag indicating there is a follow-up statement:
You can use a maximum of 64 characters in a single 1P3/1P3N statement for the primary-key value. If the primary-key value is longer, you must enter a random character “x” as the 65th character. Enter the rest of the primary-key value in one or more follow-up statements.

Structure of a 1P3 follow-up statement, for example: 1P3'BLANK''BLANK''BLANK''BLANK'psw[x]

Each 1P3/1P3N follow-up statement can contain up to 64 characters. If the primarykey value is longer, you again enter the character “x” as the 65th character to indicate that there is a further follow-up statement.

Example

A primary-key value has 200 characters. The character @ is used to indicate there is a 1P3 follow-up statement:

Statement	1P3'BLANK''BLANK'b'BLANK'z...z@	z...z are the first 64 characters of the primary-key value.
1st follow-up statement	1P3'BLANK''BLANK''BLANK''BLANK'z...z@	z...z are the next 64 characters of the primary-key value.
2nd follow-up statement	1P3'BLANK''BLANK''BLANK''BLANK'z...z@	z...z are the next 64 characters of the primary-key value.
3rd follow-up statement	1P3'BLANK''BLANK''BLANK''BLANK'zzzzzzzz	zzzzzzzz are the last 8 characters of the primary-key value.