Archives of the TeradataForum
Message Posted: Thu, 10 Apr 2008 @ 11:31:11 GMT
The query is :
Is there a possibility of writing a sql in teradata such that the query fails when a particular criteria is not satisfied?
My exact need is :
I am having a table with one of the column data type as Decimal() .
So I need a sql query that would cast decimal column to float if the data is not equal to zero and fails if the input data is zero.
Exactly : case when col.id <>0.0 then cast(col.id as float) else failure.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|