#DateForumTypeThreadPost
5011 Aug 2015 @ 03:57 PDTDatabaseReplyView creation.Hi Sunny Having a view layer on top of your base tables is always advisable for security purposes. Just because you asked for the cons : It do add some work for the developer like refeshing view ...
4911 Aug 2015 @ 03:49 PDTDatabaseReplyspool space errorUse below query to check spoolusage and other factor:   SELECT TB1.AMPCPUTime,TB1.SpoolUsage,TB1.TotalIOCount, SUBSTR(TB2.SqlTextInfo,1,1000) AS SqlTextInfo FROM DBC.DBQLOGTBL TB1 INN...
4815 Jul 2015 @ 04:18 PDTDatabaseReplyInsert into target table from source table for each date for a specific date rangeexactly what i thought. Why you need loop here when you can use between ? If the requirement is such, then you have to write stored proc to accept start & end data and then you can loop.
4717 Nov 2014 @ 01:13 PSTGeneralReplywhat are the drawbacks by using join index table?You cannot force TD to use Join index in your query. So the situation may be you have created join index however your query may not use it.
4605 Nov 2014 @ 11:44 PSTDatabaseReplyhow to run multiple stored procedures in parallel ?then all the procs need diff session. can we do something within same session ?
4505 Nov 2014 @ 10:35 PSTDatabaseTopichow to run multiple stored procedures in parallel ?Hi I have to run few procs in parallel. I have created a wrapper stored procedure which calls all the procedures. Presently it calls procs in sequence. How can I call procs in parallel ? I have ...
4429 Oct 2014 @ 10:21 PDTGeneralReplyIs Teradata good for Operational Online ApplicationsThank You all for your responses. Any case study or doc I can refer to for understanding design part of online applications.  
4329 Oct 2014 @ 05:14 PDTToolsReplypassing ksh variable into bteq function? Hi k1ng   I tried this & it worked for me. Below is my shell script:   #!/bin/ksh server=localhost user=raj pass=raj qry="SELECT infokey FROM DBC.DBC...
4229 Oct 2014 @ 04:38 PDTGeneralTopicIs Teradata good for Operational Online ApplicationsHi We have built few online applications in which Teradata is @ back-end and Java is used @ front-end. The application is used by users to get information about the customers calling the call-cen...
4131 Jan 2014 @ 03:20 PSTToolsTopicMVC on BYTEINT column Hi  I am using AtanaSoft for MVC purpose. I have a table with size 22GB. When I am running tool to generate MVC values I am observing that flag columns (BYTEINT datatype) are not getting an...
4022 Jan 2014 @ 07:30 PSTGeneralReplyOmit Rows From Tabletcluster Left Outer Join sclusters on t.code = s.code where s.code is null will give all strings not tagged to trading companies 
3922 Jan 2014 @ 06:57 PSTDatabaseReplyWhich is efficient?If you are just selecting records then it does not matter whether you use Derived table or the table directly. Teradata PE is enough smart to include only those columns which are required by the q...
3820 Jan 2014 @ 12:42 PSTDatabaseReplyInserting into a timestamp(6) columnThe answer suggested by bikky is good. Or else you can use OS command to convert last : to . and then directly the value can be loaded into timestamp(6) column.   Raj
3711 Dec 2013 @ 08:09 PSTGeneralTopicSame query taking different CPU TIME, RESPONSE TIMEHi    I am running the same query in Teradata and everytime I am seeing changes in CPU Time and Response Time. I have tried running the same query in same session as well as in differe...
3603 Dec 2013 @ 07:07 PSTGeneralTopicDoes Teradata move all columns of a table to SpoolHi I was wondering if there are two tables and while joining two tables , if the table is getting redistributed into SPOOL. Then does the teradata takes all columns in the table to SPOOL or just ...
3513 Aug 2013 @ 01:39 PDTDatabaseReplySize of table with partial data (active records)You can create a PROC which can get the information from dbc.columns and depending on datatype should calculate the max row size. Like if it is Integer add 4 bytes ; for timestamp add 10 bytes.
3407 Aug 2013 @ 08:56 PDTDatabaseReplyStrange error regarding data typeHi Kindly share the complete scenario. If it is simple insert select then this should work fine.   -- Raj
3307 Aug 2013 @ 08:52 PDTDatabaseReplySize of table with partial data (active records) SELECT databasename, tablename, SUM(columnlength) ROWSIZE, COUNT(*) columncount FROM dbc.COLUMNS WHERE databasename LIKE '%XXX%' AND TABLENAME='YYY' GROUP BY data...
3207 Aug 2013 @ 08:43 PDTDatabaseReplyCalculating the actual query run timeCPU time is the CPU seconds used by the query. So depending on the Capacity at which your TD system is set ; you will have some amount of CPU seconds in a day. So how much CPU seconds are used by t...
3107 Aug 2013 @ 08:35 PDTDatabaseReplyDynamic SQL - Stored ProcedureHi  Try something like this:   DECLARE T2 CURSOR FOR SELECT TD_TBL_NM FROM DB_S.TBL_LIST OPEN T2; LABEL1 : LOOP FETCH T2 INTO TABLE_NAME; /* TABLE_NAME is a variable here...
3007 Aug 2013 @ 08:19 PDTDatabaseReplyPPI or NUSI?Hi Nishant If you are creating your date column as PPI , then using the column in filter condition will lead to partition elimination and will enhance the performace. You may come across situation...
2924 Jul 2013 @ 10:29 PDTDatabaseReplyCreation of Volatile tableAs volatile tables are created in user space and need only spool space, you should mention your username to create volatile tables.
2823 Jul 2013 @ 04:43 PDTToolsTopicBTEQ Export not showing column name if no rows are returned   My BTEQ Export is working fine. However, when there is no rows to return , it is not even returning COLUMN NAMEs. Hence a blank file is generated. I want to...
2723 Jul 2013 @ 02:27 PDTGeneralReplyinterview helpAnyone got the material ?  Or its fake ?
2610 Jul 2013 @ 11:52 PDTViewpointTopicMeaning of basic terms I see in ViewpointHi Guys,   I wish to learn meaning of few basic terminlogies used in Teradata Viewpoint. Below are the words for which I need information: /*TERMS IN QUERY MONITOR:*/ CPU USE ; CPU ; CPU ...

Pages