HOLD files are creating variable length formats (AnV) for character columns

Diagnostics

Product: Reporting Server

Release: 8206

Primary OS: Windows

Solution Date: 2020-01-30

Problem

Using SQL Passthru to read varchar and char columns from Db2 and creating HOLD files. In release 7.7.02, all character formats were created as fixed lengths in the HOLD files. In release 8206, some of the character formats are variable (AnV).

Solution

Release 7.7.02 uses the following statement: ENGINE DB2 SET VARCHAR OFF

Release 8206 uses the following statement: ENGINE SQLDB2 SET VARCHAR OFF

SQLDB2 is not a valid engine so it is not applied. Specifying the following statement resolved the issue: ENGINE DB2 SET VARCHAR OFF

Information is published on an "as is" basis without a warranty of any kind. Information Builders, Inc. ("IBI") hereby represents that such information has not been subject to any formal testing or review by IBI. IBI assumes no responsibility for usage of such information, including the implementation of solutions associated therewith. The customer assumes responsibility for the results obtained from such information. IBI is not responsible for and shall not be held liable for the results obtained, including but not limited to any errors, delays or omissions. IBI disclaims any liability for the completeness or accuracy of such information.