106 | 04 Jan 2011 @ 12:49 PST | Extensibility | Reply | UDF - Error 7504 | This is a UDF generated error. See message manual for explanation. Here is what it says:
7504 in UDF/XSP/UDM %DBID.%TVMID: SQLSTATE %VSTR
Explanation: This is a UDF/XSP/UDM generated error. The... |
105 | 22 May 2009 @ 09:14 PDT | Database | Reply | Threshold limit exceeded | Your site has TDWM (Teradata Dynamic Workload Management) enabled. You need to talk to your DBA to find out what the limits are for you or SQL general. Your query is using more resources than your ... |
104 | 19 May 2009 @ 10:10 PDT | UDA | Reply | Table Access Control | Let’s assume you have database ‘Michael’ and you are the owner of that database. Assuming that other staff logon to the database as separate users they don’t have access to Michael database... |
103 | 19 May 2009 @ 09:08 PDT | UDA | Reply | Table Access Control | I’m not sure of your set up but when you create a table in a database no one has access to the table unless you grant a blanked access to everything in the database to everyone. So normally restr... |
102 | 08 May 2009 @ 04:14 PDT | Database | Reply | For loop problem | I assume you created the volatile table outside the stored procedure, because you said you were not getting an error. According to documentation:“If the cursor SELECT statement references a missi... |
101 | 30 Apr 2009 @ 06:57 PDT | Database | Reply | Recursion in a stored procedure | Is not the where condition of your select supposed to be:where parent_id >= 2; |
100 | 27 Apr 2009 @ 05:39 PDT | Database | Reply | File and indices in Teradata | I would suggest you read the Teradata documentation: Database Design, Release 12.0, B035-1094-67A, September 2007. I suggest looking at Section 3: Physical Database Design. That section explains ev... |
99 | 24 Apr 2009 @ 09:37 PDT | Database | Reply | Will there be any space overhead for every column in a Teradata Table row based on its datatype? | Look at the Teradata documentation: Database Design ( Document: Release 12.0 B035-1094-067A), Chapter 15: Database-Level Capacity Planning Considerations - Base Table Row Format. All the gory deta... |
98 | 23 Apr 2009 @ 09:40 PDT | Database | Reply | Recursion in a stored procedure | RE: * Teradata procs do not support the "With Recursive" clause of SelectsYou can write a JAVA external stored procedure and submit a recursive select that way (TD12). It’s called just like any s... |
97 | 17 Apr 2009 @ 06:53 PDT | Analytics | Reply | Need to cast an invalid date to a valid | What you want to do is to detect the bad date string and convert it to a good one. If the problem is truly just the missing leading zero on the DD or MM field then it is pretty easy. Of course it ... |
96 | 16 Apr 2009 @ 05:27 PDT | UDA | Reply | No Rows found | Hmm, simple question, so I wonder whether you really mean that. It's simply:select count(*) from mytable where .... ;If there are no rows that match the where condition it will return zero otherwi... |
95 | 14 Apr 2009 @ 11:04 PDT | Database | Reply | How do we find the typical/average space occupied by column on disk? | Using TRIM will truncate trailing and leading spaces in the VARCHAR string. If you want the average length it takes up on disk you don't want to trim the spaces since they take up space also. If yo... |
94 | 03 Apr 2009 @ 06:15 PDT | Database | Reply | CHECKTABLE UTILITY -- ERROR | You told it not to place any locks. It checks the dictionary for consistency first. It found a table {0, A2D} hex that had an entry in TVM but there were no table headers for it on any of the AMPs.... |
93 | 02 Apr 2009 @ 10:05 PDT | Database | Reply | Procedure/ Cursor in TD | You use: FETCH NEXT CUR1 into emp_val, emp_prior;You can just specify your local procedure variables in SQL statements. However if you have a column name that is the same as your local variable n... |
92 | 30 Mar 2009 @ 07:28 PDT | Tools | Reply | Error for two intersecting queries | I think you want to use the EXCEPT operator not the INTERSECT. |
91 | 18 Feb 2009 @ 09:48 PST | UDA | Reply | Email Validation | If you are allowed to write C language UDFs on your system here is one solution. I hate that this forum does not retain the proper indentation, so you will have to just read it the hard way. /*REPL... |
90 | 30 Jan 2009 @ 08:48 PST | Database | Reply | Revoking All Access Rights For Users | Hmm, is it not just this statement?:REVOKE ALL PRIVILEGES ON object FROM user_name;for exampe if user name is "sam":REVOKE ALL PRIVILEGES ON sam FROM sam;The only privileges it does not remove are ... |
89 | 23 Jan 2009 @ 04:58 PST | Database | Reply | Vertical Pivoting | Or have a look at this one in this forum.http://www.teradata.com/teradataforum/Topic8112-5-1.aspx? |
88 | 15 Jan 2009 @ 05:33 PST | Database | Reply | Oracle RefCursor concept in Teradata stored procedure | In TD 12 you can define DYNAMIC RESULT sets. See the following thread on the subject in this same topic.http://www.teradata.com/teradataforum/Topic13703-9-1.aspx |
87 | 09 Jan 2009 @ 05:50 PST | Database | Reply | Count on number of cursors opened | The operative term is “open cursors”. When you finish the outer FOR cursor loop you will have no open cursors. So you have 15 to use again. The 16 th one is used for the stored procedure respon... |
86 | 08 Jan 2009 @ 09:45 PST | Database | Reply | Teradata equivalent of Oracle RAISE_APPLICATION_ERROR or MS SQL RAISERROR? | In addition to what Joe posted, TD_GENERAL parameter passing style does not have an “error_message” return argument. Look at the documentation again. Your C prototype must match what the docume... |
85 | 23 Dec 2008 @ 05:10 PST | Database | Reply | SUM Question | Try a the HAVING clause SELECT gr, SUM(chrg_amt) GROUP BY gr HAVING SUM(chrg_amt) <> 0 ORDER BY gr; |
84 | 19 Dec 2008 @ 08:32 PST | Database | Reply | any Acer for Stored Procs ? How to escape quotes in SP parameter. PL HELP | I don’t understand your difficulty or maybe your question. Suppose the stored procedure has two parameters such as (IN p1 VARCHAR(100), IN p2 VARCHAR(100))You just supply the strings to the two p... |
83 | 18 Dec 2008 @ 09:24 PST | Database | Reply | any Acer for Stored Procs ? How to escape quotes in SP parameter. PL HELP | ' blah blah , account=(''$d$metc'') ;' That is two single quotes to escape a quote. You don't need an escape for a comma. |
82 | 11 Dec 2008 @ 08:34 PST | Tools | Reply | using OREPLACE function | Try:SELECT ID, OREPLACE(ColA, ‘1A’XCV,’’) FROM test_tbl; |