Archives of the TeradataForum
Message Posted: Tue, 18 Sep 2012 @ 21:16:28 GMT
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.
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|