Skip to content

PRM

Gets PRM Options That Are Flags

This system variable returns a four-byte string value with all the PRM options that are flags.

PRM

Each bit of the returned four-byte string corresponds to a different PRM flag. This string may be lengthened in the future if the number of PRM flags exceeds 4 bytes worth of bits. The following bits are currently recognized:

Byte Bit PRM flag
1 $80$ UPPER
1 $40$ DISABLE
1 $20$ ALLOC
1 $10$ ERRMASK
1 $08$ FULL-COMPARE
1 $04$ IF47
1 $02$ LONG-PROMPT
1 $01$ NOROUND
2 $80$ READONLY
2 $40$ OFF-ERR127
2 $20$ SERIAL-EOF
2 $10$ LISTPAREN
2 $08$ DONTCHECKTEXT
2 $04$ SLEEPLOCK
2 $02$ SHORT-ERROR
2 $01$ VAR-NOTSET-ERR
3 $80$ NOTRANS
3 $40$ IEEESWAP
3 $20$ CREATWDBATTR
3 $10$ LOCKBYCHANNEL
3 $08$ ORA-NVLNULLS
3 $04$ ORA-DONTWRITENULLS
3 $02$ SMPLOCK
3 $01$ JOURNALING
4 $80$ EDITPUBLICS
4 $40$ CVTSTRIP
4 $20$ UNIQUE-KEYS
4 $10$ SQL-NUMERIC-NULLS
4 $08$ PIPE_FSTAT_OK
4 $04$ NUMERR26
4 $02$ SQL-NO-SEPARATORS
4 $01$ Reserved for future use

For more information on PRM statements, please refer to the Thoroughbred Basic Customization and Tuning Guide.

This system variable is generally available starting with release level 8.2.

SET PRM directive

From the Thoroughbred Basic Language Reference, Volume II: F–Q, version 8.9.1. Open this page in the PDF