#DateForumTypeThreadPost
1216 Jul 2012 @ 12:16 PDTGeneralReplyTuning the query This SQL should give you idea; SELECT HASHAMP(HASHBUCKET(HASHROW(<<NUPI Columns))) AS "AMP #",COUNT(*) FROM <<table>> GROUP BY 1 ORDER BY 2 DESC; Cheers!
1116 Jul 2012 @ 01:47 PDTGeneralReplyTuning the query You need to consider few things like number of records in the table, how many rows are there on average per index value etc. If there are two many rows against few of the index values then the s...
1015 Jul 2012 @ 01:56 PDTDatabaseReplyHow to create DEV, SIT, UAT I guess ARCMAIN is the most commonly used utility for migrating/copying the data to different environments. As with every other software/utility there are limitations and so does the ARCMAIN, bu...
915 Jul 2012 @ 01:47 PDTDatabaseReplyIF condition in bteq Yes, you can use the IF THEN statements for checking conditions. e.g. below statement cheks whether the last SQL statement executed with/without error. .IF ERRORCODE<> 0 THEN .QUIT...
815 Jul 2012 @ 01:38 PDTDatabaseReplyUsing Stored Procedure Result Set into a INSERT statement on another Stored Procedure No, unfortunately in Teradata you can't use the SP result set in the insert statement. Instead of returning the result set  from the SP, you can use a temp table to store the result...
715 Jul 2012 @ 01:35 PDTDatabaseReplyHow to update multiple columns in one table based on if else condition use case statement Regards,
615 Jul 2012 @ 01:14 PDTGeneralReplyRecursive SQL combining Dates Hi, There is no doubt that you need to limit your SEED statement to setup a base table but it is equally important to limit the results when you are selecting the final result set. If yo...
514 Jul 2012 @ 01:23 PDTGeneralReplyJoin Index. Hi, You can find the details in the TD documentation, but on a high level Teradata Join Index pre-joins the result of two or more tables and stores it in the permanent DB space and are norma...
414 Jul 2012 @ 01:01 PDTAnalyticsReplyMerging Multiple Rows Not sure you got the answer to your query or not, but a quick solution would be to change the definition of the table and include a new column lets say "Seq", which could have the same...
314 Jul 2012 @ 10:42 PDTDatabaseReplyInsert statement in stored procedure You surely can combine the table columns and the SP variables in an INSERT statement. This will work. Regards,
226 Oct 2008 @ 11:37 PDTToolsReplysetting BTEQ Import attribute dynamicallyThanks for the reply.But we are using windows.
126 Oct 2008 @ 08:53 PDTToolsTopicsetting BTEQ Import attribute dynamicallyI am having a situation where I have to load some data from a txt file via BTEQ, but the problem is that the file file location and name is dynamic and is always available in a table.I just want to...

Pages