|58030||25 Jun 2016 @ 10:13 PDT||rharitha7||General||Topic||steps to install td-ttu-15.10.05_for_Windows||Hi,
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... |
|58029||25 Jun 2016 @ 04:42 PDT||Qaisar Aftab Kiani||Database||Reply||How to insert recursive query answerset to another table||All 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.
|58028||24 Jun 2016 @ 02:45 PDT||nealvenna||Database||Reply||unix timestamp with timezone to teradata timestamp||Hi all
Below code worked for me.
TO_TIMESTAMP( CAST( ( 1466017810720 - 1466017810720 MOD 1000 ) / 1000 AS BIGINT)
) + ( 1466017810720 MOD 1000 * INTERVAL '0... |
|58027||24 Jun 2016 @ 02:08 PDT||nealvenna||Database||Topic||unix timestamp with timezone to teradata timestamp||Hi 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... |
|58026||24 Jun 2016 @ 01:52 PDT||rnadjafi||Database||Reply||PRESERVING A SPACE IN A LIKE STATEMENT||That's not working for me. Somehow it trims the space.
|58025||24 Jun 2016 @ 01:13 PDT||cdorger||Database||Topic||global 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:
|58024||24 Jun 2016 @ 12:52 PDT||dejo316||Database||Reply||High Skewfactor inspite of even distribution||So 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)?
|58023||24 Jun 2016 @ 12:38 PDT||dejo316||Database||Reply||PRESERVING A SPACE IN A LIKE STATEMENT||col1 col2
3 test one
1 test two
sel * from sampletbl where col2 like '%test %' only retrieves the first two rows.
|58022||24 Jun 2016 @ 12:25 PDT||dejo316||Database||Reply||NOT NULL still retrieves NULL||Try max_id> '' instead of "MAX_ID is not null". Can you give more details? the table ddl and sample data
|58021||24 Jun 2016 @ 10:22 PDT||ajithpillai||Teradata Studio||Reply||Teradata 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... |
|58020||24 Jun 2016 @ 09:44 PDT||rnadjafi||Database||Topic||PRESERVING A SPACE IN A LIKE STATEMENT||How do you preserve the space in a LIKE statement (% WORD1%)? Any assistance you can provide would be greatly appreciated.
|58019||24 Jun 2016 @ 08:16 PDT||zszmigiero||Aster||Reply||How to list all seqeunces?||Could you provide an example use this name to get next value and grant access to sequence to other user?
|58018||24 Jun 2016 @ 08:15 PDT||zszmigiero||Aster||Topic||INSERT undocumented syntax||Hi,
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... |
|58017||24 Jun 2016 @ 08:09 PDT||johnsunnydew||Database||Topic||NOT NULL still retrieves NULL||Hi 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.
|58016||24 Jun 2016 @ 07:08 PDT||Ekladios||Database||Reply||CASE statement in SQL||CASE 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... |
|58015||24 Jun 2016 @ 06:31 PDT||blankme||Database||Topic||special 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... |
|58014||24 Jun 2016 @ 04:26 PDT||Arpan.Roy||Tools||Reply||Need Help regarding TPT ODBC Operator||Thanks a lot Steve.
Below is my locale settings in .bash_profile.
|58013||24 Jun 2016 @ 01:33 PDT||Romil||General||Topic||How 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... |
|58012||24 Jun 2016 @ 01:33 PDT||DietmarEsser||Aster||Topic||Load with Informatica PowerCenter into Aster||Dear 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... |
|58011||24 Jun 2016 @ 12:18 PDT||drmkd17||Database||Topic||High Skewfactor inspite of even distribution||Hi 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... |
|58010||23 Jun 2016 @ 10:50 PDT||dbc1012||Database||Reply||DBLink in Teradata||Perhaps you could check out my article - I call the attached tool DbLinks:
|58009||23 Jun 2016 @ 10:48 PDT||dbc1012||Database||Reply||Teradata DBLink||Also, check out this article that I wrote - I call the tool DbLinks.
|58008||23 Jun 2016 @ 09:04 PDT||fgrimmer||Teradata Studio||Reply||Teradata 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 ... |
|58007||23 Jun 2016 @ 07:49 PDT||feinholz||Tools||Reply||TPT 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... |
|58006||23 Jun 2016 @ 03:31 PDT||ajithpillai||Teradata Studio||Reply||Teradata 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... |