Element: dbstructure.distinct

Type

numeric

Description

Whether or not duplicate rows are to be eliminated when a dbstructure object is mapped to the database. A value of 1 implies that the mapping is distinct. A value of 0 (the default) implies that it is not. At database lookup time, this element corresponds to the SQL SELECT keyword DISTINCT. Its value is set by the -dis switch at dbstructure definition time.

This element is read-only and cannot be changed.

Examples

Both ~test.dbpipe.distinct and allpipes.distinct will have the value 1.

database ~global.net, -n='uk_net'
dbstructure ~test.dbpipe, ~global.net, 'pipes',-dis
~test.dbpipe allpipes[ ]

See Also