#DateForumTypeThreadPost
1201 Dec 2008 @ 09:42 PSTDatabaseReplyWhat is the difference between roles and profiles?roles=>rightsprofiles=>resourcesHTH.Cheers.carlos.
1124 Oct 2008 @ 06:57 PDTToolsReplythe smart QueryMan for this Query !!! Convert Rows to ColumnsSieger:I think what you are after is solved with recursive SQL.You may take a look here: http://carlosal.wordpress.com/2008/10/15/queries-recursivas-en-teradata/. (It's in spanish!). It will give y...
1029 Aug 2008 @ 06:11 PDTToolsReplyFile record number in mload>>"To my knowledge neither FastLoad or MultiLoad have a mechanism to allow you to perform this task."OK. Many Thanks. This was the answer that I was looking for.>>"Your two options are ...
928 Aug 2008 @ 03:21 PDTToolsReplyFile record number in mloadJeff:If I wanted to use an IDENTITY column, I would have used it.My requirement -and I think I expressed it specifically- is to use the file record number. If there is a way in multiload to access ...
827 Aug 2008 @ 08:11 PDTToolsTopicFile record number in mloadHi all.I'm trying to find a way to get the record number (recno) of a record in the INFILE and use it as an insert value, but I've not been able to sort it out.I've tried &SYSRCDCNT in several ways...
729 Jul 2008 @ 06:00 PDTDatabaseReplyDate data type explanation((YEAR - 1900) * 10000) + (MONTH * 12) + DAY31/12/2007 = 1071231HTH.Cheers.Carlos.
629 Jul 2008 @ 02:44 PDTDatabaseReplyDate data type explanationDATE is stored as INTEGER in TERADATA.HTH.Cheers.Carlos.
519 Jun 2008 @ 10:25 PDTUDATopicData conversions/validations in mload or bteq?Hi all:I'm in a project where we must import information from flat files. We do it in two phases:·First we multiload the files into (staging) temporary tables.·Then we load the target tables from...
409 Jun 2008 @ 04:27 PDTDatabaseReplyTruncate a decimal field without roundingCAST is your friend:[font=Courier New]select cast(cast((123.4567 * 100) as integer) as numeric (9,2)) /100; *** Query completed. One row found. One column returned. *** Total elapsed time was 1 sec...
329 May 2008 @ 03:03 PDTDatabaseReplyPerform Multiplication of all the values for a ColumnHi again>>"Then product should have to be -20 but using log it won't work.>>Using ABS(absolute) will give you the product but will supress>>the sign in the Product value.>>A...
228 May 2008 @ 06:33 PDTDatabaseReplyPerform Multiplication of all the values for a ColumnHi.This is my first answer to any post here (I'm quite new to Teradata, big DB background though).Recalling from my maths: 1. logarithm converts products in sums.2. logarithm and exponentiation are...
128 Apr 2008 @ 09:43 PDTDatabaseTopicMERGE, UPSERT or DROP/DELETE + INSERT SELECTHi all.I'm quite new to Teradata and I'm wondering which of the three methods is the best one for updating rows in a (big) table:1.- MERGE (UPDATE old rows, INSERT new ones).2.- UPSERT (UPDATE old ...

Pages