#DateForumTypeThreadPost
3319 Jul 2011 @ 04:10 PDTDatabaseTopicgrouping on character fieldsHi, A table tab_1 is defined with 2 columns: group_name and email_ids.Sample data in tab_1 is as follows: group_name email_ids ---------------- -------------- group1 abc@xyz...
3222 Jun 2011 @ 07:36 PDTToolsTopicPipes in BTEQBTEQ can read the output data directly from another BTEQ job, using named pipes, without even getting the data on a storage device. Could anyone please explain this with an example. A sampl...
3122 Jun 2011 @ 07:26 PDTDatabaseTopicWhat's in the error table?Hi, I am using a fastload script to load data to my tables. The error table created has 3 columns: ErrorCode INTEGER FORMAT 'ZZZZ9', ErrorFieldName VARCHAR(30) CHARACTER SET LATIN N...
3022 Jun 2011 @ 06:56 PDTDatabaseReplyMacro vs ProcedureI fired the query in database. For SPs, I got the permspace while for macros no rows were returned. Thanks a lot Mnylin
2916 Jun 2011 @ 08:41 PDTDatabaseTopicCollect Stats InfoIn which dbc tables in teradata is the demographic information of collecting statistics on tables stored?
2816 Jun 2011 @ 02:05 PDTDatabaseTopicMacro vs ProcedureHi, The diff. between Macros and stored procedure in Teradata is that stored procedure require physical storage. Can anyone clarify what does physical storage mean and how a stored procedure...
2703 Jun 2011 @ 02:00 PDTDatabaseTopicHow do we calculate MAX in teradataHi, I have a salary_table and I want to fetch the maximum of Net_Amt from that. I want to know how does teradata get this maximum value.So I get the explain plan which is as follows: explai...
2622 Mar 2011 @ 10:11 PDTDatabaseTopicTeradata Table Naming Why is that teradata limits the size of a table name or index name defined on it to be 30 characters at maximum? Is there any specific reason behind this?
2524 Feb 2011 @ 04:49 PSTDatabaseTopicHash Index and PPIWhy cannot a table's primary index be partitioned, if a hash index is defined on the table?
2407 Feb 2011 @ 12:39 PSTDatabaseTopicTeradata QueryI have data in Apps Table as: (app_id,store_id,mail_id) (1,111,'abc.com') (1,111,'def.com') (2,222,'krk.com') (2,222,'gfh.com') How could I obtain the output in this format: (app_id,st...
2325 Jan 2011 @ 10:03 PSTDatabaseTopicLocking InformationHow can we get to know what type of lock is applied on a table in teradata database, when when fire a query in TD SQL? Is there any dbc table providing the information?
2220 Jan 2011 @ 06:40 PSTDatabaseTopicNUSI and Explain PlanHi, I am firing a explain plan query on a table (Item) in TD.The third step of the explain plan reads like: 3) We do an All-AMP RETRIEVE step from DBNAME.Item by way of index # 4 "DBNAME.Item...
2118 Jan 2011 @ 03:54 PSTDatabaseTopicNUSIHow are the sub tables for NUSI created? What are the columns in these sub tables? Also NUSI subtables are present in the same AMP in which the data they point to is present(Not so in case of U...
2013 Jan 2011 @ 04:02 PSTDatabaseTopic Fload from csv fileHi, I am running the following fastload script to read from a csv file: SHOW VERSION ; SESSIONS 4; ERRLIMIT 2000; logon tdpid/username,password; drop table DBNAME.Bday_reminder ;...
1905 Jan 2011 @ 11:51 PSTDatabaseTopicPerformance StatsHi , I am using the following table to collect performance statistics on a query, but getting no rows. SELECT CollectTimeStamp, SessionID, UserName, DefaultDatabase as DatabaseName, S...
1826 Dec 2010 @ 09:25 PSTDatabaseTopicCount the No. of OccurenceHi, Is there any function to find the number of occurences of a particular substring within a string in teradata?
1717 Dec 2010 @ 09:01 PSTDatabaseReplyTPump DML LabelThanks for the explanation
1616 Dec 2010 @ 07:17 PSTDatabaseTopicTPump DML LabelHi, What do the following statements in the DML LABEL section in a tpump script do exactly: IGNORE MISSING ROWS IGNORE EXTRA ROWS; The input is a flat file with records inserting data into ...
1510 Dec 2010 @ 07:49 PSTDatabaseTopicPrivacy Enabled Data CompressionWhat is the Privacy Enabled Data Compression feature in Teradata? How can we protect personally identifiable information from users,including DBA using this feature? Any example.. Thanks, K...
1403 Dec 2010 @ 09:47 PSTDatabaseTopicVTT vs GTTIn which scenarios we use Volatile tables and Global temporary Tables in Real time?
1329 Nov 2010 @ 10:31 PSTDatabaseTopicError while Executing FASTLOAD ScriptHi, I am executing a fastlaod script which is as follows: SESSIONS 4; ERRLIMIT 2000; .logon tdpid/username,password; create table DBNAME.id_unit_fload ( id VARCHAR(18), units VARCHAR...
1227 Oct 2010 @ 06:52 PDTDatabaseTopiccoalesce and format functionCan coalesce and format function go together? I want the output of a numeric field to be displayed in specific format ,and 0 when the value in the column is NULL. So, I use SELECT TRIM(COA...
1126 Jul 2010 @ 07:42 PDTDatabaseTopicSpecify datablock size, Percent freespaceIn teradata,CREATE TABLE can specify datablock size, percent freespace. Can anyone site an example ?(i mean a ddl statement for a table with above attributes)
1021 Jul 2010 @ 08:31 PDTDatabaseTopicUDT Data TypeWe can define a distinct UDT(User Defined Type) data type named "dollar" as: CREATE TYPE dollar AS DECIMAL(8,2) FINAL; What is the significance of the word "FINAL"? Is it part of the synta...
920 Jul 2010 @ 10:56 PDTDatabaseTopicExecution modes in teradataI know there are two execution modes in teradata: 1.Protected execution mode 2.Non-protected execution mode What is the difference between these two modes of execution? How to know which e...

Pages