#DateForumTypeThreadPost
7829 Aug 2006 @ 04:36 PDTUDAReplyDatastage to Teradata multiloadHi Ravindra,> . Minimum of 16 load session(s) requested.MLoad can't logon with less than 16 sessions.> . Tenacity: 4 hour limit to successfully connect load sessions.If there are less than 16 sessi...
7729 Aug 2006 @ 04:12 PDTToolsReplySecondary index SubtableHi Farid,you'll find all the details in the manuals:Database DesignChapter 11: Secondary IndexesUnique Secondary IndexesNonunique Secondary IndexesChapter 15: Database-Level Capacity Planning Consi...
7628 Aug 2006 @ 03:38 PDTDatabaseReplyInteger to Date format?Hi Elango,there are probably some invalid values within DATE_YYYYMM:select DATE_YYYYMMfrom my_tablewhere DATE_YYYYMM mod 100 not between 1 and 12or DATE_YYYYMM = 0Dieter
7528 Aug 2006 @ 02:23 PDTDatabaseReplyInteger to Date format?Hi Elango,change it to the Teradata internal date format:select (200607 - 190000) * 100 + 1 (date)Dieter
7427 Aug 2006 @ 02:41 PDTUDAReplySplit a row into multiple rows based on a Date RangeHi Sam,i can't tell you which is more efficient, you'll have to test it with your data.It probably depends on:number of rows in your calendar table to be cross joined vs.number of recursion levelsD...
7327 Aug 2006 @ 07:10 PDTUDAReplyproblem in mloadPossible reasons might be:- someone dropped the worktable - you specified the wrong name during a restart- a previous MLoad was cancelled without RELEASE MLOAD...From the messages manual:2583 %VSTR...
7227 Aug 2006 @ 07:03 PDTUDAReplySplit a row into multiple rows based on a Date RangeHi Sam,create table sam(Emp int, Start_date Date, End_date Date);insert into sam values(10, date '2006-01-01', date '2006-12-31');insert into sam values(20, date '2005-05-01', date '2005-12-31'); /...
7125 Aug 2006 @ 04:26 PDTUDAReplyHierarchy SQLHi Hari,i don't know your data, but it looks like you want to calculate the Transitive Closure, i.e. all existing paths.For all rows it's probably:WITH RECURSIVE HARI_TMP(mgr,emp,LEVEL) AS(SELECT m...
7024 Aug 2006 @ 02:58 PDTUDAReplyHierarchy SQLHi Hari,of course it's possible, you just have to code it the right way :-)Maybe show us what you wrote so far...Returning the hierarchy of Teradata databases & users as an example:WITH RECURSIVE p...
6922 Aug 2006 @ 02:24 PDTDatabaseReplyHow do I make an exact copy of a current tableDefinition plus data?create table newtab as oldtab with data;Or just the definition?...with no data;check the manuals for details...Dieter
6819 Aug 2006 @ 01:36 PDTToolsReplyDATE FORMATHi Ajai,you can cast that column to a date:SELECT MAX(my_col (DATE, FORMAT 'mmmyyyy')) (CHAR(7))FROM my_tab;Dieter
6719 Aug 2006 @ 01:26 PDTAnalyticsReplyGetting one entry per RANKHi Carole,just add more columns to the Order By to make it unique or use row_number instead of rank...Dieter
6614 Aug 2006 @ 01:22 PDTToolsReplySelect Top 10 recordsHi Vincent,TOP syntax was implemented in V2R6 :-)Dieter
6503 Aug 2006 @ 04:26 PDTDatabaseReplySpool Space IssuesAs Nytewynd already proposed, try to filter on the 540M table in bn before the join to reduce the number of rows to be joined.Replacing the MAX-subquery with a RANK will probably help also. Of cour...
6403 Aug 2006 @ 12:21 PDTToolsReplyMultiple Nullif checks for a field in FastloadYou can stop looking for the syntax, it just can't be done using FastLoad.The only way would be writing an INMOD doing the check.Dieter
6303 Aug 2006 @ 12:17 PDTAnalyticsReplyFailure 7453 Interval field overflowEven better, use day(4) to second, this will cover up to 27 years difference :-)Dieter
6228 Jul 2006 @ 02:28 PDTDatabaseReplyUnion All problemHi John,SQL Reference: Functions and OperatorsChapter 5: Set OperatorsAttributes of a Set Result"The data type, title, and format clauses contained in the first SELECT statement determine thedata t...
6128 Jul 2006 @ 11:59 PDTDatabaseReplyHow to subtract time from a timetamp fieldThere's no need to typecast:duration * interval '00:00:01' hour to second Dieter
6026 Jul 2006 @ 02:46 PDTUDAReplyEquivalent of "Connect By prior .. with level" in TeradataHi Ashu,since V2R6 there's Standard SQL "WITH" for recursive queries, most of Oracle's functionality can be converted. There's a good article for DB2 how to convert CONNECT BY to WITH, most of it i...
5918 Jul 2006 @ 09:24 PDTDatabaseReplyPreCompilerIn Teradata it's called Preprocessor, search the manual for it. But IMHO it's hardly used anymore, in most environments it's replaced by ODBC/JDBC access...Dieter
5817 Jul 2006 @ 03:09 PDTDatabaseReplyPlease Help on view updateHi yujing,all manuals are available at www.info.ncr.comInstead of seperate manuals, it's better to download the documentation CD, then you can search within all manuals.Dieter
5717 Jul 2006 @ 02:09 PDTDatabaseReplyPlease Help on view updateHi yujing,Messages manualChapter 6: Teradata Database Messages3000-Series Messages3823 VIEW ’%VSTR’ may not be used for HelpIndex/Constraint/Statistics, Update, Delete orInsert.Explanation: The...
5617 Jul 2006 @ 12:24 PDTDatabaseReplyUnable to login througj BTEQHi Manik,MessagesChapter 17: Client UTYUTY-Series Messages"UTY6214 Reminder: A .Logtable statementmust be entered for a successful logon.Explanation: The .Logon and .Logtable statementsmust both be...
5517 Jul 2006 @ 12:21 PDTDatabaseReplyCollect Stats on Global Temporary TableHi Manne,MessagesChapter 6: Teradata Database Messages5000-Series Messages"5343 This statement is not allowed when thetarget temporary table is already materialized.Explanation: The user cannot sub...
5417 Jul 2006 @ 06:32 PDTDatabaseReplysomebody help me its very urgent!!!!!!!Submit "net start recond" from commmand line. Then check the windows eventlog (applications) for errormessages, if it's still not starting...Dieter

Pages