#DateForumTypeThreadPost
14620 Mar 2007 @ 11:22 PDTDatabaseReplyCOLLECT STATISTICS on Empty tableCOLLECT STATISTICS on specific index(es) or column(s) of an empty table makes those statistics non-NULL in the dictionary tables so you can use the "refresh" form of the commmand later (COLLECT STA...
14520 Mar 2007 @ 11:13 PDTDatabaseReplyFew QuesFor this sort of information, check the System Limits appendix in the Database Design manual.Maximum joins per query block = 64No limit imposed by the system on number of rows scanned
14413 Mar 2007 @ 07:59 PDTToolsReplydownload TTUYou can download patches / fixes to individual client software components via Teradata @ Your Service if you have an account. But for the full TTU bundle, call your Teradata sales rep.
14313 Mar 2007 @ 07:54 PDTDatabaseReplyExternal Stored ProcedureYou are executing this in BTEQ? (Specifier CS is not valid for ODBC.)What version of CLIv2? You'll need at least the TTU8.0 level of drivers and utilities...
14209 Mar 2007 @ 08:55 PSTToolsReply.Logon ... using DMTEQ Capability---problemWhen you use the Teradata Manager scheduler, the "..." should pick up the information entered in the Logon section of the System tab (under Administer / Teradata Manager). Perhaps that information ...
14107 Mar 2007 @ 07:41 PSTConnectivityReplySQL Native Client and the Provider StringSQL Native Client is for access to SQL Server 2005. You will need to install a Teradata provider (OLEDB or .NET) and use that.
14007 Mar 2007 @ 11:51 PSTUDAReplyTable QueryIf the text of the Stored Procedure was saved in the database when it was compiled, it can be retrieved via SHOW PROCEDURE. It's not stored in the DBC dictionary tables but in a special "subtable" ...
13907 Mar 2007 @ 11:46 PSTUDAReplyEquivalent utilities of Teradata Vs sql SERVERBTEQ is probably closest equivalent to OSQL; SQL Assistant (Queryman) would usually be preferred for interactive use.
13807 Mar 2007 @ 11:40 PSTDatabaseReplyAlter table Column Rename is not workingYes, I believe it's a documentation error.Either TO or AS is acceptable. One or the other must be specified, but not both.
13707 Mar 2007 @ 11:31 PSTToolsReplyFastload logonThe .RUN command was added to FastLoad in TTU8.0 (FastLoad 7.6).
13607 Mar 2007 @ 11:25 PSTDatabaseReplyTables to Views Cross ReferenceCheck out Teradata Meta Data Services. The good news is that it's supplied free with your Teradata system. The bad news is you need to provide a Windows server, and setup and administration is not ...
13507 Mar 2007 @ 11:15 PSTToolsReply.Logon ... using DMTEQ Capability---problemSounds like your versions of CLIv2 and DMTEQ (or Teradata Manager bundle) are incompatible. Use ".SHOW VERSIONS" in DMTEQ to see version of CLIv2 in use. This can also happen if you have more than ...
13428 Feb 2007 @ 07:34 PSTDatabaseReplyIs god is creating these new tables???????Those "error tables" are created in the process of adding a referential constraint. See the explanation under ALTER TABLE in the SQL Reference.
13326 Feb 2007 @ 06:11 PSTConnectivityReplySQL Server Analysis Services 2005 and Teradata .NET providerThe provider wants to know what version of Teradata DBMS you're using (TdConnection.ServerVersion property). SELECT access for the DBC.DBCInfo view should normally be granted to PUBLIC. I can't thi...
13221 Feb 2007 @ 12:01 PSTDatabaseReplyNeed to delete duplicate records from tableApplications cannot reference internal ROWID directly in current releases. (In some releases it may be possible to enable this deprecated functionality for backward compatibility, but since the opt...
13120 Feb 2007 @ 11:52 PSTDatabaseReplyHow to split one row into multiple rows.You can CROSS JOIN to a table with 52 rows (e.g. just SMALLINT values 1 to 52) and use CASE to determine the value of the "INDEXn" field. Is that any better?
13020 Feb 2007 @ 02:11 PSTDatabaseReplySkewed Queries - Cancel or Restrict CPU ?The query will hold AMP Worker Tasks, memory, locks, etc. and in a saturated system that can make a difference. But if it takes that long to re-stabilize, you may need to review your overall worklo...
12919 Feb 2007 @ 08:59 PSTDatabaseReplySkewed Queries - Cancel or Restrict CPU ?Assigning skewed queries to an allocation group that has a very small CPU limit (or ABSolute scheduling policy if you are on an old release) will limit the impact on other work.I don't think there ...
12817 Feb 2007 @ 11:38 PSTToolsReplynew line characterIf you are going to use LIKE to find rows with LF, the syntax would be LIKE '%'||'0A'xc||'%'The "oreplace" UDF (included in the "Oracle-style functions" download from Teradata.com) or something si...
12716 Feb 2007 @ 02:41 PSTDatabaseReplyPPIIn Teradata, the Primary Index is not a physical database object or "subtable" like other indexes are. PI is the method used to determine where rows are placed. Partitioning also deals with placeme...
12615 Feb 2007 @ 01:43 PSTAnalyticsReplyABENDU10??Add SYSPRINT to your step JCL, e.g. //SYSPRINT DD SYSOUT=*
12515 Feb 2007 @ 01:24 PSTDatabaseReplyFASTLOADFastLoad can do simple conversions like this; you just need to explicitly specify the correct FORMAT specification in the INSERT. :inFld (FORMAT '999V99')
12415 Feb 2007 @ 12:43 PSTDatabaseReplyPPIIf you use PARTITION BY clause, Teradata will hash the PI to an AMP then "partition the PI" within the AMP. It's still called "PPI" even if the partitioning expression references a column that isn'...
12315 Feb 2007 @ 12:26 PSTToolsReply2555 : Table does not belong to the MLoad jobMost likely, this indicates a prior MLoad (that referenced some of the same target and/or error tables as your BEGIN statement for this job) failed and was not properly restarted or cleaned up.
12214 Feb 2007 @ 05:28 PSTDatabaseReplyIdentity Column Difference between Teradata & Data StageBecause DataStage is inserting individual rows (serially) but INSERT SELECT runs in parallel.See "Process for Generating Identity Column Numbers" in the SQL Reference / Data Definition Statements u...

Pages