#DateForumTypeThreadPost
1110 Feb 2015 @ 01:36 PSTDatabaseTopicUsing the data dictionary to differentiate between different types of foreign keyHi,   is there any information provided by the data dictionary which allows one to differentiate between the 3 types of foreign keys supported by Teradata?   (1) Row level (2) 'W...
1018 Sep 2013 @ 02:42 PDTDatabaseTopicUse of CTE within stored procedures Hi all   I am using Teradata Express 13.10 & I am trying to write a stored procedure which uses multiple references to dataset defined using a 'common table expression.'...
903 Feb 2012 @ 02:45 PSTDatabaseReplyError 7691 P1 :Table used in cursor select is restructured from compile-time to run-time For anyone interested Teradata support have suggested setting   SET SESSION DATEFORM=INTEGER   when procedures are compiled.
831 Jan 2012 @ 06:08 PSTDatabaseReplyError 7691 P1 :Table used in cursor select is restructured from compile-time to run-time So I've managed to create a test case: does anyone know what is happening? create table xxx ( JLU_EFFECTIVE_DATE DATE NOT NULL ); commit; replace procedure px() begi...
731 Jan 2012 @ 03:56 PSTDatabaseTopicError 7691 P1 :Table used in cursor select is restructured from compile-time to run-time Hi there   I have 2 objects - a table  - stored procedure which just does a cursor for loop over the contents of the table.   However, when I execute my st...
616 Nov 2011 @ 01:45 PSTDatabaseTopicTeradata Stored Procedures & User Defined Exceptions Hi all, we are running on Teradata 13.10.01.05, on Suse Linux. The session transaction mode we are using is ANSI. I am investigating how to use user defined exceptions within Teradata st...
528 Aug 2011 @ 12:25 PDTDatabaseTopicPreferred approach to application installation Hi all,   I have an application, for which I must create an installation script. This installation script must:   1. Drop all database objects which are part of my appl...
417 Jul 2011 @ 06:03 PDTDatabaseReplyExecuting a multi-statement requestThat's lovely - thanks a lot for all of your help guys! Andrew.
315 Jul 2011 @ 06:07 PDTDatabaseReplyExecuting a multi-statement requestHi Dieter, Whilst in ANSI mode - - I've committed and run the procedure - it still fails. - I've added the begin/end request block - it still fails. - I've removed the update & insert s...
214 Jul 2011 @ 12:29 PDTDatabaseReplyExecuting a multi-statement requestHi Dieter thanks - I do appreciate that the problem statement provided by the error message does rather suggest the solution :-) Sadly, coming from an Oracle background & having scant knowled...
114 Jul 2011 @ 09:22 PDTDatabaseTopicExecuting a multi-statement requestHi all I have a newbie question - on TD 13.10, I have a stored procedure which contains 2 dml statements - an update followed by an insert. I'd like to test this stored procedure in isolation...