Please enable JavaScript to view this site.

Altova MapForce 2020 Professional Edition

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