#DateForumTypeThreadPost
2127 Mar 2012 @ 11:01 PDTDatabaseTopicHow can I get the actual value of %VSTR or more error info? Hello, Our application consists of stored procedures.  I want to the log errors to a table.  I can get SQLSTATE and SQLCODE, but how do I formulate an error message that can be und...
2021 Feb 2012 @ 07:57 PSTDatabaseTopicError SPL1105 when using Dynamic Cursor and FOR UPDATE Hello,  I need to read a relatively small lookup table and parse a varchar column that contains data that looks like '12,345,6789', then update 3 columns in the SAME recor...
1914 Feb 2012 @ 09:31 PSTExtensibilityReplySQL UDF for LPAD (left-pad) giving unexpected results Thanks for the quick response Dieter!  Yes, setting the size worked! Also, thanks for the TRIM(BOTH) tip.  That will help to make the code a bit more readable! -Greg  
1814 Feb 2012 @ 08:02 PSTExtensibilityTopicSQL UDF for LPAD (left-pad) giving unexpected results Hello, Are there any doc's which discuss SQL UDF's?  (Especially the various qualifiers in the CREATE FUNCTION statement).  I am trying to determine why my regular SQL work...
1710 Feb 2012 @ 10:24 PSTDatabaseReplyUnexpected syntax error 3706 when using CASE IN with timestamp values Hi Ulrich, Thanks for your response and for spending the time to investigate.  The clip from the documentation is not displaying.  Can you perhaps provide a Doc Title and page numb...
1610 Feb 2012 @ 06:26 PSTDatabaseReplyUnexpected syntax error 3706 when using CASE IN with timestamp values Hi Ulrich, Carlos, Thanks for your replies.  They are column names, not hard-coded literals.  All of the columns involved are TIMESTAMP(6).  Below are the actual statements an...
1509 Feb 2012 @ 01:19 PSTDatabaseTopicUnexpected syntax error 3706 when using CASE IN with timestamp values Hello, I am sometimes encountering a syntax error (3706) when using CASE with an IN clause, see (1) below.  The error is happening with timestamp columns and sometimes wi...
1404 Feb 2012 @ 02:51 PSTToolsReplyCan ANSI transaction mode be set in TPT script? Thanks for the replies.  We work with medical data so there are often times where mixed case makes sense. Since TPT can't log in with ANSI, then I guess we can set CASESPECIFIC on t...
1303 Feb 2012 @ 05:53 PSTToolsTopicCan ANSI transaction mode be set in TPT script? Hello, Converting from Oracle to Teradata gave me some surprises when transferring data (primary index errors, unexpected dupes).  In Oracle we operate in a CASESPECIFIC mode, but I fou...
1230 Jan 2012 @ 10:52 PSTExtensibilityTopicWhat is allowed in an SQL UDF? Hello, I've written some C-language UDF's but management is not keen on using C.  I recently discovered that SQL UDF's are available in 13.10, but I am unclear as to what is...
1121 Jan 2012 @ 04:29 PSTDatabaseReplyUsing EXECUTE IMMEDIATE to create a volatile table One other question, can I see a volatile table and query it through my IDE?  Can I do a SHOW TABLE? Thanks!
1021 Jan 2012 @ 03:51 PSTDatabaseReplyUsing EXECUTE IMMEDIATE to create a volatile table Dieter, Thanks alot for your very quick response.  Yes, your correction worked!  Have a nice weekend! -Greg  
921 Jan 2012 @ 01:07 PSTDatabaseTopicUsing EXECUTE IMMEDIATE to create a volatile table Hello Folks, I am trying to pass a variable (in_project) into an SP that will be used to query a permanent table (PROJECT_VARS) and build a volatile table (TMP_PROJECT_VARS).  But ...
802 Jan 2012 @ 09:51 PSTToolsReplyOLELoad generating win32 exception Ooops, Correction from my last post:  by not specifying LDAP in the script file, and instead authenticating with the Teradata password itself.  SHOULD BE by not specifying ...
702 Jan 2012 @ 09:33 PSTToolsReplyOLELoad generating win32 exception Hello SuSeSi, Happy 2012!  Thanks for your response.  Sorry for not responding earlier, as I have been offline due to the holidays.... One of our Teradata contractors was ...
626 Dec 2011 @ 08:00 PSTToolsReplyTPT13103: Error 5 retrieving DML Group Attribute Thanks much!  Looks like the INSERT was not in the User Guide for Example 15.   I'm getting farther now, the table "Trans" is created, though it is empty, and w...
526 Dec 2011 @ 11:03 PSTToolsTopicTPT13103: Error 5 retrieving DML Group Attribute Hello, Can someone provide some insight with this TPT error?  My script file is very similar to Example 15 from the TPT User Guide.  It copies a source table to a destination table...
423 Dec 2011 @ 08:49 PSTToolsTopicOLELoad generating win32 exception Hello, I am using OLELoad 13.10.00.02 to pull data from Oracle 11g to Teradata 13.10.  Some tables load with no problem, but with some, I am getting a win32 exception.  The excepti...
312 Dec 2011 @ 08:18 PSTExtensibilityTopicConsequences of failures of UDF in non-protected Mode As I qualified in a previous post, I'm a Teradata newbie (migrating from Oracle).   Just started writing UDF's.  I see the following Warning in the UDF Programming manual ...
209 Dec 2011 @ 06:14 PSTExtensibilityReplyREGEXP_LIKE Thanks much Jim.  That got me over a big hurdle, and my UDF now works when I run it from a select statement.  Also created my own version of the Oracle UPPER() function.
108 Dec 2011 @ 03:48 PSTExtensibilityReplyREGEXP_LIKE Hi Folks, I am a Teradata newbie, and in the same situation as "toadrw", migrating from Oracle 11g to Teradata 13.10, and need to find a solution for REGEXP.  Thanks to this site,...

Pages