Archives of the TeradataForum
Message Posted: Tue, 03 Apr 2007 @ 19:29:17 GMT
Could someone help on restricting string column to accept only lower case values.
We have V2R5.0.1 which will not support the UDF's, I cannot use Trigger because table containing this column is being MLOADED daily with quite a number of records apart from Stored Procedure output parameter can not be used in CHECK constraints with in the DDL to verify for lower case values.
Basically I want this to be tested in DDL like the below one
Is there any other method to achieve this?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|