305 | 29 Oct 2007 @ 01:04 PDT | Database | Reply | Formatting for percentage and currency | Format 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... |
304 | 27 Oct 2007 @ 01:52 PDT | Analytics | Reply | String 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... |
303 | 26 Oct 2007 @ 03:22 PDT | Database | Reply | Formatting for percentage and currency | you 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. |
302 | 26 Oct 2007 @ 03:18 PDT | Database | Reply | Alter Table | As 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... |
301 | 26 Oct 2007 @ 03:13 PDT | Tools | Reply | Configure BTEQ.MLOAD,FLOAD,FEXPORT and TPUMP for DEMO CD | Database 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... |
300 | 25 Oct 2007 @ 02:50 PDT | Tools | Reply | Need help on arcmain | can you try something like this ...ANALYZE ALL, FILE=putFullFilePathIncludingFileNameHere ; |
299 | 24 Oct 2007 @ 01:07 PDT | Tools | Reply | Need help on arcmain | you 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. |
298 | 23 Oct 2007 @ 05:53 PDT | Database | Reply | Help 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... |
297 | 20 Oct 2007 @ 12:09 PDT | Analytics | Reply | how to extract only mondays in 2007 | That'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... |
296 | 19 Oct 2007 @ 12:59 PDT | Database | Reply | problem with derived table | it'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 "... |
295 | 18 Oct 2007 @ 01:54 PDT | Tools | Reply | how to remove hyphens | You 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... |
294 | 18 Oct 2007 @ 12:59 PDT | Training | Reply | How many Certified Teradata Masters | The 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. |
293 | 18 Oct 2007 @ 12:51 PDT | Database | Reply | Fastload Fixed Length Problem | Sounds 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... |
292 | 18 Oct 2007 @ 12:42 PDT | Analytics | Reply | how to extract only mondays in 2007 | The "order by 1" clause is not required, he must have accidentally put it there ...... remove it and the query will work fine. |
291 | 17 Oct 2007 @ 01:27 PDT | Database | Reply | Teradata 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... |
290 | 11 Oct 2007 @ 01:06 PDT | Database | Reply | Find position of a substring | if 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. |
289 | 11 Oct 2007 @ 12:57 PDT | Analytics | Reply | Naming Primary Indexes | Also 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.... |
288 | 10 Oct 2007 @ 05:37 PDT | Database | Reply | What is dynamic sql | REPLACE 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... |
287 | 10 Oct 2007 @ 01:29 PDT | Connectivity | Reply | Help - Unable to assign char value to a var within cursor for statement | D_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... |
286 | 09 Oct 2007 @ 02:09 PDT | UDA | Reply | Fastload | There 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... |
285 | 09 Oct 2007 @ 01:58 PDT | Training | Reply | Teradata Certification. | Go to the Teradata certified program website and download the guidehttp://www.teradata.com/t/page/112754/index.html |
284 | 09 Oct 2007 @ 01:56 PDT | Tools | Reply | Problem with bteq | My guess would be that the .GOTO JobAbend in the line after the .IF statement would be causing the trouble for you ? |
283 | 09 Oct 2007 @ 01:38 PDT | Connectivity | Reply | Newly added features and Utilities in Teradata V2R6.2.1 | I 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... |
282 | 09 Oct 2007 @ 01:25 PDT | UDA | Reply | Difference 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... |
281 | 09 Oct 2007 @ 01:13 PDT | Analytics | Reply | Transpose Columns to Rows | Couldn'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... |