All forum activity

#DateUserForumTypeThreadPost
129207 Jul 2006 @ 02:39 PDTteenup3ToolsReplyerror while using fastload. ?Feroz,Do check the entry in your "host" file.Also refer to following links for additional information:http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=10&messageid=2000http://www.terad...
129106 Jul 2006 @ 08:49 PDTJohn MacDatabaseReplyDropping PPI partitionsVinay,Sorry, how rude, thanks also for your reply. There's nothing more dispiriting than having a forum posting ignored.Cheers
129006 Jul 2006 @ 08:48 PDTJohn MacDatabaseReplyDropping PPI partitionsDieter,Many thanks - I hadn't made the connection between having to have no NO RANGE when using WITH DELETE.The developers won't be happy though - they'll have to clean their data prior to loading ...
128906 Jul 2006 @ 06:37 PDTshaik.feroz@aaa-calif.comDatabaseTopicerror while using fastload. ?All,I am trying to use fastload (interactive mode) and i get this error.I am able to connect using ODBC (sql assistant)i am using windows environment, and i added the server name and IP address in ...
128806 Jul 2006 @ 06:36 PDTshaik.feroz@aaa-calif.comToolsTopicerror while using fastload. ?All,I am trying to use fastload (interactive mode) and i get this error.I am able to connect using ODBC (sql assistant)i am using windows environment, and i added the server name and IP address in ...
128706 Jul 2006 @ 05:32 PDTalvinyingDatabaseTopicProblem with Recursive ViewI've created a recursive view (A) using the "REPLACE RECURSIVE VIEW" command. It's working fine.The problem comes when I tried to create a non-recursive view (B) as following:Create View B (id) As(...
128606 Jul 2006 @ 02:03 PDTPhaniDatabaseReplyProblem with installation Teradata V2R6I guess you have administrative privileges on that machine. Is it a brand new installation or upgrading to newer version?
128506 Jul 2006 @ 01:40 PDTBBR2AnalyticsReplyIS-NUMERIC functionsYou can try thisPosition will ensure that we have taken care or space in between two numbers.SELsno -- CHAR type,CASE WHEN (POSITION(' ' IN TRIM(sno)) > 0) OR (UPPER(TRIM(sno)) (CASESPECIFIC) LO...
128406 Jul 2006 @ 01:06 PDTBarry-1604AnalyticsReplyIS-NUMERIC functionsThere is a "to_number" UDF posted on Teradata's UDF site with the "Oracle" UDF's. Using this function, if the string cannot be converted to a number, the function will return a NULL. So, you can s...
128306 Jul 2006 @ 12:51 PDTBBR2DatabaseReplyDropping PPI partitionsI belive if you are running on V2R5 there is this issue w/t inconsistent results set if you are dealing a partitioned tables.I also believe this has been addressed in later releases.You may want to...
128206 Jul 2006 @ 12:47 PDTflaskaAnalyticsTopicIS-NUMERIC functionsHello,this is my problem:I need to find out with a query, all the non numeric charaters in a field. The field is a varchar but should contain only telephone number, does exist a ISNUMERIC funtions?...
128106 Jul 2006 @ 12:39 PDTBBR2ToolsReplyStored ProceduresConfigure your ODBC connection to return the result set as Start > run > odbcad32This launches ODBC Adminstrator windowSelect the connection setting (Your ODBC connection setting for accessing TD)T...
128006 Jul 2006 @ 10:47 PDTphilyq1ToolsReplyStored ProceduresIn debugging a procedure, how do I see the return value using Teradata sql assistant. I know you can print a value for debugging but I don't know how to create a procedure with print option enable...
127906 Jul 2006 @ 07:53 PDTkathykAnalyticsReplycount of distinctIf the text conversion causes issues, you may want to try a GROUP BY of INVENTORY_ITEM_KEY,COST_TYPE_KEY instead of concatenating.
127806 Jul 2006 @ 07:46 PDTBarry-1604AnalyticsReplycount of distinctYou can concatenate the columns together:select count(distinct INVENTORY_ITEM_KEY || COST_TYPE_KEY) from ITEM_COST_DETAILS_FBe aware that this will convert both columns to a CHARACTER data type bef...
127706 Jul 2006 @ 07:17 PDTdnoethDatabaseReplyDropping PPI partitionsHi John,there's a NO RANGE partition and all rows have been moved to that partition.In that case the delete from the old partition and the merge into the no range partition where transient journale...
127606 Jul 2006 @ 06:53 PDTdixonAnalyticsTopiccount of distinctHow to get the count(combination of distinct values of two columns together). i am giving the query in the following wayselect count(distinct INVENTORY_ITEM_KEY,COST_TYPE_KEY) from ITEM_COST_DETAIL...
127506 Jul 2006 @ 02:17 PDTJohn MacDatabaseTopicDropping PPI partitionsAnybody had issues dropping PPI partitions ?We have a PPI table (3.2 Billion rows, 12 months data, partitioned by month). Lat night, a Prod job attempted to drop the oldest partition (approx 164 mi...
127405 Jul 2006 @ 05:43 PDTnithyanandamTrainingReplyNR-011 CertificationThe same question has been answered countless times.... I'd request you to spend some time searching the forum before posting your question.
127305 Jul 2006 @ 10:41 PDTKrustyDatabaseTopicProblem with installation Teradata V2R6Hi I´m trying to install Teradata V2R6 but I have problem with the file librtsl.dll. I am getting an installation error message "Could not create librtsl.dll"Could you tell me how do you solve the...
127205 Jul 2006 @ 10:40 PDTKrustyDatabaseTopicProblem with installation Teradata V2R6Hi I´m trying to install Teradata V2R6 but I have problem with the file librtsl.dll. I am getting an installation error message "Could not create librtsl.dll"Could you tell me how do you solve the...
127105 Jul 2006 @ 03:59 PDTKir BojoToolsReplyFastLoad Performance Tuning for large volumes of input dataPlease find below some snippets of the output log of fastload: **** 10:28:43 Processing starting at: Tue Jul 4 10:28:43 2006**** 10:28:43 Character set has been set to: ASCII**** 10:28:43 Tena...
127005 Jul 2006 @ 12:13 PDTgiriUDAReplySQLhai The fact is that, we go for dimensional modeling insted on TNF is due to the limitations of the OLAP tools. teradata can perform effectively with the TNF table structure.
126904 Jul 2006 @ 11:45 PDTBBR2ToolsReplyFastLoad Performance Tuning for large volumes of input dataHmmm...Can you post more information * Network bandwidth details (client/host)* Current workload details* Number of sessions used by Fast load* Actual process - Are you dropping and recreating the ...
126804 Jul 2006 @ 11:44 PDTBBR2ToolsReplyFastLoad Performance Tuning for large volumes of input dataHmmm...Can you post more information * Network bandwidth details (client/host)* Current workload details* Number of sessions used by Fast load* Actual process - Are you dropping and recreating the ...

Pages