#DateForumTypeThreadPost
27406 May 2010 @ 11:19 PDTGeneralReplyTeradata 2580 TPMAs far as I know, no DBMS vendor publishes TPM claims these days. There is no well-defined TPM metric. Anway, like all the data warehouse appliances, the 2580 is optimized for complex queries.
27327 Apr 2010 @ 12:37 PDTCloud ComputingReplyCreating new DB without TD Admin / DB Manager (Windows client)Look up the CREATE USER and CREATE DATABASE statements in the Teradata SQL reference manual.
27221 Apr 2010 @ 11:27 PDTUDAReplyETL CLOB from Oracle to TeradataSince I last posted on this thread back in 2006, the utility support for large objects has improved somewhat. In addition to the BTEQ support, The TPT (parallel transporter) utility now supports l...
27119 Apr 2010 @ 10:42 PDTDatabaseReplyMERGE vs UPSERTThe MERGE statement is more general. It supports all the functionality of upsert and has some additional capabilities. MERGE is supported by the ANSI/ISO SQL standard, so it is more portable.
27019 Apr 2010 @ 10:35 PDTDatabaseReplyMultiLoad - errorThis message is complaining that some cluster contains only one AMP. In general, the configuration should be defined so that each cluster contains at least 2 AMPs.
26916 Apr 2010 @ 02:25 PDTDatabaseReplyJunk Characters in FASTEXPORTED Flat file..It appears that the utility is ignoring the FORMAT clause in your EXPORT statement and defaulting to FASTLOAD format. In that mode, each record is preceded by a 2-byte binary record length indicat...
26816 Apr 2010 @ 02:03 PDTDatabaseReplyMERGE vs UPSERTTeradata (as of release 12.0) supports both the ISO/ANSI standard SQL MERGE statement and the UPDATE...ELSE INSERT syntax. That latter is commonly known as "upsert".
26715 Apr 2010 @ 01:28 PDTDatabaseReply[Error 8505] [SQLState HY000] LOB ID could not be generatedIf it errored out after so few rows, your choice (explicitly or by default) of primary index column must be extremely poor. This would be a problem in any case--you may notice that the table has a...
26608 Apr 2010 @ 06:25 PDTAnalyticsReplyRecord distribution in AMPLook up the HASHAMP fiunction in the Teradata SQL documentation.
26502 Apr 2010 @ 01:54 PDTDatabaseReplyInserting space as value from a char column to varchar columnTeradata implicitly trims trailing spaces when converting char(n) values to varchar(n). Assuming that this is only a problem when the source value is all spaces, you can use a case expression like...
26401 Apr 2010 @ 11:31 PDTGeneralReplyBTEQ Import Data file errorWhat part of "column name list longer than value list" don't you understand? If you still can't find your syntax error, post your insert statement to get more help from this forum.
26331 Mar 2010 @ 12:52 PDTDatabaseReplysoftware & Hardware configuration in teradata..CTL is not a database console utility. You will find instructions for running it in the utilities manual.
26231 Mar 2010 @ 10:39 PDTDatabaseReplysoftware & Hardware configuration in teradata..CTL displays/updates information from the Control GDO, and it works exactly the same on Windows and Linux. See the utilities manual in the Teradata documentation set for details.
26126 Mar 2010 @ 10:27 PDTDatabaseReplyTD 13The most significant new features of each release are itemized the Release Summary in the documentation set for that release, which you can find at this site (http://www.info.teradata.com/).
26025 Mar 2010 @ 02:15 PDTDatabaseReplyCompile Stored Procedures in BatchYou can recompile an existing procedure by submitting an ALTER PROCEDURE statement. Example: ALTER PROCEDURE myprocname COMPILE ;
25917 Mar 2010 @ 11:26 PDTExtensibilityReplyTable function with variable input-output paramsYou can find examples (for both C and Java) in Appendix A of "SQL External Routine Programming" in the documentation library for 13.0. The number of formal parameters is fixed by the function def...
25817 Mar 2010 @ 10:46 PDTDatabaseReplyHow many sessions maximum can be assignedEach PE can handle 120 sessions. There is a tunable limit on the number of network-connected sessions per gateway, and the maximum that has been certified is 1200. Prior to Teradata 13.0, there ...
25705 Mar 2010 @ 10:18 PSTAnalyticsReplyOrder of joined tablesThe order shouldn't matter. Inner joins are commutative, and the Teradata query optimizer will attempt to apply the operations in the order that results in the least cost.
25604 Mar 2010 @ 03:57 PSTDatabaseReplyExport resultset to file A stored procedure runs on the Teradata server. It cannot write directly to a client file. A stored procedure can declare a cursor to be returned as a result set to the client, and a client suc...
25504 Mar 2010 @ 03:38 PSTDatabaseReplyURGENT : Using SELECT statement in dynamic SQLIt's true that you cannot use a select statement in dynamic SQL, but you can use a subquery, like this: set-vstrsql = 'insert into Cfstagedev.Table_Test_automation select count(1) from' || str...
25426 Feb 2010 @ 08:17 PSTDatabaseReplySending email from Procedure".OS" is a BTEQ command. I would not expect that to work in a stored procedure.You can write an external stored procedure in Java or C, which could call any function that is supported by the langu...
25324 Feb 2010 @ 05:27 PSTDatabaseReplyStored Procedures in Teradata!!The CALL statement is used to invoke a stored procedure.The EXECUTE statement is used to invoke a macro.
25219 Feb 2010 @ 01:52 PSTDatabaseReplyHow to find blocksize of a able in teradata?Teradata does not have a TRUNCATE statement or any notion of a "highwater mark", but you may delete a table's entire contents using the DELETE statement without any WHERE condition. The resulting ...
25118 Feb 2010 @ 01:46 PSTDatabaseReplyInteger to Bigint datatype conversionThat can't be done with a single ALTER TABLE command. The SQL manual is your friend. See the topic "Rules for Changing the Column Data Types" and "Procedure to Change Column Data Types" in the sec...
25017 Feb 2010 @ 06:56 PSTDatabaseReplyCreating new tablesThe format code in the minutes field should be 'mi' not 'mm':create table test1 (a int, b time format 'hh:mi:ss');insert into test1 values (1, current_time); *** Insert completed. One row added. **...

Pages