1042 | 31 May 2006 @ 03:58 PDT | Jim Chapman | Database | Reply | AMP on Teradata is UTILITY/DOWN | I 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 ... |
1041 | 31 May 2006 @ 11:08 PDT | j355ga | Training | Topic | what 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 ... |
1040 | 31 May 2006 @ 10:25 PDT | j355ga | Analytics | Reply | partitioning results of query | You can find a detailed introduction in "SQL Reference: Data Manipulation Statements" from the NCR website. |
1039 | 31 May 2006 @ 08:47 PDT | Jaguar | Tools | Topic | Encountering error while using .EXPORT REPORT FILE command in BTEQ | Hello 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... |
1038 | 31 May 2006 @ 02:46 PDT | Holzy | Database | Topic | AMP on Teradata is UTILITY/DOWN | Hi 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... |
1037 | 30 May 2006 @ 11:09 PDT | poonam | Analytics | Reply | partitioning results of query | Hi,could you please explain how to go about this 'EXPLAIN'.???thanks a lot |
1036 | 30 May 2006 @ 05:15 PDT | j355ga | Analytics | Reply | partitioning 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... |
1035 | 30 May 2006 @ 05:09 PDT | j355ga | Training | Reply | Tactical queries vs analytical queries | Are 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... |
1034 | 30 May 2006 @ 03:57 PDT | j355ga | Database | Reply | can 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... |
1033 | 30 May 2006 @ 08:08 PDT | bhaskaran | Training | Topic | Tactical queries vs analytical queries | Can any one send me the info regarding tactical queries vs analytical queries |
1032 | 30 May 2006 @ 08:01 PDT | bhaskaran | Training | Reply | NR0-012 Physical Implementation Exam | Go 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 |
1031 | 30 May 2006 @ 06:23 PDT | poonam | Analytics | Topic | partitioning results of query | hi,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... |
1030 | 30 May 2006 @ 03:08 PDT | Jaguar | Database | Reply | can 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 |
1029 | 29 May 2006 @ 09:12 PDT | BBR2 | Database | Reply | can 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... |
1028 | 29 May 2006 @ 09:11 PDT | dixon | Database | Reply | Download Dimensional Modeling (star schema) Book | Like that is there any pdf's available on TERADATA Dimensional modelling. |
1027 | 28 May 2006 @ 07:03 PDT | preeti | Training | Topic | NR0-012 Physical Implementation Exam | Hi,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... |
1026 | 28 May 2006 @ 06:15 PDT | preeti | Training | Reply | NR-011 Certification | hi Nithyanandam,ive cleared teradata basics as well as teradata SQL NR0-013. rgds,preeti |
1025 | 26 May 2006 @ 03:36 PDT | stami27-2406 | Database | Reply | can 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... |
1024 | 26 May 2006 @ 02:17 PDT | Elizabeth Schultz | Jobs | Topic | Teradata Architect Opportunity - Phoenix | Here 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... |
1023 | 26 May 2006 @ 02:07 PDT | pmoe33 | Tools | Reply | Date Comparisions - Differing formats | thanks! |
1022 | 26 May 2006 @ 12:16 PDT | shaik.feroz@aaa-calif.com | Database | Reply | Comparing two tables | Thank you very much!I really appreciate it. |
1021 | 26 May 2006 @ 12:13 PDT | dnoeth | Tools | Reply | Date Comparisions - Differing formats | Just 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 |
1020 | 26 May 2006 @ 09:26 PDT | Jaguar | Database | Reply | can 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... |
1019 | 26 May 2006 @ 08:49 PDT | stami27-2406 | Database | Reply | Can I catch an OUT variable(s) from a stored procedure? | Thanks for these suggetion AKIRAgreetingsstami27 |
1018 | 26 May 2006 @ 08:44 PDT | stami27-2406 | Database | Reply | can 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 ... |