#DateForumTypeThreadPost
30529 Oct 2007 @ 01:04 PDTDatabaseReplyFormatting for percentage and currencyFormat clauses are applicable to other data types as well, it's sort of a "hint" to the application querying the data as to how the data should be (desirably) displayed. But applications are free t...
30427 Oct 2007 @ 01:52 PDTAnalyticsReplyString Search and Replace.you can make use of a combination of postition, substring, character_length functions and the concatenation operator (||) to accomplish this. The syntax and details are available in the functions a...
30326 Oct 2007 @ 03:22 PDTDatabaseReplyFormatting for percentage and currencyyou are almost there, apply the format clause fist (lookup the data types and literals manual for currency formats and pick your choice) and then cast the whole thing to a string.
30226 Oct 2007 @ 03:18 PDTDatabaseReplyAlter TableAs Dieter mentioned, you can't alter a column, if the changes the physical storage, which implies that you can't alter CHAR(n)to alter varchar(n), you can use the same sytnax for adding a new colum...
30126 Oct 2007 @ 03:13 PDTToolsReplyConfigure BTEQ.MLOAD,FLOAD,FEXPORT and TPUMP for DEMO CDDatabase setup wizard is meant for teradata manager setup, you **really** don't have to go there !.You can use your sql assistant/ Teradata Administrator to login to the teradata database (make sur...
30025 Oct 2007 @ 02:50 PDTToolsReplyNeed help on arcmaincan you try something like this ...ANALYZE ALL, FILE=putFullFilePathIncludingFileNameHere ;
29924 Oct 2007 @ 01:07 PDTToolsReplyNeed help on arcmainyou can use the ANALYZE command to get that information. you don't have to login to database to do it.look up the syntax and listing options in the archive and recovery manual.
29823 Oct 2007 @ 05:53 PDTDatabaseReplyHelp with ERRORCODE.You can better use some bteq tricks to do this sort of work#/usr/bin/kshPRODDB=prod1db; export PRODDBMYTBL=acctstbl; export MYTBLbteq <<- END.run file mylogon;SELECT TABLENAMEFROM DBC.TABLESW...
29720 Oct 2007 @ 12:09 PDTAnalyticsReplyhow to extract only mondays in 2007That's because it's pointless to have an order by clause in a subquery.For example if you writeSEL A FROM TAB1 WHERE A IN (SELECT B FROM TAB2 WHERE B IS NOT NULL)your are saying you need all the "A...
29619 Oct 2007 @ 12:59 PDTDatabaseReplyproblem with derived tableit's difficult to say anything without seeing the actual query or the data demographics.you are doing a product join of all the three derived tables.Now the effect of that could vary from "ok" to "...
29518 Oct 2007 @ 01:54 PDTToolsReplyhow to remove hyphensYou will have to use a combination of SUBSTRING (gives you a portion of a string, takes as argument start [and end] positions) and POSITION (looks up a character's first position in a string) to ge...
29418 Oct 2007 @ 12:59 PDTTrainingReplyHow many Certified Teradata MastersThe 1000th master was "ordained" ;) during the 2006 partners... considering that it's almost an year since, I guess the numbers should have gone up a lot by now.
29318 Oct 2007 @ 12:51 PDTDatabaseReplyFastload Fixed Length ProblemSounds like an oxymoron... how can you call a file fixed width, if the record length is varying ?most likely your file definition has VARCHAR(n) but table is of CHAR(n) (just my guess from your pos...
29218 Oct 2007 @ 12:42 PDTAnalyticsReplyhow to extract only mondays in 2007The "order by 1" clause is not required, he must have accidentally put it there ...... remove it and the query will work fine.
29117 Oct 2007 @ 01:27 PDTDatabaseReplyTeradata equivalent of Oracle RAISE_APPLICATION_ERROR or MS SQL RAISERROR?I don't recall if there was a straight forward way to do that other than doing some weird trick like doing a divide by zero or so (in which case anyhow you won't pass a sensible message upstream).B...
29011 Oct 2007 @ 01:06 PDTDatabaseReplyFind position of a substringif you need only the first 3 occurences, try using a combination of SUBSTRINGand POSITION (you will have to nest the function calls).Lookup the functions and operators manual for syntax.
28911 Oct 2007 @ 12:57 PDTAnalyticsReplyNaming Primary IndexesAlso some times you would find it helpful to collect stats on columns which are not part of indices, but are used in joins, where clause etc. as well as the special column PARTITION in case of PPI....
28810 Oct 2007 @ 05:37 PDTDatabaseReplyWhat is dynamic sqlREPLACE PROCEDURE HARDDEL(IN TBLNAME VARCHAR(30))BEGIN CALL DBC.SYSEXECSQL('DELETE FROM ' || TBLNAME || ' WHERE REC_ERR IS NOT NULL ;');ENDThe above procedure is an example for the use of dynamic...
28710 Oct 2007 @ 01:29 PDTConnectivityReplyHelp - Unable to assign char value to a var within cursor for statementD_SYMP is initially NULLand when you have NULL || "anything" it gives you NULL not "anything"so you never get anything out !!That's probably what happened in your case ...you can declare the va...
28609 Oct 2007 @ 02:09 PDTUDAReplyFastloadThere are .SET and .IF commands in bteq, but you will find that it has syntatic and semantic variations with it's bteq counter part.I would recommed you go through the Mload command reference to se...
28509 Oct 2007 @ 01:58 PDTTrainingReplyTeradata Certification.Go to the Teradata certified program website and download the guidehttp://www.teradata.com/t/page/112754/index.html
28409 Oct 2007 @ 01:56 PDTToolsReplyProblem with bteqMy guess would be that the .GOTO JobAbend in the line after the .IF statement would be causing the trouble for you ?
28309 Oct 2007 @ 01:38 PDTConnectivityReplyNewly added features and Utilities in Teradata V2R6.2.1I don't recall anything being deprecated between V2R5 and V2R6 ...Nor should you have trouble with your existing Fastload/mload/fexp etc scripts ...You should be able to get the listing of new stuf...
28209 Oct 2007 @ 01:25 PDTUDAReplyDifference and concepts of ETL.From a non-technical standpoint, also remember that there are lots of folks who know tools like Informatica, DataStage etc out there compared to folks who are comfortable with Teradata ETL tools, t...
28109 Oct 2007 @ 01:13 PDTAnalyticsReplyTranspose Columns to RowsCouldn't test, ... but may be something like this ...SEL 'VAR1' VARIABLES, A.AVAR1 "AVG", M.MVAR1 "MIN" FROM AVGTBL A, MINTBL MUNION ALLSEL 'VAR2', A.AVAR2, M.MVAR2 FROM AVGTBL A, MINTBL MUNION ALL...

Pages