#DateForumTypeThreadPost
2720 May 2008 @ 05:23 PDTDatabaseReplyConcatenation Of two Strings.......You cant do that with macro's! Its possible to create a dynamic SQL with Stored Procedures.REPLACE procedure MyProc (IN WhereCondition varchar(100)) BEGIN CALL DBC.SysExecSQL('select * fr...
2616 May 2008 @ 05:48 PDTDatabaseReplyConcatenation Of two Strings.......I am not sure how you want the final result to be.Shouldnt you be using the || operator in the SELECT list?example: SELECT 'HELLO' || ' WORLD';
2516 May 2008 @ 05:43 PDTDatabaseReplyParsing a row to create multiple rowsOne way to do it is to retrieve the row into MSWORD and replace all occurences of the comma character with the following text');^linsert into temptable('This should give rows in the following forma...
2416 May 2008 @ 05:35 PDTDatabaseReplyIs the popular opinion that DELETE ALL doesnt use the Transient Journal true?I have seen the term fast path delete in the V2R6.1 SQL Reference for DML's but it doesnt explicitly say anything about the Transient Journal activity. I therefore didnt want to make a personal int...
2315 May 2008 @ 08:10 PDTDatabaseTopicIs the popular opinion that DELETE ALL doesnt use the Transient Journal true?Hi,There is popular opinion among the TERADATA user community that "DELETE ....ALL" doesnt use the Transient Journal. Is this true?I tried testing this with an explicit transaction (within a BT-ET)...
2213 Mar 2008 @ 03:47 PDTDatabaseReplyrowid in TeradataByte data must be suffixed with 'xb'. Try the following.sel e_name from test where rowid='0000C500B17E00000100'xb;-Foxbat
2111 Mar 2008 @ 02:21 PDTDatabaseReplyavoid exclusive lock during inserts on a tableThe multiple Insert Select statements execute serially as they contend for table level Write Locks on the destination table.It will help if you run the multiple inserts as a Multi Statement Reques...
2006 Mar 2008 @ 06:51 PSTDatabaseReplyavoid exclusive lock during inserts on a tableTo avoid the problem either run the inserts as implicit transactions (without BEGIN TRANSACTION and END TRANSACTION) or use a load utility (FASTLOAD/ MULTILOAD)
1906 Mar 2008 @ 06:44 PSTDatabaseReplyavoid exclusive lock during inserts on a tableI assume you are using BTEQ to load the data into a table that has a Non Unique Primary Index. If the Primary Index column has a large number of repeating valuesAND If your insert statements are wi...
1806 Mar 2008 @ 06:29 PSTDatabaseReplyIdentify deleted recordsThe NOT EXISTS form of your Query is probably processed as a correlated subquery. Some of them are known to consume a lot of time and resource.Try rewriting your query using the NOT IN form. LOCKIN...
1727 Feb 2008 @ 06:39 PSTUDAReplyWhat is a HOT AMPWhen the workload is not distributed across all the AMPs, only a few AMPs end up overburdened with the work. This is a hot AMP condition.This typically occurs when the volume of data you are dealin...
1627 Feb 2008 @ 06:27 PSTAnalyticsReplyAnalyze explain planLearning to understand the EXPLAIN output is like learning a foriegn language (example: Japanese...assuming you aren't Japanese!).And the task becomes relatively easy if you start EXPLAINing small ...
1522 Feb 2008 @ 05:18 PSTUDAReplyEXISTS vs. INThe SQL that uses EXISTS may be processed as a correlated subquery. Experience shows that certain correlated subqueries take longer to process than similar SQL's which use a JOIN to achieve the sam...
1404 Feb 2008 @ 05:15 PSTJobsReplyTeradata CertificationDear Abubhai,Going by experience I think its unwise to attempt the certification without prior hands on experience. Certification without experience makes the person hollow.A paper certificate is w...
1312 Oct 2007 @ 02:54 PDTDatabaseTopicDELETE ALL vs DELETEA few TERADATA users in the community recommend use of the DELETE FROM ALL; /*Teradata extension to ANSI SQL 2003*/syntax over DELETE FROM ; /*ANSI syntax*/I am under the impression that bo...
1206 Sep 2007 @ 04:18 PDTToolsTopicUnable to fastload byte data from a data file with ascii text properlyI am having trouble fastloading data from an ascii text file into a table with column with data type BYTE. The data loaded is different from what I want.The data in the text file has two recordsSou...
1103 Aug 2007 @ 05:38 PDTDatabaseReplyHow to find the number of columns in a table?The following SQL will do the job for you.SELECT DatabaseName, TableName, Count(columnname) As ColumnCountFROM DBC.ColumnsWHERE DatabaseName='E_CompanyDB' AND TableName='Employee'GROUP BY 1,2;-Foxbat
1031 Jul 2007 @ 09:04 PDTAnalyticsReplyProblem with starting Terdata thrgh Teradata Service ControlHi,you seem to started posted the same thread at more than one place. Please check the response in http://www.teradata.com/teradataForum/shwmessage.aspx?ForumID=9&MessageID=8287-Foxbat
931 Jul 2007 @ 08:56 PDTDatabaseReplyProblem with starting Terdata thrgh Teradata Service ControlAre you referring to the Demo version of TERADATA?The Anti Virus software on your system could be blocking the gateway s/w that is required for the database.Try disabling it and see if it works. If...
831 Jul 2007 @ 08:49 PDTToolsReplyHelp me with DEMO databaseTolik,You didnt mention the sequence of events that occured before you saw this msg.Did you see this msg come up after you established a successful connection with the database? Was the database ru...
731 Jul 2007 @ 07:45 PDTDatabaseReplyCollection of statistics on DBC databaseStatistics are not usually collected on dictionary tables. One possible reason is the information stored there changes frequently (example: DBC.ALLRights) and may therefore give scope for poor perf...
627 Jul 2007 @ 04:03 PDTDatabaseReplybat file that captures status of a bteqTry the %ERRORLEVEL% variable as shown below.***batchfile****@echo onecho started batch filebteq < samplebteq.txtecho %ERRORLEVEL%And here's a URL that you might find useful for DOS batch commands....
526 Jul 2007 @ 02:54 PDTDatabaseTopicColumn level attributes not copied to target table in CREATE TABLE AS...Hi all,CREATE TABLE AS (subquery) syntax behaves different from what is documented in the standard manual (SQL Reference manual-Data Definition Statements-Release V2R6.1 (B035-1144-115A)). The colu...
420 Jul 2007 @ 02:21 PDTDatabaseTopicAccess Right AbbreviationsThought this might come in handy for those of you who had trouble understanding the Access Rights abbreviations displayed in the Data Dictionary.The script below maintains the full descriptions for...
326 Jun 2007 @ 07:34 PDTDatabaseReplyCPU seconds#1. The end user probably meant the "Response time" is longer than usual. The usual causes for a frequently sumbitted SQL to take longer than usual to respond are (a). The user's session may...

Pages