![]() |
|
![]() |
![]() |
Archives of the TeradataForumMessage Posted: Tue, 18 Sep 2012 @ 21:16:28 GMT
Hello Gurus, I have weird problem with one of the derived columns in a where clause criteria. If i use the derived column in the where clause criteria, update statement fails saying that " A character String Failed coversion to a numeric Value" But the same where caluse in select query works fine. UPDATE The above update?query Fails: select a.*, b.* from The above select query runs fine and getting the data back. Volatile table was created as follows: CREATE SET VOLATILE TABLE EDW_DEV_BATCH.vt_del_dup_veh_revs ,NO FALLBACK , CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO, LOG ( column1 INTEGER, column2?TIMESTAMP(0), del_ind VARCHAR(1) CHARACTER SET UNICODE NOT CASESPECIFIC ) PRIMARY INDEX ( column1) ON COMMIT PRESERVE ROWS; I have the workaround for this, but my intention is to know why select is working fine but update is failing? any information on this would be greatly appreciated. Thanks Siva Nelluri
| ||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
![]() | ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||