271 | 22 May 2008 @ 12:23 PDT | UDA | Reply | BT/ET | In 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... |
270 | 19 May 2008 @ 08:58 PDT | Tools | Reply | How to use the the -S with tbuild | It appears -S is valid only for mainframe client, and only in TPT 12.0. |
269 | 19 May 2008 @ 05:11 PDT | UDA | Reply | Transaction | BTEQ 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... |
268 | 19 May 2008 @ 03:59 PDT | Tools | Reply | FAST EXPORT - OUTMOD COBOL Routine Failing | You 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. |
267 | 15 May 2008 @ 01:42 PDT | Database | Reply | Is 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... |
266 | 12 May 2008 @ 09:35 PDT | Database | Reply | Merge help | The "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... |
265 | 12 May 2008 @ 09:15 PDT | Tools | Reply | FAST LOAD SET RECORD in Mainframe batch jobs | No. Channel attached (mainframe) clients always process logical records as ifSET RECORD UNFORMATTEDhad been specified. |
264 | 23 Apr 2008 @ 04:35 PDT | Tools | Reply | Can 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. |
263 | 21 Apr 2008 @ 03:55 PDT | Tools | Reply | Where to get eclipse plugin from | Go to the main www.teradata.com page, and under the Support option click on Download Center. |
262 | 02 Apr 2008 @ 11:58 PDT | Database | Reply | Teradata Maximums (V2R6) ? | Check the Appendix in the appropriate release of the Database Design manual. |
261 | 31 Mar 2008 @ 04:48 PDT | Database | Reply | Error 2666 Invalid Timestamp | Because 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 ... |
260 | 29 Mar 2008 @ 12:53 PDT | UDA | Reply | Collect Stats difference | Other 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.... |
259 | 28 Mar 2008 @ 01:22 PDT | Connectivity | Reply | JDBC and calling a macro | Your 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... |
258 | 14 Mar 2008 @ 08:14 PDT | Connectivity | Reply | .net provider setup in SSIS | CLI0510 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 ... |
257 | 07 Mar 2008 @ 08:16 PST | UDA | Reply | Query Performance Optimization Help | Let'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... |
256 | 07 Mar 2008 @ 11:05 PST | Database | Reply | Help please with TD avg function | So 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... |
255 | 06 Mar 2008 @ 08:09 PST | Database | Reply | Help please with TD avg function | Even 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... |
254 | 06 Mar 2008 @ 11:31 PST | Database | Reply | Leap Year and Interval Function | One option:SELECT ADD_MONTHS(date'2008-02-29',-(65*12)) |
253 | 05 Mar 2008 @ 09:39 PST | Database | Reply | Sorting diffenceces - Order by | The 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... |
252 | 03 Mar 2008 @ 12:56 PST | Connectivity | Reply | Java class libraries for MDS | The MDS Java class library was added in TTU8.2 release. |
251 | 03 Mar 2008 @ 10:02 PST | UDA | Reply | Decimal size limitation in Terdata | Teradata 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. |
250 | 02 Mar 2008 @ 11:33 PST | Tools | Reply | Problem in importing data from text file to teradata database using bteq | The 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... |
249 | 02 Mar 2008 @ 11:09 PST | Tools | Reply | Records in UV table | The 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... |
248 | 28 Feb 2008 @ 10:12 PST | Database | Reply | Global Tables and COLLECT STATISTICS ON TEMPORARY | The 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... |
247 | 08 Feb 2008 @ 12:16 PST | Tools | Reply | COMP causing Mload faliure | Note 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... |