Document toolboxDocument toolbox

VarChar Null and Empty Overlap

Query name

VarChar Null and Empty Overlap

Server Asset Type

Job, Shared Container

Analysis Type

Advisory

Description

Server Jobs differentiating Null and empty strings which requires modifications to achieve in the Parallel engine.

Issue

Your Server Job uses features which differentiate Null and empty string but which are not available in the Parallel engine. You can find a deeper explanation at Differences between Server and Parallel VarChar.

Actions

This is an advisory Asset Query only, but you may choose to modify your Job(s) to use Parallel-native features and functions to achieve the differentiation you require.

© 2015-2024 Data Migrators Pty Ltd.