#DateForumTypeThreadPost
34930 Apr 2011 @ 05:22 PDTDatabaseReplyAutomatic compression of NULL valuesI don't think that feature exists in any release. The most significant compression enhancements are in 13.10, which provides column compression for variable fields, algorithmic compression, and bl...
34828 Apr 2011 @ 03:14 PDTToolsReplybteq export issueNote that the default format of TVM.RequestText is 'X(255)' but the column type is VARCHAR(12500). Try this... select requesttext (format 'x(12500)') ....
34726 Apr 2011 @ 11:04 PDTToolsReplybteq for Solaris 10 on Intel XeonIntel/Xeon/Solaris 10 is certainly supported. For a complete report of supported platforms and versions for Teradata Tools and Utilities, search for publication B035-3119- on www.info.teradata.com...
34621 Apr 2011 @ 05:37 PDTDatabaseReplyError in TRIGGER with null valueSorry for this delayed answer, but your case led to some discussion among the developers as to whether it is a bug. The jury is still out on that question. Personally, I think it is a bug. The e...
34519 Apr 2011 @ 05:22 PDTGeneralReplyselect command using BTEQ is not returning all fieldsThe answer to your first question is that BTEQ truncates the displayed output lines according to your output width setting, which is 75 characters by default. use the ".SET WIDTH" command to increa...
34418 Apr 2011 @ 06:29 PDTDatabaseReplyValid SQL LEFT() function equivalent?Yes. Casting to a fixed character type returns a fixed length string. The operand value will be padded with trailing spaces or truncated to the required length.
34318 Apr 2011 @ 01:22 PDTDatabaseReplyValid SQL LEFT() function equivalent?SELECT CAST(column AS CHAR(5)) FROM table
34212 Apr 2011 @ 01:39 PDTDatabaseReplyCOMPRESSIONDo the CHAR(50) values contain leading blanks? Leading blanks are signficant in character comparisons. By the way, Teradata (as of release 13.10) now allows compression on VARCHAR type columns.
34111 Apr 2011 @ 11:42 PDTGeneralReplyTeradata V12 - 1 TB - VMWARE - root parition expansion problem. The limit is only 16 GB . How to expandIf you are using VMWare Workstation, another option would be to store your data files in a folder of the host OS file system and use the VMWare "shared folder" feature to mount the folder on the L...
34011 Apr 2011 @ 11:05 PDTGeneralReplyTeradata V12 - 1 TB - VMWARE - root parition expansion problem. The limit is only 16 GB . How to expandThe root partition is the 2nd partition of the 1st disk (i.e., /dev/sda2). However, I don't think you can expand the root partition without destroying its contents. As an alternative, consider ei...
33931 Mar 2011 @ 02:35 PDTAnalyticsReplySELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword.Which Teradata version are you using? Scalar subqueries in the select list were not supported until 13.0.
33829 Mar 2011 @ 11:34 PDTCloud ComputingReplyTeradata 12 1 TB VM in vSphere 4.0As far as I am aware, Teradata Express for VMWare cannot run on vSphere or ESXi. It is compatible only with VMWare's Workstation, Player, and standalone Server products.
33728 Mar 2011 @ 10:21 PDTExtensibilityReplyUDF overloading issueQuite so. The argument type is ambiguous. You can do something like this: select isNumeric(cast(null as char));
33622 Mar 2011 @ 03:11 PDTCloud ComputingReplyGetting Internet Access from TD13 SuSe VM InstanceYes, for bridged mode it is likely that you will need to configure the (virtual) network card for your network.
33522 Mar 2011 @ 02:03 PDTDatabaseReplyCan't use count with in a view...In general, count is allowed in a view. It's the WITH clause that is not allowed. Also, ORDER BY is not allowed in a view. Those constructs are disallowed because a view must define a relation....
33407 Mar 2011 @ 11:00 PSTDatabaseReplyRE: Partitioned Primary Indexes (PPI) -- Altering PartitionsA new feature in 13.10 allows you to use CURRENT_DATE or CURRENT_TIMESTAMP in a partitioning expression. However, it is not reevaluated automatically. You must periodically execute the statement...
33307 Mar 2011 @ 10:51 PSTDatabaseReplyhow to delete a journalThe MODIFY DATABASE statement you quoted appears to be syntactically incorrect.
33228 Feb 2011 @ 10:15 PSTDatabaseReplyHow to Control Data Distribution in Teradata ?You can force all the rows to be on the same AMP by defining a NUPI on a single column that is set to a constant value.
33123 Feb 2011 @ 11:08 PSTAnalyticsReplyEquivalent of %TYPE and %ROWTYPE in teradataTeradata (as of 13.10) has no syntax equivalent to the Oracle %TYPE and %ROWTYPE. Variables of any type may be declared in a procedure, but the exact type must be specifed directly.
33016 Feb 2011 @ 09:44 PSTDatabaseReplyBynet Protocol EmulationThe answer is probably no, but the question is really moot. The MPP systems that ship with Ethernet instead of the physical Bynet are all in the appliance series (e.g. 2xxx), which are exclusiv...
32911 Feb 2011 @ 01:33 PSTUDAReplyI need assistance on modify tableThe Teradata alter table statement does not allow the identity column attribute to be specified or changed, either for an existing column or an added column. Identity columns can be defined only i...
32807 Feb 2011 @ 05:40 PSTDatabaseReplyDifference between features V2R5,TD12 and TD13?The difference is 3 major releases and at least 3 very signficant minor releases, or about 10 years of product development. You can find details in the release summaries in the Teradata documentati...
32726 Jan 2011 @ 12:53 PSTDatabaseReplyView all current amp locksIf by "amp locks" you mean transaction locks, the LOKDISP console utility can report that information. See the Teradata Utilities manual for details.
32624 Jan 2011 @ 11:10 PSTToolsReplyRegarding Temporary SpaceTo elaborate on the goals and reasons, we introduced temp space along with the global temporary tables feature. Its sole purpose is to support temporary tables. Since temporary tables have a diff...
32518 Jan 2011 @ 06:20 PSTDatabaseReplyCoalesce needThe result of the concatenation is null if either operand is null. The purpose of COALESCE is to ensure a non-null final result.

Pages