Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

Statement 1P4


You use this statement to specify the last value in the range of primary keys or primary-key groups whose first value was specified in a preceding 1P3 statement.

You can specify the primary-key value in printable form or hexadecimal notation (see the 1P3 statement). Ranges of primary keys or primary-key groups in 1P3/1P4 statements must not overlap.


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


primary-key-value

Last value in the range of primary keys

primary-key-group-value

Last value in the range of primary-key groups

x

Flag indicating there is a follow-up statement (analogous to the 1P3 follow-up statement)


Example

The primary-key values in the range from ALPHA to BETA can only be read:


1P3'BLANK''BLANK'1'BLANK'ANTON

1P4'BLANK''BLANK''BLANK''BLANK' BERTA