#DateForumTypeThreadPost
40322 Nov 2008 @ 03:01 PSTAnalyticsReplyFind previous non-null valueThis 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...
40221 Nov 2008 @ 06:33 PSTDatabaseReplyDelete info from DBCHi 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...
40121 Nov 2008 @ 05:20 PSTDatabaseReplyRegarding Teradata MERGE statementHi Koushik,pre-TD12 only supports merge for single rows, so you can't use it.TD12 support (almost) full ANSI-MERGEDieter
40021 Nov 2008 @ 05:18 PSTDatabaseReplyDelete info from DBCHi 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 ...
39918 Nov 2008 @ 03:26 PSTUDAReplyARRAY Structure in Teradata Stored ProcedureHi 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...
39818 Nov 2008 @ 03:21 PSTUDAReplySQL problem - selecting an earlier date in a joinHi 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 ...
39717 Nov 2008 @ 10:57 PSTUDAReplySQL problem - selecting an earlier date in a joinHi Raghu,in a Teradata forum you're supposed to post SQL valid/working on Teradata, but this is MS SQL Server syntax ;-)Dieter
39617 Nov 2008 @ 10:52 PSTUDAReplyNeed the distinct month dateHi 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...
39517 Nov 2008 @ 10:43 PSTUDAReplyTPUMP Log & ER tablesHi Madhavi,you'll find all the details within the manuals:Just check the LOGTABLE and the IMPORT commands.Dieter
39417 Nov 2008 @ 10:35 PSTUDAReplyData ConversionHi 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
39317 Nov 2008 @ 10:32 PSTDatabaseReplyError: 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...
39210 Nov 2008 @ 04:42 PSTDatabaseReplychecking Date data type values in dirty columnIf 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)) ...
39110 Nov 2008 @ 04:32 PSTDatabaseReplytaraData substring functionRecursive 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
39010 Nov 2008 @ 04:28 PSTDatabaseReplyincrease size of teraData databaseThe Teradata demo version has a fixed size, which can't be increased.Better use TD12 demo, this one has a size of 4GB.Dieter
38910 Nov 2008 @ 04:25 PSTDatabaseReplyNull vs Not nullThere'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...
38810 Nov 2008 @ 04:18 PSTDatabaseReplyConcurrent Update of Table by muliple sessionsTeradata 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 ...
38707 Nov 2008 @ 06:24 PSTDatabaseReplyAccessing teradata tables from shell scriptsHi Arun,you might use Perl to access Teradata via Geoffrey Rommel's Teradata::SQLhttp://search.cpan.org/~grommel/Teradata-SQL-0.06/SQL.pmDieter
38607 Nov 2008 @ 06:18 PSTDatabaseReplyReset identity column counterHi 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 ...
38530 Oct 2008 @ 10:10 PDTDatabaseReplySetting 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 ...
38430 Oct 2008 @ 10:05 PDTAnalyticsReplywhere clause with a @ in itHi Maslow:where column not like '40'xc || '%'40'xc -> "x" indicates it's a hex string and "c" it's representing a charDieter
38330 Oct 2008 @ 10:03 PDTToolsReplyCreating 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
38224 Oct 2008 @ 02:22 PDTToolsReplyDead lockTPump:- 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...
38124 Oct 2008 @ 02:02 PDTToolsReplyARCMAIN HELPHi 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...
38022 Oct 2008 @ 07:41 PDTToolsReplyImproving Loading Mechanism using FastloadThe bottleneck is FastLoad's insert phase, if you run several FastLoads in parallel they will compete for the same resources.Dieter
37922 Oct 2008 @ 04:04 PDTToolsReplyImproving 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...

Pages