Informix - Problembeschreibung
Problem IT19260 | Status: Geschlossen |
THE FUNCTION CREATED "WITH RESUME" CLAUSE RETURNS ERROR 1 "NOT USER" | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
The function create with resume returns error 1: Not user . The same function works without error in IDS 11.50* and IDS 11.70.* . CREATE FUNCTION "informix".spl_with_resume( pAssetid INTEGER, pAtribut VARCHAR(30), pUltim BOOLEAN DEFAULT 'f', pValorPerDefecte VARCHAR(255) DEFAULT NULL ) RETURNING VARCHAR(255); DEFINE l_valor VARCHAR(255); DEFINE l_cont INTEGER; LET l_cont = 0; FOREACH curAssetAtribut FOR SELECT valor_varchar INTO l_valor FROM dtvc_asset_atributs WHERE assetid = pAssetid AND atribut = pAtribut ORDER BY data_modificacio DESC IF pUltim THEN RETURN l_valor; END IF; LET l_cont = l_cont +1; RETURN l_valor WITH RESUME; END FOREACH; IF l_cont = 0 THEN RETURN pValorPerDefecte; END IF; END FUNCTION; select spl_with_resume(m.assetid,'NUM_CHAPTER_PROD','t','')!='' from dtvc_metadata m where assetid = 1654811; Error : 1:Not user | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Informix server with SPL procedure with 'RESUME' * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC9 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.02.2017 10.07.2017 10.07.2017 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC9 | |
Problem behoben lt. FixList in der Version |