#DateForumTypeThreadPost
23002 Aug 2007 @ 04:02 PDTDatabaseReplyFinding dependent objects of a UDTHave you tried using DBC.Columns view ? there's a columnUDTName field which might help.
22901 Aug 2007 @ 08:06 PDTDatabaseReplyHow to Find the Version/Release of TeradataSELECT *FROM DBC.DBCInfo;
22801 Aug 2007 @ 02:30 PDTToolsReplyOracle to Teradata MigrationIn Teradata, you need to use CHARACTERS() or CHARACTER_LENGTH()
22727 Jul 2007 @ 05:21 PDTDatabaseReplyIs it possible to partition records in AMPS after the data got loaded and distributed?You cannot alter a non partitioned table to make it partitioned table if it's not empty.
22627 Jul 2007 @ 12:35 PDTDatabaseReplyDIff btw row_number and rank_index?This is briefly explained at the bottom of this thread.http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=5&messageid=8112#bm8330
22526 Jul 2007 @ 05:15 PDTDatabaseReplyOrder of Tables in SQL statementI did some background research on what was the documentation trying to put across but drew blank mostly.Below are my thoughts on this, I could be wrong, hopefully someone should be able to throw mo...
22426 Jul 2007 @ 01:14 PDTDatabaseReplyDiff btw hard and soft RIThat's true, where as with Hard RI, Database is forced to make all the checks, in soft RI, Database assumes that this was already done by you before you load the data into the table.It's not always...
22326 Jul 2007 @ 12:30 PDTAnalyticsReplyConcatenate Vertically?These are OLAP functionalities of SQL, you would find info only in the Teradata manuals, specifically in functions and operators manual.A simplified explanation on the two functions is as followsRO...
22226 Jul 2007 @ 12:23 PDTDatabaseReplyDiff btw hard and soft RIWe will start with Hard RI.It's nothing but our plain good old Referential integrity check we know of ...so if we have two tables ... (pardon any syntax errors)CT DEPT( DEPTNO INTEGER NOT NULL, D...
22126 Jul 2007 @ 12:05 PDTDatabaseReplyOrder of Tables in SQL statementWell it doesn't work that way in Teradata because we have a cost based optimizer and not a rule based one.I am not sure if it works as you mentioned in Oracle, but I remember during my old informix...
22025 Jul 2007 @ 11:40 PDTDatabaseReplyOrder of Tables in SQL statementI hope you meant inner joins, and the answer is no, teradata don't bother about the order in which you mention the tables in the from clause. The optimizer is smart enough to generate the same plan...
21925 Jul 2007 @ 02:13 PDTDatabaseReplyCascade/restrict in Physical data modelingTD has only provision for RESTRICT.You can implement CASCADE as a combo of Soft RI + AFTER DELETE triggers prior to V2R6.2Starting V2R6.2 you can use the AFTER DELETE triggers along with Hard RI as...
21825 Jul 2007 @ 12:55 PDTUDAReplyRestoring of file.This is a general syntax.from acrmain utility .. .logon tdpid/user,pass;COPY DATA TABLES (DP_Stg) (FROM (originaldb)) ,ABORT, RELEASE LOCK, FILE = file;LOGOFF;.QUIT;where originaldb is the name of ...
21725 Jul 2007 @ 12:32 PDTDatabaseReplyReferencial Integrity in an EDWI don't have numbers to share, but I can vouch it's very nasty...so in general I would say, keep soft RI in your master tables (which is good enough for the optimizer).Use Hard RIs on the staging t...
21624 Jul 2007 @ 11:11 PDTDatabaseReplyProblem with Teradata Service ControlHmm... this looks a bit weird :o...Did you try installing that option again ? Also check if your windows login id has Administrator privileges and that you have sufficient disk space. Did you notic...
21524 Jul 2007 @ 10:56 PDTUDAReplydate formatThe "Quirk" is because ODBC/JDBC applications are free to ignore the formating phrase, and they do just that and display data using their own formats.When you cast to CHAR(n), the formating is appl...
21424 Jul 2007 @ 07:48 PDTUDAReplydate format-- Queryman / ODBC version ...SELECT (('20070620' (DATE, FORMAT 'YYYYMMDD')) - 120 ) (FORMAT 'YYYYMMDD' ) (CHAR(8));-- Bteq/CLI SELECT (('20070620' (DATE, FORMAT 'YYYYMMDD')) - 120 ) (FORMAT '...
21324 Jul 2007 @ 07:39 PDTDatabaseReplyIs it possible to create and use volatile table in the same procedure?As far as I can tell, the SP gets created with warnings ...Can you post a sample SP which reproduces your issue ?
21224 Jul 2007 @ 12:04 PDTDatabaseReplyProblem with Teradata Service ControlHmm... in the Demo installation menu, did you install the Teradata Database V2R6.1 option as well (the one below Bynet driver) ? can you check if the directory C:\Program Files\NCR\TDAT\tdconfig is...
21123 Jul 2007 @ 11:49 PDTToolsReplyhelp... on passing parms into scriptIt is also recommended to use a view so that you don't have to change the table name in all the scripts. And just have to bother about pointing the view to new table in the script where the table i...
21023 Jul 2007 @ 12:37 PDTDatabaseReplyProblem with Teradata Service ControlWhat is the situation ? The services are there, but not running , or the services are not there to begin with ?
20923 Jul 2007 @ 12:25 PDTDatabaseReplyProblem with Teradata Service ControlThere are three more ... make sure these are present.Teradata GTW reserve port (this service needs to be running, at the time of the system start, has a dependency on )Teradata Inetd serviceTeradat...
20823 Jul 2007 @ 12:18 PDTDatabaseReplylog fileI think you meant to ask which PE services the session ? (because all the nodes have to take part in getting the tusker out of the pit ! )There must be a much easier way to do this :-) The DBC.Ses...
20720 Jul 2007 @ 10:39 PDTConnectivityReplyJDBC error: Error tdgss-stack-trace-beginI have seen similar errors with bad classpaths ...Make sure you have terajdbc4.jar , tdgssconfig.jar and tdgssjava.jar in the classpath.
20620 Jul 2007 @ 09:49 PDTDatabaseReplyVariables and BteqAlso if you are running on Unix/Linux Systems, it's popular to use the HERE document feature of shell to expand variables ...

Pages