KORREKTUR

Geschrieben von Stefan Blümen on Juni 21, 2002 um 08:58:

Als Antwort auf Re: Datentypkompatibilität geschrieben von Gernot Ruban on Juni 19, 2002 um 17:45:

: Hi Gernot,

: * 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.

Antworten:

Re: KORREKTUR Stefan Blümen 09:00 21.6.2002 (1)
- Re: KORREKTUR Gernot Ruban 13:55 25.6.2002 (0)

Schreibe eine Antwort

Name:
E-Mail:

Thema:

Kommentar:
: : Hi Gernot, : : : * 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:

[ Antworten ] [ Forum ]