Example:
CREATE TABLE TOAD.TEST
(
B CHARACTER (10) WITH DEFAULT NULL,
A INTEGER WITH DEFAULT NULL,
C SMALLINT WITH DEFAULT NULL
);
CREATE VIEW TOAD.TEST
AS
(SELECT A || '-- TEST' AS AS, B, C FROM TOAD.TEST2100411TABLE);
The script generated by Toad is :
CREATE VIEW TOAD.TEST VIEW AS (
SELECT A || ' FROM TOAD.TEST);
Note that the --TEST is missing
WORKAROUND
None
STATUS
Waiting for fix in a future release of Toad for DB2
