230 | 02 Aug 2007 @ 04:02 PDT | Database | Reply | Finding dependent objects of a UDT | Have you tried using DBC.Columns view ? there's a columnUDTName field which might help. |
229 | 01 Aug 2007 @ 08:06 PDT | Database | Reply | How to Find the Version/Release of Teradata | SELECT *FROM DBC.DBCInfo; |
228 | 01 Aug 2007 @ 02:30 PDT | Tools | Reply | Oracle to Teradata Migration | In Teradata, you need to use CHARACTERS() or CHARACTER_LENGTH() |
227 | 27 Jul 2007 @ 05:21 PDT | Database | Reply | Is 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. |
226 | 27 Jul 2007 @ 12:35 PDT | Database | Reply | DIff 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 |
225 | 26 Jul 2007 @ 05:15 PDT | Database | Reply | Order of Tables in SQL statement | I 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... |
224 | 26 Jul 2007 @ 01:14 PDT | Database | Reply | Diff btw hard and soft RI | That'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... |
223 | 26 Jul 2007 @ 12:30 PDT | Analytics | Reply | Concatenate 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... |
222 | 26 Jul 2007 @ 12:23 PDT | Database | Reply | Diff btw hard and soft RI | We 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... |
221 | 26 Jul 2007 @ 12:05 PDT | Database | Reply | Order of Tables in SQL statement | Well 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... |
220 | 25 Jul 2007 @ 11:40 PDT | Database | Reply | Order of Tables in SQL statement | I 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... |
219 | 25 Jul 2007 @ 02:13 PDT | Database | Reply | Cascade/restrict in Physical data modeling | TD 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... |
218 | 25 Jul 2007 @ 12:55 PDT | UDA | Reply | Restoring 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 ... |
217 | 25 Jul 2007 @ 12:32 PDT | Database | Reply | Referencial Integrity in an EDW | I 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... |
216 | 24 Jul 2007 @ 11:11 PDT | Database | Reply | Problem with Teradata Service Control | Hmm... 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... |
215 | 24 Jul 2007 @ 10:56 PDT | UDA | Reply | date format | The "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... |
214 | 24 Jul 2007 @ 07:48 PDT | UDA | Reply | date format | -- Queryman / ODBC version ...SELECT (('20070620' (DATE, FORMAT 'YYYYMMDD')) - 120 ) (FORMAT 'YYYYMMDD' ) (CHAR(8));-- Bteq/CLI SELECT (('20070620' (DATE, FORMAT 'YYYYMMDD')) - 120 ) (FORMAT '... |
213 | 24 Jul 2007 @ 07:39 PDT | Database | Reply | Is 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 ? |
212 | 24 Jul 2007 @ 12:04 PDT | Database | Reply | Problem with Teradata Service Control | Hmm... 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... |
211 | 23 Jul 2007 @ 11:49 PDT | Tools | Reply | help... on passing parms into script | It 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... |
210 | 23 Jul 2007 @ 12:37 PDT | Database | Reply | Problem with Teradata Service Control | What is the situation ? The services are there, but not running , or the services are not there to begin with ? |
209 | 23 Jul 2007 @ 12:25 PDT | Database | Reply | Problem with Teradata Service Control | There 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... |
208 | 23 Jul 2007 @ 12:18 PDT | Database | Reply | log file | I 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... |
207 | 20 Jul 2007 @ 10:39 PDT | Connectivity | Reply | JDBC error: Error tdgss-stack-trace-begin | I have seen similar errors with bad classpaths ...Make sure you have terajdbc4.jar , tdgssconfig.jar and tdgssjava.jar in the classpath. |
206 | 20 Jul 2007 @ 09:49 PDT | Database | Reply | Variables and Bteq | Also if you are running on Unix/Linux Systems, it's popular to use the HERE document feature of shell to expand variables ... |