403 | 22 Nov 2008 @ 03:01 PST | Analytics | Reply | Find previous non-null value | This is an old SQL-trick :-) but probably the best solution for your problem. At least it's the only one without nested OALP-functions, i once tried to find a better solution, but never suceeded.As... |
402 | 21 Nov 2008 @ 06:33 PST | Database | Reply | Delete info from DBC | Hi Jehan,the CHANGEDROWJOURNAL is used when an AMP is out of service to capture changes for Fallback tables.The conclusion is: an AMP is FATAL.Start the Database Window, click on the Suprv window a... |
401 | 21 Nov 2008 @ 05:20 PST | Database | Reply | Regarding Teradata MERGE statement | Hi Koushik,pre-TD12 only supports merge for single rows, so you can't use it.TD12 support (almost) full ANSI-MERGEDieter |
400 | 21 Nov 2008 @ 05:18 PST | Database | Reply | Delete info from DBC | Hi Jehan,your other post sowed that dbc is way over it's limit. This might happen, because some system tables are owned by dbc but are not counted for a "no more room in database". I know of three ... |
399 | 18 Nov 2008 @ 03:26 PST | UDA | Reply | ARRAY Structure in Teradata Stored Procedure | Hi Harshad,could you provide more details what you're trying to achieve? I can hardy think of any problem where an array is really needed, which can't be rewritten using SQL.Faking an array is usua... |
398 | 18 Nov 2008 @ 03:21 PST | UDA | Reply | SQL problem - selecting an earlier date in a join | Hi Chris,i successfully imlemented following approach for a similar problem, which previously caused huge intermediate spools because of product joins:UNION join columns from both tables, then use ... |
397 | 17 Nov 2008 @ 10:57 PST | UDA | Reply | SQL problem - selecting an earlier date in a join | Hi Raghu,in a Teradata forum you're supposed to post SQL valid/working on Teradata, but this is MS SQL Server syntax ;-)Dieter |
396 | 17 Nov 2008 @ 10:52 PST | UDA | Reply | Need the distinct month date | Hi Raghu,don't use MONTH(x), because it's *not* Standard SQL, better use joedsilva's EXTRACT(MONTH FROM x).MONTH(x) is ODBC SQL and will only work in SQL Assistant if "Allow Use of ODBC SQL Extens... |
395 | 17 Nov 2008 @ 10:43 PST | UDA | Reply | TPUMP Log & ER tables | Hi Madhavi,you'll find all the details within the manuals:Just check the LOGTABLE and the IMPORT commands.Dieter |
394 | 17 Nov 2008 @ 10:35 PST | UDA | Reply | Data Conversion | Hi Raghu,since the very early days of SQL it is possible to CAST a string to a numeric value, why do you think it's not allowed?Dieter |
393 | 17 Nov 2008 @ 10:32 PST | Database | Reply | Error: Syntax error: expected something between '(' and the 'select' keyword. | There's good news and bad news :-)The bad news: Teradata still doesn't support Scalar Subqueries within the SELECT list, yet (This will be implemented in TD13)The good news:In most cases those Scal... |
392 | 10 Nov 2008 @ 04:42 PST | Database | Reply | checking Date data type values in dirty column | If the data is always that format you might use a join to sys_calendar.calendar:SELECT x, calendar_dateFROM dropme LEFT JOIN sys_calendar.calendarON TRIM(x) = TRIM(EXTRACT(DAY FROM calendar_date)) ... |
391 | 10 Nov 2008 @ 04:32 PST | Database | Reply | taraData substring function | Recursive queries have been implemented in V2R6, but your other posts show you're runng a V2R5 demo.Another reason to ugrade to a TD12 demo :-)Dieter |
390 | 10 Nov 2008 @ 04:28 PST | Database | Reply | increase size of teraData database | The Teradata demo version has a fixed size, which can't be increased.Better use TD12 demo, this one has a size of 4GB.Dieter |
389 | 10 Nov 2008 @ 04:25 PST | Database | Reply | Null vs Not null | There's a basic rule for all DBMSes: Never use NOT IN on NULLable columns, because this might return unexpected result sets, because it will use three-way logic.Compare both Explains and you'll see... |
388 | 10 Nov 2008 @ 04:18 PST | Database | Reply | Concurrent Update of Table by muliple sessions | Teradata locks only on two levels:Full Table Scans & NUSI access locks the full table, whereas PI/USI-access locks a rowhash.If you get rowhash locks you might do multiple read/write-operations on ... |
387 | 07 Nov 2008 @ 06:24 PST | Database | Reply | Accessing teradata tables from shell scripts | Hi Arun,you might use Perl to access Teradata via Geoffrey Rommel's Teradata::SQLhttp://search.cpan.org/~grommel/Teradata-SQL-0.06/SQL.pmDieter |
386 | 07 Nov 2008 @ 06:18 PST | Database | Reply | Reset identity column counter | Hi srinivas,you can't reset an identity, just replace NO CYCLE with CYCLE, if you delete all rows before the next load you'll never get duplicates.But i'm curious, when it's a staging table why do ... |
385 | 30 Oct 2008 @ 10:10 PDT | Database | Reply | Setting up the database | "I do not see any system related tables like dbc.tables"What does "see" mean in that context?I can't connect?If i submit "select * from dbc.tables;" there's an error or just no result set?Or is it ... |
384 | 30 Oct 2008 @ 10:05 PDT | Analytics | Reply | where clause with a @ in it | Hi Maslow:where column not like '40'xc || '%'40'xc -> "x" indicates it's a hex string and "c" it's representing a charDieter |
383 | 30 Oct 2008 @ 10:03 PDT | Tools | Reply | Creating QCD in one database, for Visual Explain in another? | Hi Yari,use "DUMP EXPLAIN ..." in your session to DWH, this returns a lot of INSERTs.You might run those in another session connected to the demo version.Dieter |
382 | 24 Oct 2008 @ 02:22 PDT | Tools | Reply | Dead lock | TPump:- if you use multiple sessions, be shure to SERIALIZE on the PI columns- use ARRAYSUPPORT ON-In worst case you have to set PACK to 1Can't you combine both jobs into 1 or run them serially?MLo... |
381 | 24 Oct 2008 @ 02:02 PDT | Tools | Reply | ARCMAIN HELP | Hi Moses,your external drive is probably formatted with FAT32, which limits maximum file size to 4GB.Re-format using NTFS, but then you might not be able to access it from some older Windows-versio... |
380 | 22 Oct 2008 @ 07:41 PDT | Tools | Reply | Improving Loading Mechanism using Fastload | The bottleneck is FastLoad's insert phase, if you run several FastLoads in parallel they will compete for the same resources.Dieter |
379 | 22 Oct 2008 @ 04:04 PDT | Tools | Reply | Improving Loading Mechanism using Fastload | **** 00:35:21 Number of recs/msg: 1 **** 00:35:21 Starting to send to RDBMS with record 1**** 00:36:05 Sending row 100000**** 00:40:50 Sending row 200000**** 00:43:51 Sending row 300000**** 00:45:4... |