All forum activity

#DateUserForumTypeThreadPost
5803025 Jun 2016 @ 10:13 PDTrharitha7GeneralTopicsteps to install td-ttu-15.10.05_for_WindowsHi,   I've installed td-ttu-15.10.05_for_Windows and extracted the zip file. can someone please share me the steps to install td-ttu-15.10.05_for_Windows.which setup file has t...
5802925 Jun 2016 @ 04:42 PDTQaisar Aftab KianiDatabaseReplyHow to insert recursive query answerset to another tableAll the columns selected at the end of recursive query are inserted in the table. If you want to insert some specific columns then select only those ones.
5802824 Jun 2016 @ 02:45 PDTnealvennaDatabaseReplyunix timestamp with timezone to teradata timestampHi all Below code worked for me.   sel  TO_TIMESTAMP( CAST( ( 1466017810720 - 1466017810720 MOD 1000 ) / 1000 AS BIGINT)  ) + ( 1466017810720 MOD 1000 * INTERVAL '0...
5802724 Jun 2016 @ 02:08 PDTnealvennaDatabaseTopicunix timestamp with timezone to teradata timestampHi all,  I have unix epcoh timestamp with timezone and it needs to be converted to teradata timestamp(6). I have tried to solve this by seeing old posts in teradata forums, but none...
5802624 Jun 2016 @ 01:52 PDTrnadjafiDatabaseReplyPRESERVING A SPACE IN A LIKE STATEMENTThat's not working for me.  Somehow it trims the space.  
5802524 Jun 2016 @ 01:13 PDTcdorgerDatabaseTopicglobal parameters or variables in Teradata?Does Teradata have global parameters or global variables?  I want to take a sample from a table where the sample size is a multiple of the number of rows in another, existing, table: creat...
5802424 Jun 2016 @ 12:52 PDTdejo316DatabaseReplyHigh Skewfactor inspite of even distributionSo after you changed the PI and re-loaded the table, are you sure that you checked the skew on the new table (the one with the fixed PI)? 
5802324 Jun 2016 @ 12:38 PDTdejo316DatabaseReplyPRESERVING A SPACE IN A LIKE STATEMENTcol1 col2 3 test one   1 test two   1 testthree    sel * from sampletbl where col2 like '%test %' only retrieves the first two rows.
5802224 Jun 2016 @ 12:25 PDTdejo316DatabaseReplyNOT NULL still retrieves NULLTry max_id> ''  instead of "MAX_ID is not null". Can you give more details? the table ddl and sample data
5802124 Jun 2016 @ 10:22 PDTajithpillaiTeradata StudioReplyTeradata studio installation is failing...hi thanks.  how do we create the  new database?...i have the teradata studio as a client tool installed...does teradata provide a default test database like adventureworks that MS provid...
5802024 Jun 2016 @ 09:44 PDTrnadjafiDatabaseTopicPRESERVING A SPACE IN A LIKE STATEMENTHow do you preserve the space in a LIKE statement (% WORD1%)?  Any assistance you can provide would be greatly appreciated.  
5801924 Jun 2016 @ 08:16 PDTzszmigieroAsterReplyHow to list all seqeunces?Could you provide an example use this name to get next value and grant access to sequence to other user?
5801824 Jun 2016 @ 08:15 PDTzszmigieroAsterTopicINSERT undocumented syntaxHi, I have noticed that INSERT with bracketed query is supported what is not documented in Aster SQL reference: - INSERT INTO table (query) Should I treat this as a bug or another syntax not inc...
5801724 Jun 2016 @ 08:09 PDTjohnsunnydewDatabaseTopicNOT NULL still retrieves NULLHi Friends, Can somebody help me on the below issue that am facing while executing it. The result of the below query retrieves NULL value even when specified the filter IS NOT NULL.   SELEC...
5801624 Jun 2016 @ 07:08 PDTEkladiosDatabaseReplyCASE statement in SQLCASE Statement: If any WHERE condition is met then it will ignore ELSE. But this is not the case my example   This works fine SELECT         &n...
5801524 Jun 2016 @ 06:31 PDTblankmeDatabaseTopicspecial char 0xFF convert to 0X1A with character set LATIN1_0A i encountered a character set problem make me headache, please someone can help me. there is a table t_special with database sever character set 'LATIN', then i execute the sql insert into...
5801424 Jun 2016 @ 04:26 PDTArpan.RoyToolsReplyNeed Help regarding TPT ODBC OperatorThanks a lot Steve. Below is my locale settings in .bash_profile. export NLS_LANG=american_america.UTF8 #export LANG=C #export LC_ALL=C export LANG=en_US.UTF-8 export LC_ALL=en_US.UTF-8 ex...
5801324 Jun 2016 @ 01:33 PDTRomilGeneralTopicHow to detect updates in a teradata table at runtime without using timestamp column or last acess time stamp,How to detect the teradata table updates and how to determine it at runtime. My requirement is to import from teradata and at runtime whatever updates have happened ..need to import those latest ch...
5801224 Jun 2016 @ 01:33 PDTDietmarEsserAsterTopicLoad with Informatica PowerCenter into AsterDear community, for one of my customers I am looking for best practices and guidelines for loading data with Informatica PowerCenter into Aster. Any feedback or guidance on this would highly be a...
5801124 Jun 2016 @ 12:18 PDTdrmkd17DatabaseTopicHigh Skewfactor inspite of even distributionHi All,   Today i came across a weird scenario in Teradata.  One of my tables dbc.table_a  was highly skewed with a skewfactor of 95.77 . I used the below query to check the skewf...
5801023 Jun 2016 @ 10:50 PDTdbc1012DatabaseReplyDBLink in TeradataPerhaps you could check out my article - I call the attached tool DbLinks:   http://developer.teradata.com/connectivity/articles/access-external-data-a-table-udf
5800923 Jun 2016 @ 10:48 PDTdbc1012DatabaseReplyTeradata DBLinkAlso, check out this article that I wrote - I call the tool DbLinks. http://developer.teradata.com/connectivity/articles/access-external-data-a-table-udf    
5800823 Jun 2016 @ 09:04 PDTfgrimmerTeradata StudioReplyTeradata studio installation is failing...ap,  You can use the IP address or hostname of your Teradata server machine (Amazon EC2 instance) to create the connection from Studio. You can try the default admin user DBC and password dbc ...
5800723 Jun 2016 @ 07:49 PDTfeinholzToolsReplyTPT Failure : Output schema mismatch - Output varies from Server to Server.Please provide the DDL of the source table. I notice that the script is not indicating the use of the UTF8 client session character set, so not sure how Unicode could affect this, but the table de...
5800623 Jun 2016 @ 03:31 PDTajithpillaiTeradata StudioReplyTeradata studio installation is failing...yes.i have installed teradata studio. the jave issue is out  of the way...two things i need to solve: one is how do i use the local instation of teradata studio to connect to the  terada...

Pages