All forum activity

#DateUserForumTypeThreadPost
5966907 Sep 2016 @ 03:15 PDTpanditDatabaseReplyTeradata block storageThanks a lot for the reply Todd. It was really helpful. Just to revise, say on block level, data will be just apended to blocks whereas the index will be in sorted order for performing binary sear...
5966807 Sep 2016 @ 03:07 PDTnari1309DatabaseTopicDrop Table blocked by Read lock session which is not on the machine.Hi All, I having an issues, while Dropping a backup table, The drop tables session(Session ID 59678567) is blocked by read lock of some other session (2463583 USER: ALL), this blocking is no...
5966707 Sep 2016 @ 02:27 PDTagtsDatabaseReplySystem Table for Compressiongot it. CompressValueList in dbc.columns can be use for same     
5966607 Sep 2016 @ 02:02 PDTagtsDatabaseTopicSystem Table for CompressionIs there any way for finding compressed columns in database with there values, like system table for compression columns and values?  using Select * from dbc.columns where compressible like ...
5966507 Sep 2016 @ 12:55 PDTAtardecerR0j0DatabaseReplyFind skew with perm over 1gb SELECT cast(DatabaseName as char(30)), cast(Tablename as char(40)), (100 - (AVG(CURRENTPERM)/MAX(CURRENTPERM)*100) (FORMAT 'zz9.99') )AS Skewfactor_greater_90, cast (CURREN...
5966406 Sep 2016 @ 10:45 PDTvcDatabaseTopicFind skew with perm over 1gbHello, I am using the below query  SELECT  cast(DatabaseName as char(30)), cast(Tablename as char(40)), (100 - (AVG(CURRENTPERM)/MAX(CURRENTPERM)*100) (FORMAT 'zz9.99...
5966306 Sep 2016 @ 09:49 PDTvcToolsTopicBTEQ:saving output in multiple fileHello All.   I am writing a bteq which is saving the output in the One file.Bteq has 3 different queries. I need to save outout of all the three queries in three seprate files using one BTE...
5966206 Sep 2016 @ 03:52 PDTteradatauser2DatabaseReplyFind blocking sessions and tablesI see the values as blk3objdbid = 1 and blk3objtid = 102, screenshot attached    
5966106 Sep 2016 @ 03:42 PDTteradatauser2DatabaseTopicFind blocking sessions and tablesHi, In our environment, we have an application that runs queries and they block each other for some tables. I want to know which all sessions and which all tables are in blocked state with that ID...
5966006 Sep 2016 @ 01:36 PDTSGITDatabaseTopicSyntax I am getting the following error : SPL1027:E(L7), Missing/Invalid SQL statement'E(3706):Syntax error: expected something between the word 'StartDate' and the 'DATE' keyword.&...
5965906 Sep 2016 @ 12:34 PDTkthumm11DatabaseReplyCreating a Dynamic YoY Date Range in Case Statement for Current Quarter QTDThank you Dieter this works!
5965806 Sep 2016 @ 12:09 PDTfeinholzToolsReplyTPT Multiple JobVar filesYes, TPT does support multiple job variable files. You just add additional -v <filename> command line options to the command line. This feature was implemented recently (targeted for 16.0),...
5965706 Sep 2016 @ 11:51 PDTmanish237GeneralTopicConverting Unix/EPOCH time to PSTI have a column in my teradata table which stores timestamp in UNIX/EPOCH form. I want to run a query and get the corresponding Date in PST and number of records against that date. I got the follow...
5965606 Sep 2016 @ 11:16 PDTarteaga7ToolsTopicArcmainI need to perform a database backup but I am not able to find a place to download the tool or a package containing the tool. I think it might be included in a previous version of the utilities but ...
5965506 Sep 2016 @ 09:09 PDTfgrimmerTeradata StudioReplyOption "User Choice (includes DBC)" not available in Teradata Studio 15.11Xinyu, A response was posted by Angela, but it was "unpublised" for some reason, so I will repeat what the solution is: Make sure that the "Show Databases and Users in Hierarchcial D...
5965406 Sep 2016 @ 08:52 PDTfgrimmerTeradata StudioReplyTerdata Studio Express laggy on macJing, It sounds like you have tried a lot of the suggestions! We hope to have fixed the SQL Editor issue in our upcoming 15.12 release (due out this week), regarding a double-click problem. Double-...
5965306 Sep 2016 @ 07:25 PDTToddAWalterDatabaseReplyTeradata block storageThe rows in the data blocks are not sorted, they are just placed at the end of a heap of storage. The block contains an index list though which is ordered by the rowid. Likewise the blocks are not ...
5965206 Sep 2016 @ 07:12 PDTcarpenterangelaTeradata StudioReplyOption "User Choice (includes DBC)" not available in Teradata Studio 15.11Is the "Show Databases and Users In Hierarchical Display" box checked? If so, uncheck that, and then "User Choice" should be available as an option.
5965106 Sep 2016 @ 07:02 PDTnealvennaDatabaseReplyOLAP SQL - running count/total Below is the solution and answer is inspired from  Dieter Answer  from the link below   https://forums.teradata.com/forum/database/olap-function-csum-sum-with-reset-va...
5965006 Sep 2016 @ 03:14 PDTjuanalfonsoDatabaseTopicHow to return the result of a select query in a function Hello to everybody, I'm trying to return the result of a select query in a function. Something like: REPLACE FUNCTION F_SIGUIPUNTERO_F (nPunt number, nLimite number) RETURNS int LA...
5964906 Sep 2016 @ 01:56 PDTColinPrettyToolsTopicTPT Multiple JobVar filesHi there,   I'm new to TPT and have got it working.  I'm wanting to use Job Variable files to house things such as username and password and have got this working with the main ...
5964805 Sep 2016 @ 09:18 PDTknowledgeAsterTopiclog file after shutdownHi, i need to have a complete log for the system and users activities on ASTER. i need it because after a shutdown in the weekend, i think for too many sessions or too many work space used, ...
5964705 Sep 2016 @ 08:26 PDTdeven_rkDatabaseTopicOLAP SQL - running count/total Hi All,   We have the below data and using an SQL not procedural code, I would like to get the output as given below for 'out_count',  it would help if we could do ...
5964605 Sep 2016 @ 08:24 PDTdeven_rkAnalyticsTopicOLAP SQL - running count/total Hi All,   We have the below data and using an SQL not procedural code, I would like to get the output as given below for 'out_count',  it would help if we could do ...
5964505 Sep 2016 @ 02:28 PDTdavidtzoorToolsTopicPassing parameter in Teradata Rest ServiceHi, I am using Teradata Rest Service and trying to pass a parameter for my query: select ? as ip_address from my_database.ip_table as g where internallib.ip2ip3(ip_address) between g.start_ip...

Pages