All forum activity

#DateUserForumTypeThreadPost
134213 Jul 2006 @ 09:35 PDTBarry-1604DatabaseReplyTeradata datatypeBLOB and CLOB are supported. RAW and LONG RAW are not. I'm on v2r6, but I believe that BLOB and CLOB came along prior to that (maybe v2r5.1?).
134113 Jul 2006 @ 07:06 PDTNitsDatabaseTopichow to create function with parametersHi,Please give hints on how to create function with parameters.Code snipsets would be a great help.
134013 Jul 2006 @ 07:06 PDTNitsDatabaseTopichow to create function with parametersHi,Please give hints on how to create function with parameters.Code snipsets would be a great help.RegardsNitin Bajaj
133913 Jul 2006 @ 06:47 PDTpavan sriramDatabaseTopicTeradata datatypeHi All,Can any one help me out...I need the teradata equivalent datatype for CLOB,BLOB,RAW, LOng Raw(Oracle data type).Thanks in Advance...!Pavan.
133813 Jul 2006 @ 05:08 PDTManoj_Kumar_ParmarDatabaseReplydifference between Hash join and Merge joinHi Barry, Thanks for reply,but I am finding that Hash join would do the product join, because one by one it is picking all the rows from small table and comparing(scanning) this with all the rows...
133713 Jul 2006 @ 01:10 PDTANGELToolsReplyAccess module error while running MLOADHi,Thanx for the response. I tried giving the quotes around and also applied the FORMAT command. It is still not working but this time it is not throwing any error. It is just not able to read/reco...
133612 Jul 2006 @ 05:56 PDTFredDatabaseReplyTables updated in last one hourThere is no built-in record of last time data content was changed.
133512 Jul 2006 @ 05:47 PDTFredDatabaseReplyProblems With Dynamic SQL ExecutionNote that to use DBC.SysExecSQL in a stored procedure, the creator of the SP (the username logging on to issue CREATE PROCEDURE) must be the same as the owner (database / user within which the SP i...
133412 Jul 2006 @ 12:18 PDTdnoethToolsReplyAccess module error while running MLOADHi Angel,you forgot to set the format, the default is FASTLOAD, which is similar to BTEQ DATA, i.e. binary data..IMPORT INFILE c:\book.txtLAYOUT empl_layoutFORMAT TEXTAPPLY Inserts;Dieter
133312 Jul 2006 @ 12:05 PDTstami27-2406AnalyticsReplyIS-NUMERIC functionsHi flaska,I use an UDF from Mr. Dennis Calkins named is_integer.This function returns 0 if field not numeric and 1 if numericU can use it like this: select * from mydatabase.emp_table where mydatab...
133212 Jul 2006 @ 11:57 PDTdnoethAnalyticsReplyIs there a 'sounds-like' phonetic function ?Hi Tim,if you're on V2R5.1+ this could be solved with a UDF implementing a more advanced phonetic algorithm, e.g. metaphone. You just have to find an implentation in C and wrap it into the UDF...Di...
133112 Jul 2006 @ 10:29 PDTBarry-1604ToolsReplyAccess module error while running MLOADHave you tried quotes around the input file?.IMPORT INFILE 'c:\book.txt'It looks to me like the file is not being recognized. I haven't used Mload from the PC, but based on experience with other u...
133012 Jul 2006 @ 10:26 PDTBarry-1604DatabaseReplydifference between Hash join and Merge joinThe merge join requires that both tables (spool files) be sorted on the hash-code of the columns being joined (or subset of columns being joined). This will be the case if they both have the same ...
132912 Jul 2006 @ 10:14 PDTFarid KhanToolsReplyAbout CrashDumps in TeradataHi, Thanks for reply, Ur respons was very useful to begin with the CrashDumps topic.I am Practicing to create the CrashDumps (PDE, system, and DBS dumps). But How do i create Crashdump files (.db...
132812 Jul 2006 @ 09:59 PDTBarry-1604DatabaseReplyProblems With Dynamic SQL ExecutionI believe that you can only execute the call to DBC.SysExecSQL within the context of a stored procedure. It doesn't work as a stand-alone command.When I try calling it, it says it doesn't exist, b...
132712 Jul 2006 @ 07:46 PDTtalal_ahmadDatabaseTopicProblems With Dynamic SQL ExecutionI have created a stored procedure and compiled it. This has been done successfully however one little problem that i face is that i have not been able to use the following statement ...
132612 Jul 2006 @ 07:19 PDTANGELToolsTopicAccess module error while running MLOADHi,I'm getting access module error while running mload script from command prompt. FYI- I'm using a demo version of teradata V2R5. The text file is as simple as aaxabcdddddaaaaaand the table is emp...
132512 Jul 2006 @ 02:10 PDTManoj_Kumar_ParmarDatabaseTopicdifference between Hash join and Merge joinHi All, I am unable to find the difference between Hash Join and Merge Join, and when the optimizer opt among Hash join and Merge join. Can any body explain, so that things can clear..Thanks in ...
132412 Jul 2006 @ 12:09 PDTKir BojoToolsReplyFastLoad Performance Tuning for large volumes of input dataHi All,Thanks for your help.The issue is resolved. The cause of the delay was due to network and switches.Thanks,
132311 Jul 2006 @ 07:18 PDTTimMannsAnalyticsReplyIs there a 'sounds-like' phonetic function ?Thanks everyone, I'll give SOUNDEX a try.Tim
132211 Jul 2006 @ 02:46 PDTSherianMToolsReplyAbout CrashDumps in TeradataThe term 'crashdump' in Teradata land is used colloquially to mean the contents of memory that is dumped out to disk whenever the system crashes or encounters a fatal/critical error. In actuality h...
132111 Jul 2006 @ 01:22 PDTFredDatabaseReplyGuidance relating to secondary index and unique column constraintIf you want the DBMS to enforce uniqueness, a Unique Index is the price you have to pay. This is clearly documented.Without an index, enforcing the constraint "on the fly" during INSERT/UPDATE woul...
132011 Jul 2006 @ 12:19 PDTBarry-1604AnalyticsReplyIs there a 'sounds-like' phonetic function ?From the manual, it does look like the intent was to be used on surnames....Soundex is a system that codes surnames having the same or similar sounds, but variantspellings. The Soundex system was f...
131911 Jul 2006 @ 10:58 PDTzebulonAnalyticsReplycount of distincthave you try this :select count(*) from select INVENTORY_ITEM_KEY,COST_TYPE_KEYfrom ITEM_COST_DETAILS_Fgroup by INVENTORY_ITEM_KEY,COST_TYPE_KEY ) as MYCOUNT
131811 Jul 2006 @ 10:02 PDTManoj_Kumar_ParmarDatabaseTopicSI or PI will be choosen by Optimizer?two table are joining and on columns on which one table has both indexes ie PI and Secondary Index on single col say empno, then optimizer will choose which index to access the row, moreover statis...

Pages