Self-Solve Knowledge Search

Minimize Maximize
SQL Query operation does not distinguish NULL and 'null' string values
Title :
SQL Query operation does not distinguish NULL and 'null' string values
Document ID :
KM02143709
Product - Version:
operations orchestration ;
OS :
Updated :
Mon Feb 22 07:54:19 GMT 2016
Summary :
SQL Query operation does not distinguish NULL and 'null' string values
Does 'SQL Query' operation under Library/Operations/Databases/JDBC distinguish NULL(empty) and 'null' string values?
Solution
Currently 'SQL Query' operation that is located under Library/Operations/Databases/JDBC in a base CP for OO 10.x and a CP for OO 9.x does not distinguish NULL(empty) and 'null' string values. Each value that is returned from the operation appears as 'null'.