Archives of the TeradataForum
Message Posted: Tue, 29 Aug 2000 @ 13:29:40 GMT
Several things to remember:
1. you must define the input exactly as it is in Teradata terms. So a 'character' date is a character not a date which is an integer field.
2. You must define the set statement so that if a conversion is needed you identify the target data type and the default input format.
3. Without the data type in the set statement the format statement is invalid for a character field.
have fun....if everything was easy we would be out of a job.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|