set-null

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Functions > Function Library Reference > db >

set-null

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.

fn-setnull

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