SQL Query operation does not distinguish NULL and 'null' string values

  • Document ID:KM02143709
  • Creation Date:22-Feb-2016
  • Modified Date:14-May-2021
    • Micro Focus Products:
      operations orchestration

Summary

SQL Query operation does not distinguish NULL and 'null' string values

Question

Does 'SQL Query' operation under Library/Operations/Databases/JDBC distinguish NULL(empty) and 'null' string values?

Answer

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'.