#DateForumTypeThreadPost
621 Jun 2013 @ 10:07 PDTDatabaseTopicGLobal Temporary Table (GTT)Can 2 sessions create same name GTT? OR does it tack on sessionID# to the table name when it stores its DDL in DD (DBC.* tables)? If same table DDL can be viewed in different sessions but data is p...
508 Oct 2012 @ 06:10 PDTDatabaseReplyNeed to convert UNICODE to LATINCAST(COALESCE(col1,'') AS VARCHAR(10)) produces UNICODE While  COALESCE(CAST(col1 AS VARCHAR(10)),'')    produces LATIN.   Any explaination for this? &nb...
408 Oct 2012 @ 06:01 PDTDatabaseReplyError Code 6706: The string contains an untranslatable character.Teradata TPT Job ignores OUTLIMIT value. BTEQ RETLIMIT and FEXP OUTLIMIT work fine. Does anyone know why TPT ignores OUTLIMIT? I defined INTEGER OutLimit = 1, in TPT Job but it retrieved...
308 Oct 2012 @ 01:04 PDTDatabaseReplyError Code 6706: The string contains an untranslatable character.Ulrich,  That did the trick. Yes, it comes out as UNICODE if you use COALESCE first and then CAST. If CAST first and then COALESCE , it is LATIN. I wonder why does it do that way implicitly...
208 Oct 2012 @ 05:49 PDTDatabaseReplyError Code 6706: The string contains an untranslatable character.I get this error when I CAST an Integer/Decimal/Float field to VARCHAR and concatenate to VARCHAR field in a SELECT clause. e.g.   SELECT  CAST(COALESCE(A,"") AS VARCHAR(11)) ...
128 Sep 2012 @ 05:24 PDTToolsReplySize Limit on Varchar / ConcatenatingWhen you try to concatenate all columns of a table using || and trmming all whitespaces from all CHAR/VARCHAR fields, I noticed that anything over VARCHAR(31825) when concatenated with other column...