7323 Jul 2008 @ 01:32 PDTToolsReplyHow to compare bteq select count ?Hello,May be you can try it with COUNT(*) OVER(), otherwise you can try following:SELECT * FROM( SELECT COUNT(*) a FROM table1) a,( SELECT COUNT(*) b FROM table2) bHTH.Regards,Adeel
7222 Jul 2008 @ 10:07 PDTDatabaseReplypeakperm spaceHello,It is the maximum amount of permanent space ever occupied by a table.HTH.Regards,Adeel
7121 Jul 2008 @ 03:27 PDTUDAReplyNeed the distinct month dateHello,Can you please provide example of what you are trying to achieve?Regards,Adeel
7016 Jul 2008 @ 10:52 PDTConnectivityReplyConnecting to Teradata through ASP.NET using C#Additionally, in case of .NET Data Provider after installing and adding reference, you can use "Teradata.Client.Provider" namespace.Regards,Adeel
6916 Jul 2008 @ 10:48 PDTConnectivityReplyConnecting to Teradata through ASP.NET using C#Hello,You can use:- .NET Data Provider for Teradata- ODBC Data ProviderBoth can be downloaded from "http://www.teradata.com/DownloadCenter/".Following sample queries can be used (www.connectionstri...
6815 Jul 2008 @ 11:37 PDTToolsReplySQL Assistance neededHello,Can you please provide the example what exactly you want to do?Regards,Adeel
6715 Jul 2008 @ 07:00 PDTDatabaseReplyOrder of WHERE clause conditionsMy recommendation would be, to try out the different combinations, as it can vary from system to system and type of data and offcourse the SQL written!Regards,Adeel
6615 Jul 2008 @ 06:58 PDTDatabaseReplyHow To keep 3 days History in a Table ?Hello,ADD_MONTHS definitely adds months, not days!Following is the example, which may be of some help:CREATE VOLATILE TABLE tab1 (col1 DATE, col2 DATE) ON COMMIT PRESERVE ROWS;INSERT tab1(CAST('200...
6514 Jul 2008 @ 06:46 PDTDatabaseReplyUsing Parameters with QueriesI don't think so, as a matter of fact SQL does not take input variable by itself!!Regards,Adeel
6414 Jul 2008 @ 05:45 PDTDatabaseReplyUsing Parameters with QueriesYou can use parameterized-macro for this.Example:CREATE MACRO mac1 (Col1Value INTEGER)AS( SELECT col1, col2, col3 FROM viewa WHERE col1 = :Col1Value;);EXECUTE mac1(1);EXECUTE mac1(2);HTH.Regards,Adeel
6308 Jul 2008 @ 10:52 PDTDatabaseReplyUsing Parameters with QueriesCan you please give some sort of example?And are you talking about parameterized-views?Regards,Adeel
6208 Jul 2008 @ 06:41 PDTDatabaseReplyUsing Parameters with QueriesAre you going to use it in a Stored-Procedure?Regards,Adeel
6103 Jul 2008 @ 11:55 PDTAnalyticsReplyMax Value across several columns in a rowHello,CASE itself is pretty efficient, isn't it?Regards,Adeel
6003 Jul 2008 @ 04:35 PDTDatabaseReplyDeleting Duplicate records...If I am not wrong, it is in the documentation that it is not possible to delete duplicate rows in a MULTI-SET table, using just a single DELETE statement.Regards,Adeel
5902 Jul 2008 @ 12:34 PDTAnalyticsReplyCounting the number of occurrences of a character within a character stringUDFs will be the easiest, most usable and most efficient way!Regards,Adeel
5801 Jul 2008 @ 05:35 PDTDatabaseReplyTotalCpuTime and response timeDBMS may be using caching, it may not be doing an actual disk I/O, and it may also be due to rounding-off errors.I guess the best answer of CPU time, I/O time etc can only be given by DBMS itself.R...
5726 Jun 2008 @ 05:25 PDTDatabaseReplyInsert multiple rows in single statementYes, using INSERT-SELECT.Regards,Adeel
5626 Jun 2008 @ 02:37 PDTToolsReplyFastload to VIEWHello,As you said, FastLoad loads in tables not the views, you need to load the underlying table(s) for updating view.I suppose "RDBMS error 3853: 'myview' is not a table." is pretty self-explainat...
5523 Jun 2008 @ 02:12 PDTDatabaseReplyBatch execution of stored proceduresHello,All you have to do is it place all the definitions of all the SPs in seperate files e.g. sp1.spl, sp2.spl,..., sp40.spl. Write a BTEQ script as follows:.LOGON ...;DATABASE ...;.COMPILE FILE =...
5423 Jun 2008 @ 12:03 PDTToolsReplyBTEQ,Tpump,Fastload,MultiloadHello,It will be as follows:Load 10M rows to an empty table: FastLoadUpdate 100K rows: MultiloadExtract 100rows for a report: BTEQContinuous load with changing load rate: TPumpHTH.Regards,Adeel
5317 Jun 2008 @ 12:23 PDTDatabaseReplyCapturing Procedure output parameter in BTEQHello,What is the definition of your stored-procedure? You have to use EXCEPTION HANDLERS and set the out variables parameters in it. Then it should show the values. With-out handlers if there is s...
5216 Jun 2008 @ 03:06 PDTUDAReplyHow many kinds of the data marts? and what are they?Hello,There are three kinds of Data-Marts (DMs), which are as follows:1. Independent DM: Created from operational systems and have seperate physical data-store.2. Logical DM: Exists as a subset o...
5112 Jun 2008 @ 03:19 PDTDatabaseReplyGeneration of IDENTITY values for a columnI guess no!If you want to have sequence number using SQL you can use ROW_NUMBER or RANK (depends on your requirement).HTH.Regards,Adeel
5012 Jun 2008 @ 01:50 PDTDatabaseReplyGeneration of IDENTITY values for a columnThe IDENTITY column is not generated in sequence i.e. you can not expect TD to generate value as 1,2,3,4,5...!The generation of IDENTITY column is AMP dependent. The value will surely be unique, bu...
4911 Jun 2008 @ 11:17 PDTToolsReplyfastload between table to tableThey are the Load-Utilities and loading a table is done from external source, normally. :)If you want to copy one table's data to other table, you can use INSERT SELECT statement.Regards,Adeel