Archives of the TeradataForum

Message Posted: Tue, 18 Sep 2012 @ 21:16:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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 
     SET = 
     WHERE colum1=vt_del_dup_veh_revs.column1
     AND column2=vt_del_dup_veh_revs.column2
     AND vt_del_dup_veh_revs.del_ind='Y';

The above update?query Fails:

     select
     a.*, b.* from , vt_del_dup_veh_revs WHERE
     column1=vt_del_dup_veh_revs.column1
     AND column2=vt_del_dup_veh_revs.column2
     AND vt_del_dup_veh_revs.del_ind='Y'

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>