Archives of the TeradataForum

Message Posted: Mon, 08 Nov 2010 @ 12:22:09 GMT

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

We are on Teradata 12.0. I tried commenting the UDF out and it worked ok (thanks). However, we have the same issue with the below code, with the code stopping between the 2 statements, though this code contains no UDF.

     ALTER TABLE PROD_PLAYPEN.CLAIMS_TEMP
     ADD MONTH_CREATED VARCHAR(2)
     ;

     /* then separately run this script */

     UPDATE PROD_PLAYPEN.CLAIMS_TEMP
     SET  MONTH_CREATED = substr(cast((cast( CLAIM_CREATED_DATE as format
     'dd-mm-yyyy')) as char(10)),4,2)
     ;

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