#DateForumTypeThreadPost
22417 Jun 2009 @ 01:50 PDTDatabaseReplyStoring images/PDF/.. in BLOBAnother option (with Teradata/TTU 12.0 and later) is BTEQ. Take a look at the LOBCOLS option in the import statement.
22317 Jun 2009 @ 01:10 PDTThird Party SoftwareReplyWill Teradatawork on Vista OS..Teradata Express Edition 12.0 is supported on Vista. It runs in 32-bit mode. The production licensed versions run on Windows 2003 Server and Linux 64-bit platforms.
22216 Jun 2009 @ 03:06 PDTToolsReplyALL AMPs SUMThe SUM step performs summarization (aggregation). It is used whenever a query contains an aggregate function (e.g. SUM, MAX, MIN, AVERAGE) or GROUP BY. The general method is to generate partial ...
22116 Jun 2009 @ 02:49 PDTDatabaseReplystoring docs in teradata database ?I assume "docs" are Microsoft Word document files. You can store them using the BLOB data type. In release 12.0, you can use BTEQ to import records containing the document file names. For more d...
22015 Jun 2009 @ 01:16 PDTDatabaseReplyHOW TO return last inserted row ?The Teradata 12.0 release provides a new feature that enables the auto-generated key value (or all the columnds inserted row) to be returned to the application. The feature is available through th...
21912 Jun 2009 @ 08:03 PDTDatabaseReplyHow to combine separate fields into oneUse the string concatenation operator:select trim(a) || '-' || trim(b) as combo from t1;combo------------19-0
21809 Jun 2009 @ 10:44 PDTDatabaseReplyGetting result in order from Select query.....Tables don't have any inherent order. You must use ORDER BY in your select if you want the result to be in a particular order.
21708 Jun 2009 @ 11:14 PDTDatabaseReplyprimary index hash valueYour understanding is still correct for non-PPI tables. With PPI, the row identifier is effectively extended by 16 bits to include the partition identifier.
21605 Jun 2009 @ 08:21 PDTDatabaseReplyHow to fix [3932] Only an ET or null statement is legal after a DDL Statement?Do a COMMIT before submitting the SELECT.
21505 Jun 2009 @ 01:52 PDTDatabaseReplyDelete ALLWhen executing the DELETE statement, Teradata simply flags the transaction as having a "deferred action" and writes a record describing the required action into the transient journal. At commit ti...
21405 Jun 2009 @ 01:41 PDTDatabaseReplyHow to generate random integer numbers by using a functionCast the result of RANDOM to float or decimal.select cast(random(0,999999999) as float)/1000000000 (format '9.999999999') as random_nbr;
21305 Jun 2009 @ 01:18 PDTAnalyticsReplyRandom valuesselect cast(random(0,999999999) as float)/1000000000 (format '9.999999999') as random_nbr; random_nbr-----------0.674948197
21204 Jun 2009 @ 04:04 PDTDatabaseReplyPartition Violation ErrorA PARTITION BY expression must return value between 1 and 65535.TD 12.0 increased the maximum value that can be returned by the HASHBUCKET function from 65535 to 1048575. This would have no effect...
21104 Jun 2009 @ 02:24 PDTDatabaseReplyDelete ALLDELETE ALL doesn't need to be rolled back if the transaction fails "in the middle" because the physical delete is not done until the transaction commits. That is why the delete optimization is onl...
21002 Jun 2009 @ 04:18 PDTDatabaseReplyNUSIActually, since V2R6.2, NUSI changes are journaled.
20931 May 2009 @ 03:45 PDTDatabaseReplyIssue with Teradata InstallationYou should download or order "Teradata Express Edition 12.0", which is known to run on Windows Vista and has available installation support. V2R6.1 is way out of date and was never tested on Vista...
20829 May 2009 @ 01:01 PDTToolsReplymLOAD DELETE JOBWhat you "knew" about Fastload is simply wrong. Just get it out of your head. What specifically did you find unclear about what I wrote?
20728 May 2009 @ 10:25 PDTAnalyticsReplyC and TeradataYour best bet is to use the ODBC call-level API. It's portable, and tutorials are available from comercial booksellers.
20628 May 2009 @ 05:14 PDTToolsReplymLOAD DELETE JOBFastload doesn't have an application phase. It distributes and pre-sorts the data as it arrives. A final merge of the pre-sorted buckets is done at the end of the acquisition phase. Then fallbac...
20506 May 2009 @ 11:55 PDTDatabaseReplyPE and AMP setupPEs can send requests to any or all of the AMPs in the system, including AMPs on other nodes.
20404 May 2009 @ 01:21 PDTToolsReplyfastload performanceBear in mind that a typical Teradata node this days has 8 CPU cores, 32GB RAM, and many disk spindles (which spin at 15K RPM). It can support perhaps 24 AMPs with one or more spindles per AMP for ...
20315 Apr 2009 @ 04:00 PDTDatabaseReplyOnly an ET or null statement is legal after a DDL StatementEvidently, Webfocus is using ODBC in "manual commit mode". This mode expects the application to call a certain ODBC function (SQLTransact, if memory serves) to commit the transaction, and the Tera...
20215 Apr 2009 @ 01:45 PDTToolsReplydifference betweem v2r5 & v2r6That appears to be a list of the new features in the minor release, V2R6.2. A list of all the majorenhancements since V2R5.x would include queue tables, stored procedures, table functions, user-de...
20110 Apr 2009 @ 01:53 PDTToolsReplyDifferences between bteq and mloadYou can execute standard SQL statements from BTEQ that perform many of the same bulk operations that you could do with MultiLoad, with excellent performance, though you need to be using Teradata 12...
20010 Apr 2009 @ 01:39 PDTDatabaseReplycan we use cursors in bteqsThere is no cursor equivalent in BTEQ. Teradata supports standard SQL cursors, but only in stored procedures or applications using one of the standard APIs (e.g., ODBC, JDBC). You could write a s...

Pages