#DateForumTypeThreadPost
4818 Apr 2012 @ 05:57 PDTDatabaseReplyQueue Tables in Database Express   Det7, Interestingly enough I am currently observing training where this very question just came up. Check your ODBC settings: go into Advanced and see if Disable Parsing is ti...
4721 Sep 2011 @ 02:45 PDTGeneralReplyTeradata SQL Extensions Tom, I appreciate that link.  We do indeed have the Teradata documentation locally, but I'd like to suggest that requiring support staff of companies with multi-million pound Terada...
4609 Sep 2011 @ 09:01 PDTToolsTopicFastload and Dates I'm finding an issue I'm having with a Fastload job and a text file with pretty standard dates extremely maddening, and I am sure V12/V13 has changed Fastload's behaviour in some way...
4509 Sep 2011 @ 08:42 PDTToolsReplyskip the header row in the flat file, when importing using FastLoad script Many thanks for that.  Great background to the history of Fastload and loading. We've not really started using Teradata Parallel Transporter, but I think I may suggest we do so in f...
4401 Sep 2011 @ 03:19 PDTToolsReplyskip the header row in the flat file, when importing using FastLoad script Agreed, but then what is the point of having statements like RECORD 2;?  Why have functionality inbuilt that doesn't behave in line with the function? Whilst I know it does not mean...
4301 Sep 2011 @ 02:46 PDTGeneralTopicTeradata SQL Extensions All, As you know, Teradata handles ANSI-SQL as standard but also supports various Teradata SQL extensions to the ANSI-SQL, like EXPLAIN, SHOW, HELP, COLLECT STATS, etc... Would there be ...
4227 Jul 2011 @ 04:04 PDTToolsReplyskip the header row in the flat file, when importing using FastLoad scriptChela, A good thing about a lot of Teradata's errors is that they tell you exactly what is wrong. In this case, your DEFINE section is defining each field in the text file as a certain length, ...
4104 May 2011 @ 09:44 PDTDatabaseReplyAutomatic compression of NULL valuesEnjoyCoding - Jim is correct here. Effectively, Teradata is "earmarking" the space. Jim - just wondering here. What would be the overhead/advisability of automatically compressing NULL values?...
4030 Apr 2011 @ 11:45 PDTDatabaseTopicAutomatic compression of NULL valuesHello! I've been advised that V12 or V13 has added automatic compression of NULL values to fields that do not have explicit NOT NULL attributes. The effect here is that one would no longer need...
3905 Nov 2010 @ 06:10 PDTDatabaseReplyTeradata V13 and CommentsRob, Thanks for your reply. I am not aware of query bands, but have heard the phrase "query banding". I'll feed this to our DBAs, as this could possibly be a good way forward. I'll also have ...
3802 Nov 2010 @ 08:51 PDTDatabaseTopicTeradata V13 and CommentsHello! We have a process whereby user queries require "approving" or "rejecting" when accessing sensitive customer data. In order to make the process run more smoothly we ask that users comment...
3720 Oct 2010 @ 04:06 PDTToolsReplyFast ExportFurther to this, we have now moved to V12 then V13, and one of my analysts pointed out that if you type the TDP location location in lower-case it does not prompt numerous times for passwords: ....
3605 Aug 2009 @ 10:21 PDTDatabaseTopicGlobal Temporary Tables and Secondary IndexI was leading a Refresher Course today and a user asked a very interesting question around Global Temporary Tables and Secondary Indexes.I did some digging and ascertained that indeed you can have ...
3512 May 2009 @ 08:26 PDTDatabaseReplydefault charactersetThe following code forces the character set to LATIN:CREATE TABLE DB.ANDY_TEMP AS (SELECT PRD_ID,AV_BAL,TRANSLATE((CASEWHEN AV_BAL > 10000THEN 'RICH'WHEN AV_BAL < 10000THEN 'NOT SO RICH'ELSE ...
3430 Oct 2008 @ 08:38 PDTToolsReplyFast ExportSupremeBeing,Many thanks for your reply. What you say makes complete sense. The only problem is, this never happened on V2R5, only when we went to V2R6.It would be nice if CLI cached the password...
3326 Oct 2008 @ 09:11 PDTToolsReplyFast ExportI've had over 3000 views to this, which suggests others are experiencing the same thing.I've looked through the FastLoad/FastExport manuals and there is nothing about this in it.Obviously, we can a...
3226 Sep 2008 @ 09:03 PDTAnalyticsReplyHiding a column from outputThanks everyone!Adeel, thanks for your suggestion, I was trying to get around that so I could use Age instead of the formula.Fred, I might just use the old Teradata extension in that way. Personal...
3118 Sep 2008 @ 09:33 PDTDatabaseTopicCREATE TABLE AS ... WITH DATA AND STATISTICSHello!In V2R6, added functionality is provided to copy over statistics when using CREATE TABLE AS syntax. We have noticed that it does not function as we had thought it would.Has anyone ever used ...
3010 Sep 2008 @ 06:01 PDTAnalyticsTopicHiding a column from outputHello!Consider the following SQL:SELECT CUST_ID,DTE_BIRTH,(DATE-DTE_BIRTH)/365.25 As AGE,CASEWHEN AGE < 18THEN 'Under 18'WHEN AGE BETWEEN 18 and 65THEN 'Between 18 and 65'WHEN AGE > 65THEN '...
2915 Aug 2008 @ 08:51 PDTAnalyticsTopicGroup By and many columnsHello!Is there any quicker way to do a GROUP BY when you have many columns other than listing them all?So, instead of:GROUP BY 1,2,3,4,5,6,7,8,9,10,etc...Is there anything like:GROUP BY ALL EXCEPT ...
2815 Aug 2008 @ 08:22 PDTThird Party SoftwareReplyODBC connection problem - MS Query and ExcelThanks for that.I assume what this does is load only what is in the connection box database, and that is what I want it to do.Regards!Andrew
2712 Aug 2008 @ 02:10 PDTThird Party SoftwareTopicODBC connection problem - MS Query and ExcelHello!Although this query has more to do with ODBC than Teradata, I am only posting it to see if any other users have worked around the error I have encountered.When connecting to Teradata via Exce...
2601 Aug 2008 @ 09:48 PDTToolsReplyFastExport script and output delimitersSushant!Arguably a better approach, as this would give you absolute control over the placement not only of delimiters, but of the actual data as well. Using this FE script would help write the Fas...
2504 Jul 2008 @ 06:23 PDTAnalyticsReplyCounting the number of occurrences of a character within a character stringAdeel/Jeff_O,Thanks for your replies. I was thinking along the same line, but was hoping for some little known function in SQL. SQL isn't the best for string manipulation, but I suppose it is more...
2430 Jun 2008 @ 06:12 PDTAnalyticsReplyhow to export table values into a file?Hey Rock,I am on SQL Asst 7.2, and was on 6.2 earlier. From the File menu, toward the bottom there is Export Results and Import Data (or similar wording). These are toggles, and you turn them on ...

Pages