#DateForumTypeThreadPost
6509 May 2012 @ 07:08 PDTToolsTopicScripting Tools for Development We do a great deal of development for Teradata using Linux and Windows platforms and the application platforms. Almost all of it is using ksh and the base Teradata utilities. When we create scri...
6420 Dec 2011 @ 11:31 PSTDatabaseTopicTable Level Checksums Is there anything like a table level checksum that could be used to see if two tables contain identical data? We are looking at replicating data and then applying daily updates and we want to kn...
6320 Dec 2011 @ 10:50 PSTDatabaseReplyTenure in years and months between two dates Can I suggest you use the SYS_CALENDAR.CALENDAR for doing this?  Even better, queries using it are easy to understand and maintain. It is, however, very Teradata-ish. R
6220 Dec 2011 @ 10:47 PSTDatabaseReplyPartition not selected by optimizer In EXAMPLE 1, the optimizer has no idea what values are in some_other_table (it is going to change this into an inner join anyway). It doesn't "peek" at the values in some_other_ta...
6105 Nov 2011 @ 07:52 PDTToolsTopicTeradata Wallet Can someone direct me to documentation on how to use Teradata Wallet? Specifically, is it just for v14 (or can it be used in v13)  and an example of how to incorporate it into a BTEQ script...
6025 Aug 2011 @ 01:24 PDTUDAReplyHow to remove non-numeric characters from a string? (Oracle TRANSLATE Equivlent function?) Teradata does not natively support regular expressions. That is why the '%[0-9.-]%' doesn't work.
5912 Aug 2011 @ 10:07 PDTToolsTopicSource ControlDoes any one have a particular source control system that works well with various types of Teradata scripts? (BTEQ, MLOAD, etc) R
5819 Jul 2011 @ 07:35 PDTUDAReplyto check is a string is numeric or notThe trouble with using the LIKE ANY phrase like that is that it is EXTREMELY resource intensive. Think about what it has to do. I would imagine the explain plan for them is a nightmarish forest of ...
5712 Jul 2011 @ 12:01 PDTUDAReplyto check is a string is numeric or notCHAR2HEXINT(UPPER(col1)) NE CHAR2HEXINT(LOWER(col1)) will go a long way to solving your issue. it sometimes has issues with special characters but you can filter on those. R
5620 Apr 2011 @ 02:29 PDTDatabaseTopicROW_NUMBER performance on large datasetsAnyone have a better way to assign sequential numbers to a data set than ROW_NUMBER? It has some miserable performance when you are partioning it over a couple of columns with a large (>100Million ...
5506 Feb 2011 @ 08:55 PSTConnectivityReplyCLIv2 and .NETNothing yet. Just crickets. R
5431 Jan 2011 @ 02:50 PSTDatabaseReplyTABLE SIZEThere was one table that was 1TB in size. I pulled 30% (expecting around 300GB) and it came in at about 150 GB. All the data was there. Neither source nor destination table had secondary indices an...
5329 Jan 2011 @ 06:44 PSTDatabaseTopicTABLE SIZERecently I had to transfer tables from our production Teradata system to the development system. When I transferred the data to several tables with the exact same DDL, the table size was dramatical...
5226 Jan 2011 @ 04:53 PSTToolsReplyDEFINE STATEMENT ON FASTLOADOne more piece of information, I am loading a file in that was fast exported in the FASTLOAD format. R
5126 Jan 2011 @ 04:48 PSTToolsTopicDEFINE STATEMENT ON FASTLOADI am trying to fastload a TIMESTAMP(6) into a table. I have tried several formats for the define statement and none of them are accepted by fastload. I have tried DEFINE COLNAME(TIMESTAMP); DEF...
5013 Dec 2010 @ 12:08 PSTToolsReplytranspose dataWe do that all the time with a WITH RECURSIVE query. The TD docs have a couple of pretty good examples. R
4907 Dec 2010 @ 11:01 PSTToolsTopicFast Export on a MainframeMainframe users, Do you know if the fastexport and fastload support the extended attribute of a GDG. We want to create exports larger than 200GB on our channel attached mainframe. We have created...
4807 Sep 2010 @ 12:25 PDTUDAReplyDrop Table "if exists"In BTEQ, the easiest way to do this is to set your ERRORLEVEL severity .SET ERRORLEVEL 3807 SEVERITY 0 (3807 is the error thrown when an object does not exist) Now, when you try to drop a ta...
4707 Mar 2010 @ 09:44 PSTGeneralTopicSQL Assistant Install on VistaI am trying to install TD13 on my Vista system. It all goes well except for SQL Assistant. When I attempt to install it, I get a ".NET Framework 2.0 required for installation" error. Unfortunately,...
4607 Mar 2010 @ 07:03 PSTDatabaseReplyWhat is used for SYS Calender in sql severThere are two options, 1. Use a view with lots of data functions (you won't be able to get everything that TD has easily). 2. Create your own. It is pretty easy with using Excel to generate t...
4506 Mar 2010 @ 06:21 PSTConnectivityReply.NET Provider performanceI will download that wrapper and see how it works out. Is there any way to get the source code from you? R
4406 Mar 2010 @ 06:18 PSTConnectivityTopicVS2010 BetaHas anyone successfully integrated the TD12 or TD13 .NET provider into VS2010 Beta? I realize it is not going to be supported as VS2010 is still in beta. I can use it, but I was hoping for a litt...
4329 Dec 2009 @ 06:14 PSTToolsTopicTPT BranchingIs there the ability to do conditional branching in TPT (similar to .IF operator in BTEQ)? I have looked in the ver 12 documentation and don't see anything like that and I am hoping I just missed i...
4217 Jul 2009 @ 09:45 PDTDatabaseReplySELECT TOP N - odd behaviour (v2r6)It looks like you need to collect stats on the table.
4115 Jul 2009 @ 05:49 PDTToolsReplyUsing Parameter in BTEQThe two answers above are OS workarounds. (You will see a lot of them on this forum for the TD command line utilities. They are very primitive and haven't really been updated with new features in a...

Pages