All forum activity

#DateUserForumTypeThreadPost
104231 May 2006 @ 03:58 PDTJim ChapmanDatabaseReplyAMP on Teradata is UTILITY/DOWNI assume that by "doing a REBOOT on this AMP" you mean that you used the BOOT command of Vprocmanager. The purpose of that command is prepare the AMP for a complete rebuild. Therefore, it erases ...
104131 May 2006 @ 11:08 PDTj355gaTrainingTopicwhat is wrong with prometric?Has anybody had trouble registering on the prometric website? I have tried with both a PC and a MAC and with different browsers but am unable to submit the registration.Calling the help line gets ...
104031 May 2006 @ 10:25 PDTj355gaAnalyticsReplypartitioning results of queryYou can find a detailed introduction in "SQL Reference: Data Manipulation Statements" from the NCR website.
103931 May 2006 @ 08:47 PDTJaguarToolsTopicEncountering error while using .EXPORT REPORT FILE command in BTEQHello Everyone, I have written the following code to extract data to a fileLOGON -------;DATABASE ---- ;SET ERROROUT STDOUT;SET WIDTH 500;SET ECHOREQ OFF;SET TITLEDASHES OFF;EXPORT REP...
103831 May 2006 @ 02:46 PDTHolzyDatabaseTopicAMP on Teradata is UTILITY/DOWNHi experts,I have a Teradata V2R6.1 installed on a WinXP machine. Somehow it got a problem, an the second of two AMPs got FATAL. After doing REBOOT on this AMp it now is UTILITY/Down - and it stays...
103730 May 2006 @ 11:09 PDTpoonamAnalyticsReplypartitioning results of queryHi,could you please explain how to go about this 'EXPLAIN'.???thanks a lot
103630 May 2006 @ 05:15 PDTj355gaAnalyticsReplypartitioning results of query I'd venture to guess you will not need to "partition" your results once you tune the SQL. Suggest you run an EXPLAIN on the INSERT..SELECT and determine where the bottle-neck is in you SQL. This s...
103530 May 2006 @ 05:09 PDTj355gaTrainingReplyTactical queries vs analytical queriesAre you referring to strategic vs. tactical queries? If so you can read about them in the NCR manual: "Introduction to Teradata Warehouse, Teradata Database V2R6.0, Teradata Warehouse 8.0, B035-10...
103430 May 2006 @ 03:57 PDTj355gaDatabaseReplycan we run bteq script/stored procedure from mload?The error you are having with abort is simple - Don't prefix the ABORT with a dot "."There are two different ABORT commands. One is SQL based and works with any Teradata SQL interface. The other A...
103330 May 2006 @ 08:08 PDTbhaskaranTrainingTopicTactical queries vs analytical queriesCan any one send me the info regarding tactical queries vs analytical queries
103230 May 2006 @ 08:01 PDTbhaskaranTrainingReplyNR0-012 Physical Implementation ExamGo to coffingdw.com and register to take up the practice exam. Take up the teradata practice exams too.Send me a test mail to this id bhaskar31@gmail.com. I will send you the material
103130 May 2006 @ 06:23 PDTpoonamAnalyticsTopicpartitioning results of queryhi,i want to run this insert..select query.now since the result set is huge, i am running into spool space problems.is there any way by which i can avoid this.some way by which the result set may b...
103030 May 2006 @ 03:08 PDTJaguarDatabaseReplycan we run bteq script/stored procedure from mload?Hi Vinay, Can you elaborate in detail as to how to go about resolving the issue if you have error tables that are created?Thanks in advance
102929 May 2006 @ 09:12 PDTBBR2DatabaseReplycan we run bteq script/stored procedure from mload?I read some time back having DDL in a MULTILOAD script may affect its restartability. Also it is a good idea that the mload script drops all error and UV tables. I think if these tables are present...
102829 May 2006 @ 09:11 PDTdixonDatabaseReplyDownload Dimensional Modeling (star schema) BookLike that is there any pdf's available on TERADATA Dimensional modelling.
102728 May 2006 @ 07:03 PDTpreetiTrainingTopicNR0-012 Physical Implementation ExamHi,I am interested in preparing and giving the Teradata Physical Implementation Exam NR0-012.If anyone can recommend the material or mail me some practice tests it will be very helpful.Thanks in ad...
102628 May 2006 @ 06:15 PDTpreetiTrainingReplyNR-011 Certificationhi Nithyanandam,ive cleared teradata basics as well as teradata SQL NR0-013. rgds,preeti
102526 May 2006 @ 03:36 PDTstami27-2406DatabaseReplycan we run bteq script/stored procedure from mload?Hi Jaguar,in the official documentation of Database V2R6.1Book SQL Reference: Data Manipulation Statements side 193 ff.,Chapter 3: SQL Data Manipulation Language Statement Syntax,is ABORT described...
102426 May 2006 @ 02:17 PDTElizabeth SchultzJobsTopicTeradata Architect Opportunity - PhoenixHere is your chance to join our DHL team and help us become America's #1 choice for cost-effective and reliable transportation solutions!Candidate needs proven database architect skills with a mini...
102326 May 2006 @ 02:07 PDTpmoe33ToolsReplyDate Comparisions - Differing formatsthanks!
102226 May 2006 @ 12:16 PDTshaik.feroz@aaa-calif.comDatabaseReplyComparing two tablesThank you very much!I really appreciate it.
102126 May 2006 @ 12:13 PDTdnoethToolsReplyDate Comparisions - Differing formatsJust specify a matching format, if the day is missing it will be replaced by the 1st.where '200605' (date, format 'yyyymm') between date1 and date2Dieter
102026 May 2006 @ 09:26 PDTJaguarDatabaseReplycan we run bteq script/stored procedure from mload?Thanks Stami, But i think .Abort option works out better for me as i don't want to drop the tables...I just need to ensure that no error tables are created before i proceed with executi...
101926 May 2006 @ 08:49 PDTstami27-2406DatabaseReplyCan I catch an OUT variable(s) from a stored procedure?Thanks for these suggetion AKIRAgreetingsstami27
101826 May 2006 @ 08:44 PDTstami27-2406DatabaseReplycan we run bteq script/stored procedure from mload?Hi Jaguar, I think u can manage it with the ACTIVITYCOUNT if u want:Here is a suggetion:select count(*) from dbc.tables where tablename='ET_MY_TABLE' and databasename='MY_DB';.if ERRORCODE 0 then ...

Pages