180 | 02 Jul 2007 @ 11:17 PDT | UDA | Reply | Begin Transaction / End Transaction | May be there's something like a DDL or so inside the proc ... :owhich is fine if you are just calling the proc, if you enclose the call in an BT/ET it could fail.Or may be you can paste the code & ... |
179 | 02 Jul 2007 @ 06:11 PDT | UDA | Reply | Fast/Multi Load & Control Characters | Use fixed width, it's also much faster to load.The issue of space is normally circumvented in unix by using compression utilities (ie ask the source system to send zipped files) and loading them vi... |
178 | 02 Jul 2007 @ 12:27 PDT | UDA | Reply | TeraData vs Oracle | Oracle would survive only if your client was looking for purely OLTP based systems. If it's for a DW platform, the obvious choice is an MPP based RDBMS system, of which Teradata is THE leader.I am ... |
177 | 29 Jun 2007 @ 02:21 PDT | UDA | Reply | product Join | I am also wondering if the conditionAND b.RRtv_year_id in (2007)had an impact on the performance, it was being evaluated separately for each of the OR conditions, which was an over kill ......had i... |
176 | 29 Jun 2007 @ 02:06 PDT | Database | Reply | how to check the space allocated to particular database | DBC.DiskSpace will give you database space per AMP.DBC.TableSize for tables ... |
175 | 29 Jun 2007 @ 01:47 PDT | Database | Reply | Change Password | From Data definitions statements manual.To execute the MODIFY USER statementIF you are … | THEN you must have the DROP USER privilege on …----------------------------... |
174 | 26 Jun 2007 @ 06:10 PDT | Tools | Reply | eliminating non-integer characters | You can either use unix scripting to do that, use an outmod, or use a UDF like this ....../* C program source for UDF, store it under C:\myUDFS\extractdigits.c */#define SQL_TEXT Latin_Text#include... |
173 | 25 Jun 2007 @ 12:51 PDT | Database | Reply | Distinct and CASE | Try if this one works for you.SELECT TRIM(A.STORE_NUMBER) || MAX(CASE WHEN B.STORE_NUMBER IS NULL THEN '' ELSE '*' END )FROM STORES_A A LEFT OUTER JOIN STORES_B BON A.STORE_NUMBER = B.STORE_NUMBER... |
172 | 22 Jun 2007 @ 09:11 PDT | Database | Reply | Distinct and CASE | Not sure if I understood things correctlybut if store number is unique in both tables and you meant to have all store numbers from table A And if that store number's date fell in between start and ... |
171 | 22 Jun 2007 @ 05:54 PDT | Database | Reply | [HELP] Modify a column name that is also a NUPI Index... | I often wondered why there was so much fuss about renaming columns when it was part of an index. It didn't seem to me to involve anything more than updating the DBC.TVFields table(I am often inclin... |
170 | 22 Jun 2007 @ 05:37 PDT | Database | Reply | Space saved using Compression is exceptionally different from calculated result.. | Hmm.... lol that explains why my maths teacher was so mad at me ;-) Hi Dieter, You are right we always have allocation in terms of bytes, so the existing presence bit array byte would suffice for... |
169 | 22 Jun 2007 @ 02:11 PDT | Database | Reply | Spooled Data - Sharing | >>Some questions>>>1) ... multiple users.. In the same session ?Nope, multiple users implies different sessions as different users can't share the same session. Sync scan is available across sessio... |
168 | 22 Jun 2007 @ 12:44 PDT | Database | Reply | Sample without duplicates | I think the trouble is because RANK() returns the same value for same deptno (in this case it's always 1).So I think piggy backing on Dieter's original solution and using ROW_NUMBER instead, things... |
167 | 21 Jun 2007 @ 08:05 PDT | Database | Reply | Spooled Data - Sharing | No, spool is not shared even with in the same user ids different sessions or with in the sessions different requests.There might be some performance help from SYNC SCAN though. |
166 | 21 Jun 2007 @ 07:56 PDT | Database | Reply | Space saved using Compression is exceptionally different from calculated result.. | well if you go by books then you are supposed to get (8-2)bits/8bits * 10000 records = 7,500 bytes free.However, the disk space reported by the DD is not the "actual" space occupied by the rows in ... |
165 | 21 Jun 2007 @ 03:03 PDT | Database | Reply | Change Password | MODIFY USER Myuserid AS PASSWORD = mypass; |
164 | 20 Jun 2007 @ 09:19 PDT | Database | Reply | Urgent Help needed in Rank function!!!! | some thoughts ...if you were hunting for the money bags ;-) ... you would have to use order by Amount descAnd, if 209 was the highest amt, and you had values209,208,207,.....,201, 200, 200(Tot... |
163 | 20 Jun 2007 @ 09:06 PDT | Database | Reply | Performance of Correlated Subquery!!! | considering that there are quite a bit of permutations and combinations, the best way would be to check the explains of both queries to see what's happening (and is the practical way, it's difficul... |
162 | 20 Jun 2007 @ 04:21 PDT | Database | Reply | Checksum Attribute | I am not sure of the exact reason, but I would presume it has something to do with the fact that Checksums are computed over the blocks belonging to the same table (Which would be practical/easier ... |
161 | 20 Jun 2007 @ 02:39 PDT | Database | Reply | Checksum Attribute | It basically specifies the (percentage) amount of data that should be used to compute the CHECKSUM for the table. It's used for detecting data corruption (bad blocks ?)More % sample = More reliabil... |
160 | 20 Jun 2007 @ 02:17 PDT | Database | Reply | Does Teradata have packages | No, there are no equivalent concept in Teradata.Though there's a concept of Package (wrt UDF) in Teradata, it's different and not the same as the Oracle package concept. |
159 | 20 Jun 2007 @ 02:02 PDT | Database | Reply | Performance of Correlated Subquery!!! | I wonder which documents you are referring too ?Explains would tell better as to what the optimizer is cooking up,And given that most of the inner joins and their cor-related are not necessarily "e... |
158 | 20 Jun 2007 @ 12:14 PDT | Database | Reply | Error when trying to leave a while loop | You can't have Dynamic SQLs in macro, and you can't have DDL's unless it's last statement of transaction.It's ok to have DDL's in a SP, but you can't have it the way you are looking (ie tablename e... |
157 | 19 Jun 2007 @ 08:03 PDT | Database | Reply | Error when trying to leave a while loop | End Transaction has to automatically release any locks acquired by the transaction, so ET would result in closing any cursors.What is getting executed as part of the dynamic SQL ? |
156 | 18 Jun 2007 @ 07:53 PDT | Database | Reply | Partitioned Primary Index | This very long thread kind of discussed everything about it ... :ohttp://www.teradata.com/teradataForum/shwmessage.aspx?forumid=9&messageid=6553 |