IBM Support

Is VARCHAR data type supported in InfoSphere Information Server Information Analyzer Column Analysis?

Question & Answer


Question

In InfoSphere Information Analyzer is it possible to use VARCHAR(MAX)?

Answer

The VARCHAR data type using the max keyword is not supported in Information Analyzer. The MAX value equates to very large number and effectively maps this data type into a LONGVARCHAR ODBC data type when imported and processed by the ODBC connector in Information Server. That is why these VARCHAR(max) columns are imported with a length of zero and have a Column Analyzes Status of "Cannot Analyze" in Information Analyzer.

One possible workaround is to create a view on the physical table and cast those varchar(max) columns to varchar(512).
Information Analyzer will then be able to analyze that table view along with those columns.
* Note that that 512 is the maximum length for string values that can be processed by IA without truncation and possible job failures if the Update Existing Tables option is enabled.

[{"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Business Unit":{"code":"BU001","label":"Analytics Private Cloud"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.3;8.5;8.7;9.1","Edition":""}]

Document Information

Modified date:
16 June 2018

UID

swg21698836