Geschrieben von Gernot Ruban on Juni 19, 2002 um 17:45:

Als Antwort auf Datentypkompatibilität geschrieben von Stefan Blümen on Juni 17, 2002 um 15:52:

Hi Stefan,

* um welches Betriebssystem handelt es sich
* in welchem Zusammenhand tritt das Problem auf (Programm, CLI, CLP, ...)
* um welche DB2 Version handelt es sich (db2level)
* wie lautet das Statement exakt

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.

• KORREKTUR Stefan Blümen 08:58 21.6.2002 (2)
  • Re: KORREKTUR Stefan Blümen 09:00 21.6.2002 (1)
    • Re: KORREKTUR Gernot Ruban 13:55 25.6.2002 (0)
• Re: Datentypkompatibilität Stefan Blümen 08:57 21.6.2002 (0)

Schreibe eine Antwort