set-null Print this Topic Previous Page Up One Level Next page

Home >  Functions > Function Library Reference > db >


Used to set a database column to null. This function will also overwrite a default value with null. If connected to something else i.e. not a database field, it will behave like an empty sequence.


Please note:


Connecting set-null to a different function will usually result in the other function not being called at all. Connecting set-null to a sequence function, e.g. count, will call the function with an empty sequence.
Connecting to special functions, Filters and IF-Else conditions works as expected, fields are set to null. For filters this means the "node/row" input.
Using set-null as an input for a simpleType element will not create that element in the target component.

© 2019 Altova GmbH