Archives of the TeradataForum
Message Posted: Wed, 11 Jul 2007 @ 16:36:40 GMT
LENGTH is an ODBC function; it is not available in BTEQ.
Try to replace it with something like CHARS:
SELECT CHARS(tracking_no_merge) FROM orderstat.tracking_no_TMP WHERE CHARS(tracking_no_merge) > 200;
Are you on a very recent release? The error message used to be different.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|