#DateForumTypeThreadPost
27122 May 2008 @ 12:23 PDTUDAReplyBT/ETIn either form:If stmt 3 fails, all three (stmt 3, stmt 2, stmt 1) get rolled back.If stmt 2 fails, both stmt 2 and stmt 1 get rolled back. So far, so good.But a ROLLBACK implicitly ends the transa...
27019 May 2008 @ 08:58 PDTToolsReplyHow to use the the -S with tbuildIt appears -S is valid only for mainframe client, and only in TPT 12.0.
26919 May 2008 @ 05:11 PDTUDAReplyTransactionBTEQ does not recognize any special significance to BT/ET, it just treats them as SQL statements.Putting ";" at the beginning of the next statement causes BTEQ to concatenate the SQL and send it to...
26819 May 2008 @ 03:59 PDTToolsReplyFAST EXPORT - OUTMOD COBOL Routine FailingYou need to set RTEREUS ("run time environment reuse") option, because the main program is non-COBOL and non-conforming. For example, link-edit with custom CEEUOPT.
26715 May 2008 @ 01:42 PDTDatabaseReplyIs the popular opinion that DELETE ALL doesnt use the Transient Journal true?The ALL keyword is unimportant. You can get fast path delete behavior without ALL; conversely using ALL does not guarantee fast path.Fast path delete requires (among other restrictions) that the DE...
26612 May 2008 @ 09:35 PDTDatabaseReplyMerge helpThe "UPSERT" form does not allow a FROM clause (joined update). If using TD12.0, consider MERGE. (If you are not on TD12.0, MERGE is restricted to single-row operations - so appears unlikely to han...
26512 May 2008 @ 09:15 PDTToolsReplyFAST LOAD SET RECORD in Mainframe batch jobsNo. Channel attached (mainframe) clients always process logical records as ifSET RECORD UNFORMATTEDhad been specified.
26423 Apr 2008 @ 04:35 PDTToolsReplyCan I install TTU onto Windows Vista?TTU12.0 supports installing on Windows Vista for most components. See the "TTU Installation Guide for Windows" for details.
26321 Apr 2008 @ 03:55 PDTToolsReplyWhere to get eclipse plugin fromGo to the main www.teradata.com page, and under the Support option click on Download Center.
26202 Apr 2008 @ 11:58 PDTDatabaseReplyTeradata Maximums (V2R6) ?Check the Appendix in the appropriate release of the Database Design manual.
26131 Mar 2008 @ 04:48 PDTDatabaseReplyError 2666 Invalid TimestampBecause DATE - INTERVAL MONTH leaves the "day of month" unchanged.So date'2008-03-31' - INTERVAL '25' MONTH would be 2006-02-31Use ADD_MONTHS(CURRENT_DATE ,-25) instead. If the day of month is too ...
26029 Mar 2008 @ 12:53 PDTUDAReplyCollect Stats differenceOther than syntax, there is no difference between collecting stats on an index or on the same column(s). The same is true of the "CREATE INDEX form" versus "Legacy form" of COLLECT STATS statement....
25928 Mar 2008 @ 01:22 PDTConnectivityReplyJDBC and calling a macroYour multistatement macro returns both an update count and a result set. So you need to use the generic "execute" method, e.g.boolean isResultset = stmt.execute();// Returns FALSE, indicating first...
25814 Mar 2008 @ 08:14 PDTConnectivityReply.net provider setup in SSISCLI0510 Internal TDP-interface system-service error has been encountered.In other words, some Windows function that CLI called returned an unexpected status. You might check the Windows Event Logs ...
25707 Mar 2008 @ 08:16 PSTUDAReplyQuery Performance Optimization HelpLet's go back to basics. Maybe the SQL is fine and the problem lies elsewhere.What is the Primary Index of each table? Could it be extremely non-unique or highly skewed?Do both tables have the same...
25607 Mar 2008 @ 11:05 PSTDatabaseReplyHelp please with TD avg functionSo what you want is something like this?SELECT 'OUT OF RANGE'FROM (SELECT AVG(SALARY) AS AVG_SAL FROM EMPLOYEE_POSITION) ACROSS JOIN(SELECT AVG(SALARY) AS AVG_CTRL FROM EMPLOYEE_POSITION_CTRL) BWHE...
25506 Mar 2008 @ 08:09 PSTDatabaseReplyHelp please with TD avg functionEven as an Oracle query, this does not make sense as posted - because there appears to be no correlation and no join predicate. The WHERE clause is either always FALSE (so the query returns an empt...
25406 Mar 2008 @ 11:31 PSTDatabaseReplyLeap Year and Interval FunctionOne option:SELECT ADD_MONTHS(date'2008-02-29',-(65*12))
25305 Mar 2008 @ 09:39 PSTDatabaseReplySorting diffenceces - Order byThe default Teradata MULTINATIONAL collation sequence may do what you want. I don't think it matches SQL Server 100%, but it should sort underscores before letters. If all else fails, and this is a...
25203 Mar 2008 @ 12:56 PSTConnectivityReplyJava class libraries for MDSThe MDS Java class library was added in TTU8.2 release.
25103 Mar 2008 @ 10:02 PSTUDAReplyDecimal size limitation in TerdataTeradata V2R6.2 and later allow up to DECIMAL(38). But to answer your question, values will be rounded to fit in the number of decimal places defined.
25002 Mar 2008 @ 11:33 PSTToolsReplyProblem in importing data from text file to teradata database using bteqThe USING phrase must describe the input data, not the table. You used REPORT format for your export, so that data is CHAR not INTEGER. If you are using the default INTEGER format '-(10)9', then yo...
24902 Mar 2008 @ 11:09 PSTToolsReplyRecords in UV tableThe first (ET) error table is primarily for errors detected during the Acquisition phase. The second (UV) error table is for most errors detected during the Application phase. In general, this woul...
24828 Feb 2008 @ 10:12 PSTDatabaseReplyGlobal Tables and COLLECT STATISTICS ON TEMPORARYThe error message could be better, but the problem is that the second session has not yet materialized an instance of the global temporary table. To me, it's actually more surprising that the creat...
24708 Feb 2008 @ 12:16 PSTToolsReplyCOMP causing Mload faliureNote that your example data has more digits than the COBOL PIC clause at the top of this thread declares. (That may be allowed depending on your compiler options for "numeric truncation".)It's poss...

Pages