#DateForumTypeThreadPost
13008 Jun 2007 @ 01:14 PDTUDAReplyProblem in CastYou will get all the details in "Data types and Literals" manual, chapter 9
12907 Jun 2007 @ 03:36 PDTDatabaseReplyHow off the format......I don't think there's such a thing as "turn off" Format. Format is something which tells Teradata how to display the contents of the column. It Does not effect the way in which the data is stored i...
12807 Jun 2007 @ 12:25 PDTUDAReplyProblem in CastThe default format for DECIMAL(11,0) is '-----------9.' and that was the reason why you were getting the dot (.) at the end. So by explicitly specifying the formatting clause, we got rid of the '.'...
12706 Jun 2007 @ 11:56 PDTConnectivityReplydifference between ODBC and JDBCSQL assistant is a ODBC based client.You can use Squirrel SQL client available here to connect to databases via JDBC, it works with Teradata as well.http://squirrel-sql.sourceforge.net/
12606 Jun 2007 @ 11:59 PDTAnalyticsReplyHow to Calculate the Interval Days?On third thoughts , you can even get both dates from it as well.SELECT CID,BILLDATE - ((SUM(BILLDATE(INTEGER)) OVER (PARTITION BY CID ORDER BY BILLDATE ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING ))...
12506 Jun 2007 @ 07:37 PDTAnalyticsReplyHow to Calculate the Interval Days?Well, in that case this is all you need.SELECT CID, BILLDATE - ((SUM(BILLDATE(INTEGER)) OVER (PARTITION BY CID ORDER BY BILLDATE ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING )) (DATE)) NOOFDAYSFROM ...
12406 Jun 2007 @ 06:46 PDTAnalyticsReplyHow to Calculate the Interval Days?Considering that you would also have to bother about duplicates on the date column,(customer returned on the same day) which I assume shouldn't be counted as 0 days, and that you also need both the...
12306 Jun 2007 @ 05:41 PDTConnectivityReplydifference between ODBC and JDBCThough it's not my area of expertise, I wouldn't think these two are related. Websphere is an application server, so you have your Java applications running on it. And those java applications may u...
12206 Jun 2007 @ 12:13 PDTConnectivityReplydifference between ODBC and JDBCThey are two different sets of standards (ODBC from microsoft and JDBC from Sun) that were created so that Developers can write code that could use a standard set of API calls from their programs a...
12105 Jun 2007 @ 11:35 PDTUDAReplyProblem in CastBarry's code should have done the trick, is the column type really DECIMAL(11,0) or something else like CHAR(11) ?you can also try thisSEL TRIM((DECCOL11 (INTEGER , FORMAT 'ZZZZZZZZZZ9')) (CHAR(11)...
12005 Jun 2007 @ 12:26 PDTDatabaseReplyViewing statistics on materialised global tempoary tablesIt's a documentation defect.The correct syntax isHELP TEMPORARY STATISTICS MYGTT;There's a DR (96689) already in place to change the documentation.
11904 Jun 2007 @ 11:52 PDTToolsReplyArcmain CopyRestore is used to... well restore the contents back to the original object that was archived. ie if you had archived mydb.table1 in TD system TDDB, then you can RESTORE the that table contents fro...
11804 Jun 2007 @ 04:40 PDTDatabaseReplyQuery HelpAs a matter of fact, the user doesn't require create table privileges to create volatile table.
11730 May 2007 @ 07:43 PDTDatabaseReplyDatabase info in one queryRefer this thread .....http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=9&messageid=7274
11630 May 2007 @ 07:39 PDTUDAReplyError T3932putting aET;BT;after the collect statistics command would most likely fix the issue, but I wouldn't recommend that. The best approach would be to make sure that Data Stage is not calling the SP as ...
11529 May 2007 @ 10:11 PDTDatabaseReplyRegarding rollback statement.....if the select query does not return a record for the value of ric given as argument to the macro, the current transaction would be aborted (any changes done as part of the transaction would be reve...
11429 May 2007 @ 12:05 PDTToolsReplyGetting an error on xport commandYour DBA has set a resource limit using TDQM which prevents your from firing SQLs whose estimated result set size exceeds 500000000.Probably "the couple of things" you tried fixed a logic error in ...
11328 May 2007 @ 06:22 PDTToolsReplyHow to know if a table is locked is teradata?if you are looking for locks placed by normal SQL operations, then you need to use the LOKDISP utility.for HUT locks, it's SHOWLOCKS
11228 May 2007 @ 02:03 PDTDatabaseReplyViews or Intermediate objects that can hold dataJoin Index + view combinations is TD's way of implementing a materialized view concept of Oracle. And data is "stored" in the index (object). Any changes to base table are immediately visible to JI...
11126 May 2007 @ 03:33 PDTDatabaseReplyreturning an identity value when doing a single insertSome thoughts....The feature you are looking for is supported in latest JDBC driver APIs (yeah, it doesn't help you :-) )Relying on the identity column values to reflect the chronological order i...
11025 May 2007 @ 05:06 PDTDatabaseReplyTable lockyou can type start lokdispin your supervisor window and it will show up with a small help menu ...you can get further help on topics by giving the topic as argument to the help command.ie likeHELP ...
10925 May 2007 @ 12:38 PDTDatabaseReplyAvoiding Decimal Places in the querycan you tryWHERE FC_cost = FC_cost(INTEGER)
10825 May 2007 @ 12:05 PDTDatabaseReplyCollect stats index vs multiple columns: advantages?That's because when there's an index it can be used to reach the record without doing a full table scan. so it's faster. Now if you don't have an index, you have to do a full table scan to fetch th...
10724 May 2007 @ 05:18 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIwhat is good depends on what you are trying to accomplish via partitioning. For example if you are maintaining historic data which spans a few decades and the reports you run against it are based o...
10624 May 2007 @ 04:33 PDTDatabaseReplyCollect stats index vs multiple columns: advantages?If your question is whether there's a performance difference where you have a column with an index on it and the stats are collected on either the index or column ... the answer is no, they both ha...

Pages