#DateForumTypeThreadPost
64624 Apr 2015 @ 04:41 PDTConnectivityReplyWhere is SQL-H Documentation?Check the Aster Database User Guide for your version on www.info.teradata.com
64516 Apr 2015 @ 10:21 PDTDatabaseReplyWhat is RHL lock modeRHL = Read HUT Lock In other words, this is an archive lock; it would also show up if you run showlocks utility. In arcmain, you can explicitly RELEASE LOCK (DEMO_DEV), OVERRIDE; OVERR...
64416 Apr 2015 @ 09:57 PDTDatabaseReplynumber of CPUs per nodeWith HyperThreading enabled (two instruction pipelines per core), the number of "virtual CPUs" reported by the OS is twice the number of physical cores.
64309 Apr 2015 @ 09:31 PDTDatabaseReplyHow to find the result of the previous row in TeradataHow do you get the rows into the order in your example? What are you using for PARTITION BY / ORDER BY in the OVER clause? And which database release?
64202 Apr 2015 @ 09:07 PDTConnectivityReplyTeradata connectivity Issue through JDBC Driver in javaRemove the space from your connection string.
64102 Apr 2015 @ 08:52 PDTDatabaseReplyTruncation of Leading Zeros in BTEQ ExportCAST the column to apply a FORMAT that includes leading zeros, if that's what you want in your output.
64001 Apr 2015 @ 09:31 PDTDatabaseReplyHow to find if a varchar field has 9 digit intergersTry explicitly translating the literals (which are implicitly Unicode) to Latin:   REGEXP_SIMILAR(x, translate('[0-9]{9}' using Unicode_to_Latin), translate('i' using Unicode...
63901 Apr 2015 @ 09:27 PDTDatabaseReplyTracing stored procedure parameter values Not sure of the question. Did you enable query logging with the PARAMINFO option?
63801 Apr 2015 @ 09:22 PDTTeradata ApplicationsReplyUnity Source LinkIn TD15.0 and later, Teradata QueryGrid allows Teradata-to-Teradata access, leveraging table operators.
63701 Apr 2015 @ 09:12 PDTDatabaseReplyImportance of format 'X(n)' in varcharBecause you didn't change it. The default format is assigned only when a column is created without explicit FORMAT. Best practice is to simply ALTER the FORMAT in the same statement as th...
63628 Mar 2015 @ 10:30 PDTDatabaseReplyLocking Table for ShareYes, SHARE is a (deprecated) synonym for READ.
63527 Mar 2015 @ 03:09 PDTDatabaseReplyHow to check size of the table with compress and without With a single row, the difference is only 4 bytes, which is much smaller than the minimum data block size.   What you are seeing in TableSize reflects a table header on e...
63427 Mar 2015 @ 02:57 PDTDatabaseReplyHow to determine Number of AMPs and Number of Nodes ?The number of AMPs per node is configured by Teradata when the system is ordered, and is not something the customer can change. In general it depends on the specific hardware configuratio...
63327 Mar 2015 @ 02:36 PDTGeneralReplyDatatype of a column from dbc tablesAre you asking about getting the keyword spelled out, e.g. SMALLINT vs. I2?  Then the answer is no, that's not in any DBC table. Depending on what you are trying to do, you might con...
63227 Mar 2015 @ 02:15 PDTDatabaseReplyCreating function returning DATE from tableTrue, SQL UDFs cannot do SELECT. Why not define a SQL UDF that simply returns a date which is specified as a literal in the function body, and change the other process to do REPLACE...
63125 Mar 2015 @ 12:56 PDTConnectivityReplyRHEL7 Teradata client 15.00 cannot connect: Specified driver could not be loadedThose "missing" files are part of the tdicu package and should physically be in /opt/teradata/client/15.00/tdicu/lib64 with links in /usr/lib64. Did tdicu install correctly? Is /usr...
63024 Mar 2015 @ 09:40 PDTTeradata ApplicationsReplyFast export errorError code 34 from Data Connector is just "fatal error has occurred"; error code 32 on fwrite is "broken pipe". So you would need to figure out why the consuming process aborted...
62924 Mar 2015 @ 09:30 PDTConnectivityReplyPassword encryption mechanism for ODBC client application users.Re: the original question The gtwcontrol option (in older releases) applies to encryption "over the wire" when the logon request is sent from the client to the database.  
62821 Mar 2015 @ 09:34 PDTToolsReplyCan TPUMP load to one db and put error/log tables in another?By "third party", I mean the macros are not in the user database for the username that TPump / Stream is logged on with, nor are they in the same database as the targe...
62721 Mar 2015 @ 08:56 PDTDatabaseReplySET Vs MULTISETSome duplicate row checking must still be done even with a unique index, since SET table semantics call for duplicate rows to be quietly eliminated (no error thrown) in multi-row operations su...
62620 Mar 2015 @ 03:26 PDTToolsReplyFastload Logtable errorThey are not recorded in any DBC or SysAdmin table. CheckTable PendingOp inspects the table header to find these persistent utility locks.
62518 Mar 2015 @ 10:02 PDTDatabaseReplyNon duplicate row selection queryAre there are a small number of columns that together would be suitable as NUPI, i.e. well-distributed and ideally not too many duplicates? If so, then explicitly redistributing by those columns (e...
62418 Mar 2015 @ 09:45 PDTGeneralReplyAccess Teradata Vmware Server from Windows 7 64 bit client By default, the Virtual Machine's network adapter connection setting is "NAT", so you can access it via the name "localhost" (or IPv4 address 127.0.0.1 / IPv6...
62313 Mar 2015 @ 03:40 PDTDatabaseReplyInstallation and configuration of Teradata 15 on my home laptop with Windows 8.1 OSSee http://downloads.teradata.com/download/database/teradata-express/vmware Yes, free VMWare Player will be needed to run Teradata Express database. Most likely what you already ins...
62213 Mar 2015 @ 03:35 PDTDatabaseReplyCOMPRESSION for TIMESTAMP field in TD14Multi-Value Compression is not supported for INTERVAL data types, at least through TD15.0 Also note that an INTERVAL constant must always include an interval qualifier, e.g. DAY TO SECOND, af...

Pages