#DateForumTypeThreadPost
2406 Jun 2006 @ 01:21 PDTDatabaseReplywhy this error was raised? help me!A correlated subquery might be faster. Try this:update TTEMP.TB_MID_NEW_INNET_SUBSCRIBERset Active_Month = 200604where Active_Month is nulland substr(cast(START_DATE as format 'YYYYMM'), 1, 6) = '...
2305 Jun 2006 @ 02:47 PDTUDAReplyTeradata UpgradeEvery new release contains many bug fixes, performance/availability/usability improvements, and new features. Consult the release documentation for details.
2205 Jun 2006 @ 01:13 PDTDatabaseReplywhy this error was raised? help me!Try this:update TTEMP.TB_MID_NEW_INNET_SUBSCRIBERfrom (select distinct MSISDN from PVIEW.VW_NET_GSM_NL_200604) aset Active_Month = 200604where Phone_No = a.MSISDN and Active_Month is nulland substr...
2105 Jun 2006 @ 01:00 PDTUDAReplyUnloads from DB2 (nullable fields) - How to manage this with Fastload?The NULLIF method doesn't work for numeric data types. To capture null values properly, you will need to convert your data to the kTeradata indicator format.
2001 Jun 2006 @ 01:32 PDTDatabaseReplyDifference between Teradata Utilities and ETL ProcessThis Wikipedia article may be helpful: http://en.widipedia.org/wiki/Etl
1931 May 2006 @ 03:58 PDTDatabaseReplyAMP on Teradata is UTILITY/DOWNI assume that by "doing a REBOOT on this AMP" you mean that you used the BOOT command of Vprocmanager. The purpose of that command is prepare the AMP for a complete rebuild. Therefore, it erases ...
1825 May 2006 @ 11:29 PDTDatabaseReplyCLOB in Stored Procedure is not workingEvidently, it should have failed to compile due to the duplicate definition of "myclob". This appears to have been fixed recently, but I don't know which release has the fix.
1719 May 2006 @ 05:09 PDTDatabaseReplyData DistributionIt all depends on how you define the primary index. You can place the rows all on one AMP, or you can distribute them randomly. If the table will never have more than a few rows, it would make se...
1604 May 2006 @ 10:46 PDTToolsReplyHow to display all columns with betq commandUse the ".set foldline on" command to allow BTEQ to fold a row across multiple lines. For a prettier format, also ".set sidetitles on".
1504 May 2006 @ 10:35 PDTDatabaseReplyHow to find a lost password for a userBy design, passwords are stored in DBC.DBase using a one-way encryption method. If you forget a password, consider it gone forever.
1419 Apr 2006 @ 06:50 PDTDatabaseReplyWrite/Read external file from within Stored Procedure?There is no good way to do that with Teradata. Even if methods for accessing the host OS file system were available, it probably would not be useful on MPP configurations, since you don't have con...
1305 Apr 2006 @ 01:34 PDTToolsReplyNumeric overflowIt may be worth mentioning that the upcoming release V2R6.2 will support up to 38 digits for the DECIMAL data type.
1230 Mar 2006 @ 11:51 PSTDatabaseReply"wait" operation in a Stored ProcedureI suppose a UDF could be written to perform this function. However, your application might be better served using a queue table. A queue table is a table that can be used as a FIFO event queue. ...
1127 Mar 2006 @ 02:48 PSTDatabaseReplynumber of CPUs per nodeI think that method would work only if RSS logging is turned on. I suppose the most general method would be to look up the hardware specs for your server nodes. If those are not available for som...
1013 Mar 2006 @ 12:55 PSTDatabaseReplyTable sizing in bytesFor an existing, populated table, you can query DBC.TableSize.Example:Select sum(currentperm) from dbc.tablesize where databasename = 'mydbname' and tablename = 'mytablename';
928 Feb 2006 @ 12:20 PSTToolsReplyPartitioned tables: multiload vs JDBCPartitioning has no effect on locking granularity, so concurrency is the same. There is no partition level locking.Multiload always locks the entire table. Single row inserts and updates (assumi...
828 Feb 2006 @ 12:09 PSTDatabaseReplyLocking modifer for a MSRThe two requests are equivalent, so the execution plans are identical as shown by the explains. What difference were you expecting?
724 Feb 2006 @ 02:28 PSTDatabaseReplyNegative spool while monitoring SessionAre you using a very old version? Negative spool space problems were supposedly fixed a long time ago (V2R3.1).
610 Feb 2006 @ 02:23 PSTDatabaseReplyTools to compare two teradata's DB and find the differencesDo you want to compare the contents of tables, or are you just looking for schema differences?
508 Feb 2006 @ 03:35 PSTUDAReplyDeadlock and isolation levelsIf your application queries a table and then updates it within the same transaction, it is vulnerable to a classic deadlock scenario. The query will acquire a read lock and then attempt to upgrade...
402 Feb 2006 @ 11:29 PSTDatabaseReplyDelete / truncate commandNo, DROP TABLE is very fast, regardless of table size. It does not log individual rows.
326 Jan 2006 @ 11:30 PSTDatabaseReplyDelete / truncate commandIn general, the unqualified delete statement uses a "superfast" method similar to what you described for the truncate command (and essentially the same as for drop table) whenever it can do so with...
204 Jan 2006 @ 03:42 PSTDatabaseReplyCancel online transaction recovery after break big delete operationYou can use the CANCEL ROLLBACK ON TABLE command of the Recovery Manager utility. I believe this is available in 5.1 and later releases. If you use this command, the table is marked unusable, and...
103 Jan 2006 @ 03:48 PSTDatabaseReplyGateway portsAll Teradata clients connect to TCP port 1025. That is the only port that you should need to forward through your firewall.

Pages