#DateForumTypeThreadPost
3529 Sep 2014 @ 10:07 PDTDatabaseReplyTeradata as object databaseGreat! Any chance for some documentation or other materials? Meanwhile i google by myself :p
3422 Sep 2014 @ 06:57 PDTDatabaseTopicTeradata as object databaseWelcome, Some database systems does have some object-relational features although they are rather relational databases. Does Teradata have some?    
3320 Jun 2013 @ 02:25 PDTViewpointReplyCanary Query DetailsHi there... Can you give us information where did you found information about macro PDCRINFO.CapCanarySUMRT_Rpt and information how to use it inSQL?   I'm lookin for cannary query whic...
3212 Jun 2013 @ 07:11 PDTExtensibilityReplyTable degeneration and amp data arrangementI was thinking about sth like... when you backup some table and table ID's how to make the table not to overwhrite IDS and unixue data? Or... when you archive the table, and table got missing ...
3112 Jun 2013 @ 07:09 PDTToolsReplyCS Ram, Pakdisk? Paddisk? Thanks Dieter, Somehow google was not even close to find the solution. Now I know what I am searchin for :)   Regards!
3012 Jun 2013 @ 02:42 PDTToolsReplyTeradata 14.10 silent install.Ok, the answer is Temp folder. If I remember corerctly, each package installed creates an installation log file located in the USER's %TEMP% directory and contain installation logs of silent T...
2912 Jun 2013 @ 01:42 PDTExtensibilityTopicTable degeneration and amp data arrangementHi everyone,   How to check if table is degenerated or not? - If so, than how to pix it or what tool should I use? How to check are the data on amps/nodes arranged properly? (splited up eq...
2812 Jun 2013 @ 12:49 PDTToolsTopicCS Ram, Pakdisk? Paddisk? Hi there,   I have heard about some kind of teradata tools like CS Ram and Pakdisk? (Paddisk or sth) which are pretty handfull and I cand find any informaton about them.   It was tool...
2727 May 2013 @ 07:20 PDTToolsReplyTeradata 14.10 silent install.In simple way, the question is "How to log silent_install" :)
2627 May 2013 @ 06:10 PDTToolsTopicTeradata 14.10 silent install.Welcome, I try to use silent install of TTU 14.10. Right now I have some problems with it.   I have created .bat file to run the silent install from CMD but I cant set it to make proper lo...
2508 May 2013 @ 06:00 PDTDatabaseTopicPassword check for Teradata user.Welcome, I have been asked to check password for some login by owner of this login. User just forgoten the pass. I understand that privicy policy prefers to change the pass (just for sure) but is...
2407 May 2013 @ 06:50 PDTDatabaseTopicNode read only userIs there some support or default 'read only' user for nodes on teradata? I ment user which is made to read error logs and some canary query logs.   Regards!
2307 May 2013 @ 06:19 PDTViewpointReplyCanary Query DetailsHi there,   Is there some default Canary Query which can be runed from time to time by user not via viewpoint?  
2207 May 2013 @ 05:04 PDTDatabaseReplyHow to retrieve the Relative Record Number?Heh... you are right :) So obvious, yet so new!
2107 May 2013 @ 04:55 PDTGeneralTopicTeradata system health check scriptHi there, I have heard that there is some script in on OS under teradata which check if Teradata and other components are alive or not. The same script (or similar) generates T@YS issues if system...
2019 Mar 2013 @ 09:14 PDTDatabaseReplyHow to retrieve the Relative Record Number?Well...   Sounds stupid but I have helped myself with default select --> copy paste to excel --> sorting and numeric conversion to date via left and right functions (to split needed nu...
1919 Mar 2013 @ 09:11 PDTData ModelingTopicConversion of numeric to date and group by it.Hi there... I'm pretty nobbish in this type of SQL so please try not to be rough for me :)   Well.. I have to convert numeric field to date, than count some upload data and group by tab...
1819 Mar 2013 @ 08:23 PDTDatabaseReplyHow to retrieve the Relative Record Number?Hi there...   I have very similar problem like friend from the very start of the post. I'm pretty nobbish in this type of SQL so please try not to be rough for me :)   Well.. I h...
1714 Mar 2013 @ 04:14 PDTAnalyticsReplyconversion of datatypeIt works :)   Great thanks for help Ulrich :)   Now I wonder... Cast all the scripts or alter main and target tables...   Once again, thanks!
1614 Mar 2013 @ 03:17 PDTAnalyticsReplyconversion of datatypeHi there Unfortunetly I have problem with data conversion  ;P select    tab_id   ,tab2   ,tab3   ,tab_id_2   ,tab4   ,tab5   ,sum(dat...
1514 Mar 2013 @ 03:15 PDTDatabaseReplyNumeric Overflow error in teredatahi there,,, unfortunetly I fight with similer problem ;P select    tab_id   ,tab2   ,tab3   ,tab_id_2   ,tab4   ,tab5   ,sum(data_table_uplink...
1411 Mar 2013 @ 05:33 PDTThird Party SoftwareReplyIs update possible in DBC.USERS?Hi there,   Do you guys have idea how to grant full select privilages on dbc.users? I have been granted with grant select on dbc.users to my_login but i still see only myself in select * fr...
1311 Mar 2013 @ 03:22 PDTDatabaseReplyGrant select on DBC.USERS for typicall user.Hi there, Thanks for your answer. Well till now I have used dbc.databases but this table does not have information about user profile and others which dbc.users have.   But thanks anyw...
1211 Mar 2013 @ 03:21 PDTDatabaseReplyhow to create a user, database and table in sql assistant?Lol my mistake with the earlier answer. I had allready created user by using script similar to generated from Teradata Administrator.   The ony questions are: GRANT ALL ON user_TEST to...
1106 Mar 2013 @ 06:35 PSTDatabaseTopicGrant select on DBC.USERS for typicall user.Welcome,   I have tried to grant select on dbc.users table for one user. For some reason default command does not give the right result.   grant select on dbc.users for uset_name &n...

Pages