For an indexed or relative record, unique is set in these cases:
The unique setting is returned only if the access method returns the information, as is true on some operating systems but not on others.
During SQL database access, unique is set when a SQL row being added or replaced has a key that already exists in a unique index. The corresponding sqlcode is -803.
Related reference
add
Association elements
close
delete
Exception handling
execute
get
get next
get previous
Logical expressions
open
prepare
replace
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.