Thema:

Kommentar:
: : : Hi Gernot, : In der Select-Abfrage gibt es UNGLEICH ( ). : Es wird aber in dem Forum nicht angezeigt. : : : : : : * um welches Betriebssystem handelt es sich? : : Windows NT : : : * in welchem Zusammenhand tritt das Problem auf (Programm, CLI, CLP, ...) : : VB Programm : : : * um welche DB2 Version handelt es sich (db2level) : : 7.2 : : : * wie lautet das Statement exakt : : SELECT * FROM TESTFALL_DATEN WHERE WERT 'KEIN' : : : Gruß : : : Gernot : : : Aus der SQL Reference: : : : Restrictions Using Varying-Length Character Strings: : : : Special restrictions apply to an expression resulting in a varying-length string data type whose maximum length is greater than 254 bytes; such expressions are not permitted in: : : : A SELECT DISTINCT statement's SELECT list : : : A GROUP BY clause : : : An ORDER BY clause : : : A column function with DISTINCT : : : A subselect of a set operator other than UNION ALL. : : : In addition to the restrictions listed above, expressions resulting in LONG VARCHAR or CLOB data types are not permitted in: : : : A Basic, Quantified, BETWEEN, or IN predicate : : : A column function : : : VARGRAPHIC, TRANSLATE, and datetime scalar functions : : : The pattern operand in a LIKE predicate or the search string operand in a POSSTR function : : : The string representation of a datetime value : : : The functions in the SYSFUN schema taking a VARCHAR as an argument will not accept VARCHARs greater than 4 000 bytes long as an argument. However, many of these functions also have an alternative signature accepting a CLOB(1M). For these functions the user may explictly cast the greater than 4 000 VARCHAR strings into CLOBs and then recast the result back into VARCHARs of desired length.

Optionale Link URL:   
Link Titel:                  
Optionale Image URL: