#DateForumTypeThreadPost
97122 Sep 2014 @ 12:33 PDTDatabaseReplyIdentify the time zone from a timestamp columnTime zone..my thought: How is the set up?Creating a user with time zone, DBA's setting of dbscontrol, setting at session level(local,user, set interval..) what do you get when you do: selec...
97021 Sep 2014 @ 08:03 PDTDatabaseReplyHash Index To Eliminate Redistribution OnlyI am of the opinion that you use STJI instead of HJI. It is good that you collect stats too. You join with other tables, so you know the joining in mind. You can run explain and see how it behaves.
96921 Sep 2014 @ 07:35 PDTDatabaseReplyUnique Identifier in SQL Server - Equivalent in Teradata ?I am not  a SQL server person :). Teradata's unique identity column is different. However, if you know the functionality you can think of a UDF. That is my thought.
96821 Sep 2014 @ 07:26 PDTDatabaseReplyUnique Identifier in SQL Server - Equivalent in Teradata ?will this help you select ROW_NUMBER() OVER (ORDER BY fieldnames) , a.* from your_table a; I am not able to follow when you say "I can accomodate ........" Teradata  do have ident...
96721 Sep 2014 @ 06:53 PDTDatabaseReplycan we join PPI table to NON PPI tableYes, it can. It can give rise  to making a PPI-to-spool File join.  You can create tables, insert data and check the explain. You may have heard about single/sliding window merge join h...
96621 Sep 2014 @ 05:31 PDTDatabaseReplyRequirement for Grouping recordsHow about just having max(END_DT ) over (partition by key_fields order by some_fields). So in that case, your table1 will be thin. You can even think of splitting into three, the static fields if ...
96521 Sep 2014 @ 02:39 PDTDatabaseReplyNO PRIMARY INDEX table in TeradataYou can use NOPI  for fastload and tpump or corresponding tpt. It will improve performance. you can do dml operations on NOPI table, excepting merge. You can refer to this link : http://deve...
96419 Sep 2014 @ 10:02 PDTDatabaseReply3. How to find Exisiting LAN ID in Teradata?Did you try to get it from dbc.hostsinfov or dbc.accesslog or PMCPINFO.DBQL  views ?
96319 Sep 2014 @ 08:41 PDTDatabaseReplyHow to verify Data Pattern in a Columnyou can try something like this: select num,case when lower(substr(num,2,2))<>upper(substr(num,2,2)) then 'number has 2 alpha' else case when character_length(num)=8 then 'numbe...
96219 Sep 2014 @ 05:12 PDTDatabaseReplyIdentify the time zone from a timestamp columnWhaw!!!! I am at a loss :): Just my thought How is your table DDL?Are you in touch with the DBA if he can help you maybe with Dbs control settings ,.....?  help session may/ not help you you ...
96119 Sep 2014 @ 03:50 PDTDatabaseReplyIdentify the time zone from a timestamp columnMaybe this can help you, the last line. I did not try it.: http://www.info.teradata.com/htmlpubs/DB_TTU_14_10/index.html#page/Connectivity/B035_2509_082K/2509ch08.10.44.html SELECT EXTRACT (TIMEZ...
96019 Sep 2014 @ 03:34 PDTToolsReplyTeradata Decision Experts (TDE)If you dont get it from documentation/download, and if you are partner, you can ask from your point of contact of your organization. My suggestion.
95919 Sep 2014 @ 03:16 PDTDatabaseReplycreating table with sum-functionI suggest you provide the code, what you did and what errors you get and in what environment...like Studio/assistant/unix/ Teradata BTET or ANSI mode...... Sometimes a quick answer gives wrong...
95819 Sep 2014 @ 01:54 PDTDatabaseReplyNo room available in Database testdb.You can use this link for help: http://forums.teradata.com/forum/database/space-in-the-database You  can think of dropping unwanted tables ,do you have dbql tables...... DBA can do  pa...
95719 Sep 2014 @ 12:35 PDTDatabaseReplyOverlap Function Purpose in ProjectsIt is mostly related to transactions, time that I see. I can see in temporal features too: This material is a good read, though it is in Aster nPATH : http://www.teradatamagazine.com/v1...
95618 Sep 2014 @ 11:47 PDTDatabaseReplycreating table with sum-functionYou can refer to this : http://www.info.teradata.com/edownload.cfm?itemid=140900023 Cheers,
95518 Sep 2014 @ 10:39 PDTDatabaseReplyLocking the tableYou can have a look ath this link where you can place lock, within BT -ET   http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1146_111A/ch03.034.281.html
95418 Sep 2014 @ 10:23 PDTDatabaseReplycreating table with sum-functionI am not sure of datediff but perchance doable.It looks like datediff is a complex function. I think you take from some other Databases? Why do you do transformation in a DDL? DDL is meant for dat...
95318 Sep 2014 @ 09:58 PDTDatabaseReplyCharacter setThese discussions can help you: https://forums.teradata.com/forum/database/does-one-need-unicode-compression-in-tredata-14-0 https://forums.teradata.com/forum/database/utf-8-or-utf-16  
95218 Sep 2014 @ 08:09 PDTToolsReplyDBSCONTROL dont display dataStrange!!!! In SLE, when I type DISPLAY, it scrolls down to the bottom and shows  "Enter a command,HELP, or QUIT:" Did you exit and reopen , by any chance? But we need to be extrem...
95118 Sep 2014 @ 08:01 PDTDatabaseReplyExport to excelI remember vaguely , when I opened excel and configure the connection to Teradata. It's damn slow. It shows some records. Why don't you give a try from excel?
95018 Sep 2014 @ 07:56 PDTDatabaseReplycreating table with sum-functionYes very much you can, example below: create table db1.itemppi_test as(select l_orderkey as lo, l_partkey as lp, add_months(l_shipdate,2) as dd from  db1.itemppi) with data
94918 Sep 2014 @ 08:46 PDTExtensibilityReplyCapabilities of Teradata XML ServicesYou can have a look at this link: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/Teradata_XML/B035_1140_112A/chap3.05.18.html See you can traverse back and forth in the link. ...
94818 Sep 2014 @ 08:41 PDTDatabaseReplycreating table with sum-functionHow are you going to populate  repair_order_number VARCHAR(7000) CHARACTER SET LATIN NOT CASESPECIFIC, repair_order_suffix VARCHAR(7000) CHARACTER SET LATIN NOT CASESPECIFIC, job_number D...
94718 Sep 2014 @ 06:45 PDTDatabaseReplyNo room available in Database testdb.D you see/analyse DBC.TableSize & DBC.DiskSpace befoer you do anything?  

Pages