#DateForumTypeThreadPost
5317 Jul 2006 @ 02:45 PDTDatabaseReplysomebody help me its very urgent!!!!!!!You probably talk about the V2R5 demo version. IIRC there's a help file which talks about installing it on FAT32, you have to run a script afterwards. If you converted FAT32 to NTFS already then tr...
5214 Jul 2006 @ 03:01 PDTToolsReplyMload on global temporary tablesYou can't load a Global Temp Table using MLoad.A temporary session is always session local and MLoad logs on 2 SQL session for control and several MLoad sessions. But why do you even think about lo...
5112 Jul 2006 @ 12:18 PDTToolsReplyAccess 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
5012 Jul 2006 @ 11:57 PDTAnalyticsReplyIs 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...
4906 Jul 2006 @ 07:17 PDTDatabaseReplyDropping PPI partitionsHi John,there's a NO RANGE partition and all rows have been moved to that partition.In that case the delete from the old partition and the merge into the no range partition where transient journale...
4803 Jul 2006 @ 02:16 PDTUDAReplySQLHi Vasilis,trySEL descr FROM Table WHERE descr = 'my description' || '0D'xc'0D'xc: "x" means a hex-string to be converted to a "c" character-stringDieter
4730 Jun 2006 @ 10:27 PDTDatabaseReplyLooping of data from Teradata Global Temporary TablesHmmm, you're replacing a cursor with a temp table and then use a cursor to process the temp table rows?Cursors are only allowed within Embedded SQL and Stored Procedures, check the manuals...Could ...
4630 Jun 2006 @ 10:22 PDTDatabaseReplyHow do you declare a variable in Teradata SQL?Hi Matt,looks like a part of a SP in T-SQL to have a parameterized view.In a lot of cases you can use a Teradata macro for that. No variables/loops/if but parameters.create macro blabla (startdate ...
4528 Jun 2006 @ 03:53 PDTToolsReplyMLOAD .LAYOUT continueifThis can't be done within Mload using continueif.Do the concatenation before you load the file or write an Inmod to do it...Dieter
4428 Jun 2006 @ 03:50 PDTToolsReplySQL MedianDROP table median_test;CREATE MULTISET TABLE median_test( id INTEGER ,med_group INTEGER ,med_value INTEGER) PRIMARY INDEX (id);INSERT INTO median_test VALUES (1, 1, 1);INSERT INTO median_test VA...
4328 Jun 2006 @ 03:47 PDTToolsReplySize Limit on Varchar / ConcatenatingCheck the SQL manual, Data Types and Literals:Maximum size of a char/varchar is 64000Dieter
4228 Jun 2006 @ 03:44 PDTUDAReplyTutorialIf you installed the demo version there should be a help file with info about how to login, which example databases exist.Dieter
4128 Jun 2006 @ 03:25 PDTDatabaseReplyNeed to run many SQL's at one shot even if error occurs inbetweenIf you export using BTEQ there'll be one output file.Newer versions of QueryMan support it, too:Tools -> Options -> Export/Import -> Write all exported Answersets to a single fileDieter
4028 Jun 2006 @ 03:20 PDTDatabaseReplyLoop through a Macro?A macro can't be call itself, i.e. no recursion.Possible solutions:- Recursion within a BTEQ script, illegal, but working.- Loop within a SPDieter
3928 Jun 2006 @ 03:14 PDTDatabaseReplyget error msg: "Row size or Sort Key size overflow."I've seen this once using ODBC/Queryman, but i can't remember exactly.It could be fixed by modifying the session character set.Dieter
3828 Jun 2006 @ 03:09 PDTDatabaseReplyJoinsThere are no hints in Teradata, so you can't force the optimizer to choose a special join type.Dieter
3728 Jun 2006 @ 03:08 PDTDatabaseReplyVerification of source dataCould you please elaborate, what you're trying to achieve?Dieter
3628 Jun 2006 @ 03:04 PDTDatabaseReplyHow do you declare a variable in Teradata SQL?There are no variables outside of SPs in Teradata.But there are parameters for macros, and if it's a script, you can use shell-variables in Unix.If you provide us with more details, maybe we can sh...
3528 Jun 2006 @ 02:56 PDTDatabaseReplyIs there an Equivilant Function to Execute in Teradata.In your example it's not necessary to use EXECUTE :-)In general, if you want to execute dynamic sql it's only allowed within a SP using a call to dbc.sysexecsql.Of course it's possible to create a ...
3428 Jun 2006 @ 02:36 PDTDatabaseReplyLastAccessDateThat feature is enabled using dbscontrol -> general fields -> ObjectUseCountCollectRatePlease check the manuals before enabling it.Dieter
3328 Jun 2006 @ 02:30 PDTDatabaseReplyNeed to run many SQL's at one shot even if error occurs inbetweenProbably no existing DBMS will do what you want.Of course you can remove the UNION ALL and submit seperate queries.Dieter
3226 Jun 2006 @ 04:05 PDTToolsReplySQL problemHi Amit,it's totally clear, that's why i wrote that solution using distinct.Why didn't you simply try it?Dieter
3123 Jun 2006 @ 02:34 PDTAnalyticsReplyCreate Volatile Table not working with TrimHi Matt,it's not the TRIM it's LENGTH:This is no Teradata SQL, it's ODBC SQL, so replace it with CHAR_LENGTH and your query will run.The reason why it worked without the volatile table is an option...
3023 Jun 2006 @ 02:23 PDTToolsReplySQL problemHi Amit,it's easy if you know how to write a WHERE-condition to filter for data from the last 6 months:select cust_nfrom tabwhere ...group by cust_nhaving count(distinct tr_month) = 6But as the nu...
2919 Jun 2006 @ 04:52 PDTDatabaseReplyCollecting Statistics on multiple ColumnsHi stami27,there's no difference, if you collect stats on (col1, col2) or (col2, col1), because both stats are calculated exactly the same. Simple try it and then use a help stats:The order is defi...

Pages