DB2 Version 8.1.5
=====> CREATE TABLE test1(a VARCHAR(100));
DB20000I The SQL command completed successfully.
=====> INSERT INTO test1 VALUES('501');
DB20000I The SQL command completed successfully.
=====> INSERT INTO test1 VALUES(' 502 ');
DB20000I The SQL command completed successfully.
=====> SELECT * FROM test1 WHERE a=501;
SQL0401N The data types of the operands for the operation "=" are not
compatible. SQLSTATE=42818
=====> SELECT * FROM test1 WHERE a=502;
SQL0401N The data types of the operands for the operation "=" are not
compatible. SQLSTATE=42818
=====> SELECT * FROM test1 WHERE a<'502';
A
---------------------------
501
502
2 record(s) selected.
=====> CREATE TABLE test2(b INTEGER);
DB20000I The SQL command completed successfully.
=====> INSERT INTO test2 VALUES(503);
DB20000I The SQL command completed successfully.
=====> INSERT INTO test2 VALUES(504);
DB20000I The SQL command completed successfully.
=====> SELECT * FROM test2 WHERE b='503';
SQL0401N The data types of the operands for the operation "=" are not
compatible. SQLSTATE=42818
=====> SELECT * FROM test2 WHERE b>'503';
SQL0401N The data types of the operands for the operation ">" are not
compatible. SQLSTATE=42818
--
========================================================================
Jeremy Hinegardner [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
