| 59669 | 07 Sep 2016 @ 03:15 PDT | pandit | Database | Reply | Teradata block storage | Thanks 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... |
| 59668 | 07 Sep 2016 @ 03:07 PDT | nari1309 | Database | Topic | Drop 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... |
| 59667 | 07 Sep 2016 @ 02:27 PDT | agts | Database | Reply | System Table for Compression | got it.
CompressValueList in dbc.columns can be use for same
|
| 59666 | 07 Sep 2016 @ 02:02 PDT | agts | Database | Topic | System Table for Compression | Is 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 ... |
| 59665 | 07 Sep 2016 @ 12:55 PDT | AtardecerR0j0 | Database | Reply | Find 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... |
| 59664 | 06 Sep 2016 @ 10:45 PDT | vc | Database | Topic | Find skew with perm over 1gb | Hello,
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... |
| 59663 | 06 Sep 2016 @ 09:49 PDT | vc | Tools | Topic | BTEQ:saving output in multiple file | Hello 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... |
| 59662 | 06 Sep 2016 @ 03:52 PDT | teradatauser2 | Database | Reply | Find blocking sessions and tables | I see the values as blk3objdbid = 1 and blk3objtid = 102, screenshot attached
|
| 59661 | 06 Sep 2016 @ 03:42 PDT | teradatauser2 | Database | Topic | Find blocking sessions and tables | Hi,
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... |
| 59660 | 06 Sep 2016 @ 01:36 PDT | SGIT | Database | Topic | Syntax |
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.&... |
| 59659 | 06 Sep 2016 @ 12:34 PDT | kthumm11 | Database | Reply | Creating a Dynamic YoY Date Range in Case Statement for Current Quarter QTD | Thank you Dieter this works!
|
| 59658 | 06 Sep 2016 @ 12:09 PDT | feinholz | Tools | Reply | TPT Multiple JobVar files | Yes, 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),... |
| 59657 | 06 Sep 2016 @ 11:51 PDT | manish237 | General | Topic | Converting Unix/EPOCH time to PST | I 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... |
| 59656 | 06 Sep 2016 @ 11:16 PDT | arteaga7 | Tools | Topic | Arcmain | I 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 ... |
| 59655 | 06 Sep 2016 @ 09:09 PDT | fgrimmer | Teradata Studio | Reply | Option "User Choice (includes DBC)" not available in Teradata Studio 15.11 | Xinyu, 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... |
| 59654 | 06 Sep 2016 @ 08:52 PDT | fgrimmer | Teradata Studio | Reply | Terdata Studio Express laggy on mac | Jing, 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-... |
| 59653 | 06 Sep 2016 @ 07:25 PDT | ToddAWalter | Database | Reply | Teradata block storage | The 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 ... |
| 59652 | 06 Sep 2016 @ 07:12 PDT | carpenterangela | Teradata Studio | Reply | Option "User Choice (includes DBC)" not available in Teradata Studio 15.11 | Is the "Show Databases and Users In Hierarchical Display" box checked? If so, uncheck that, and then "User Choice" should be available as an option.
|
| 59651 | 06 Sep 2016 @ 07:02 PDT | nealvenna | Database | Reply | OLAP 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... |
| 59650 | 06 Sep 2016 @ 03:14 PDT | juanalfonso | Database | Topic | How 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... |
| 59649 | 06 Sep 2016 @ 01:56 PDT | ColinPretty | Tools | Topic | TPT Multiple JobVar files | Hi 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 ... |
| 59648 | 05 Sep 2016 @ 09:18 PDT | knowledge | Aster | Topic | log file after shutdown | Hi,
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, ... |
| 59647 | 05 Sep 2016 @ 08:26 PDT | deven_rk | Database | Topic | OLAP 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 ... |
| 59646 | 05 Sep 2016 @ 08:24 PDT | deven_rk | Analytics | Topic | OLAP 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 ... |
| 59645 | 05 Sep 2016 @ 02:28 PDT | davidtzoor | Tools | Topic | Passing parameter in Teradata Rest Service | Hi,
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... |
