#DateForumTypeThreadPost
406 Sep 2016 @ 10:45 PDTDatabaseTopicFind 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...
306 Sep 2016 @ 09:49 PDTToolsTopicBTEQ: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...
229 Aug 2016 @ 06:24 PDTDatabaseTopicOutput is different in DBC.diskspace and for Dbc.diskspacevHello, When I am firing the below 2 query,I am getting the same output as  abc_stg,test_mdl,123_srci for databasename columns But when I replace Dbc.diskspacev with dbc.diskspace the output ...
111 May 2016 @ 03:03 PDTDatabaseTopicDATABASE Creation(why db is created from TDA) and why assign dbc as owner and assign perm space,spool space,Temp Spacehi, I am new to teradata and stil learning.Currently working on TD Express VM provided by TD I was not able to create a db with normal "create database" query on SQL Assitant Later aft...