Informix - Problem description
Problem IT39841 | Status: Closed |
ERROR -410 WHEN ATTEMPTING TO PREPARE A HIERACHICAL QUERY SELECTING ONE OR MORE LVARCHAR COLUMNS | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
when a SELECT statement contains one or more columns that are using the LVARCHAR data type results in error 410: "Prepare statement failed or was not executed. The error also seems to occur only with LVARCHAR columns and not with VARCHAR columns. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users having IDS version 14.10.XC7 or prior * **************************************************************** * PROBLEM DESCRIPTION: * * Error -410 when attempting to prepare a hierarchical query * * selecting one or more LVARCHAR columns * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users having IDS version 14.10.XC7 or prior * **************************************************************** * PROBLEM DESCRIPTION: * * Error -410 when attempting to prepare a hierarchical query * * selecting one or more LVARCHAR columns * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Comment | |
It's most likely idsdb00110659 solves this. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.02.2022 02.02.2023 02.02.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |