#DateForumTypeThreadPost
216 Dec 2010 @ 02:17 PSTDatabaseReplyTeradata IDENTITY columnsHi All, I have my identity column in negative (as stated above). When I try to insert a record, it goes to number lesser than minimum limit.. ID_NUM BIGINT NOT NULL GENERATED BY DEFAULT AS IDE...
107 Jun 2010 @ 11:58 PDTDatabaseReplyteradata sql helpThis works as well... update t1 from table1 t1, ( sel c1, c2, c3, c4, t1.c5, d1, d2, case when c3 > d1 and c4 < d2 and c2 = 'Y' then 'Y' when c3 > d1 and c4 < d2 and c2 = 'N' t...