#DateForumTypeThreadPost
1716 Jan 2013 @ 12:09 PSTConnectivityReplyNeed Help with Teradata ODBC driver on Oracle/AIXThat link is inaccessible :( I can't find a download link for the ODBC driver that actually works. Can anyone help? Ta. 
1627 Sep 2012 @ 06:55 PDTDatabaseReplyStrange(?) error creating FK constraintsMe too. I can't even find a reference (!) to it in the Teradata docs :(
1526 Sep 2012 @ 07:33 PDTDatabaseReplyStrange(?) error creating FK constraintsAnother one for you guys - do you know which DBC view column I can see the standard/batch/with/without option for the constraints?   Thanks, Mark
1426 Sep 2012 @ 12:39 PDTDatabaseReplyStrange(?) error creating FK constraintsI've seen a couple of posts on here that suggest that WITH CHECK OPTION is not just explicitly stating the default behaviour and that the SQL manual explains this. There's nothing useful i...
1325 Sep 2012 @ 05:24 PDTDatabaseTopicStrange(?) error creating FK constraintsI'm using Teradata v13.10. ALTER TABLE t1 ADD CONSTRAINT R1 FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCTS (PRODUCT_ID); This statement fails: ALTER TABLE Failed. 3796: Incorrec...
1211 Jul 2012 @ 12:31 PDTDatabaseReplyHow can I maintain referential integrity between TEMPORAL tables? I'm current looking for answers too. I'm was suprised to find that only soft RI is available and it seems like a bit of a 'cop out' to sling a load of SQL into the end o...
1111 Jul 2012 @ 12:04 PDTDatabaseReplyGetting rid of hardcosing in case query One suggestion out of many possibilities: Put the values in a table and rewrite the query to outer join to the new table then use a simpler CASE to determine the output based upon the presen...
1010 Jul 2012 @ 11:58 PDTDatabaseReplyIssue Querying Temporal Table Through View It's shame that this functionality doesn't also exist for TRANSACTIONTIME. I'd rather not create all the access views using NONSEQUENCED TRANSACTIONTIME time and the make the use...
910 Jul 2012 @ 09:01 PDTDatabaseReplyTemporals and Outer Joins Am I wrong, or would this allow us to do a SEQUENCED TRANSACTIONTIME join query that isn't supported naturally by the DBMS?
810 Jul 2012 @ 08:22 PDTDatabaseReplyIssue Querying Temporal Table Through View After some more playing I think I understand: The output from the view is sequenced and so the query against the view is querying sequenced data. If I run SELECT * FROM <view> then...
710 Jul 2012 @ 05:19 PDTDatabaseReplyTemporals and Outer Joins I guess you'd need to use the OVERLAP function to determine the valid cases of concurrent validity. I guess you don't get the calculated Period of Applicability (the VT) either then....
610 Jul 2012 @ 05:13 PDTDatabaseReplyTemporals and Outer Joins Or put the SEQUENCED queries into derived tables (subqueries) in the main query and join them...?
510 Jul 2012 @ 05:03 PDTDatabaseReplyIssue Querying Temporal Table Through View Aha! If I code SEQUENCED VALIDTIME into the view and query the view with SELECT * FROM <view> then it seems that CURRENT VALIDTIME overrides the temporal qualifier in the view. If ...
410 Jul 2012 @ 04:51 PDTDatabaseReplyIssue Querying Temporal Table Through View Is it really necessary to code the SEQUENCED VALIDTIME into the view? That seems very restrictive and it means that there is a need to have different sets of views for different present...
306 Jun 2007 @ 08:30 PDTDatabaseReplyViewing statistics on materialised global tempoary tablesMany thanks to you all for helping me out on this one.There's a drink on the bar for you.
204 Jun 2007 @ 01:36 PDTDatabaseReplyViewing statistics on materialised global tempoary tableswhat a shocking typo!I meant I've been tryingHELP STATISTICS TEMPORARY xxx ;and I'm getting that error messsage.Ant ideas?
104 Jun 2007 @ 01:17 PDTDatabaseTopicViewing statistics on materialised global tempoary tablesHello,can anyone out there help please?!I've got a GTT with some initial stats collected, on the base table.After logging in and inserting some data into the GTT I then recollect stats on the mater...