492 | 10 Mar 2006 @ 07:15 PST | GreatSushant | Database | Topic | AMP in Online Catchup state | Some days back due to some problem my v2r6 database wen down . It is MA-RAS unix box and was down . The AMP state is shown as Online catchup modethis is the error log for this DElogd: Event number ... |
491 | 10 Mar 2006 @ 06:33 PST | shrikrishna | Database | Topic | Spool Space Error | Hi,I am trying to retrive data by using date condition as substring(columnname from 1 for 6)='20060301'but its giving spool space error. Is there any other way to do the same?I am using only 39% of... |
490 | 10 Mar 2006 @ 05:05 PST | dixon | Database | Reply | Timestamp format on teradata retrieval | Hi Dietercan u explain me how it is showing 2006-03-07 12:49:29 for the next part. i am amazed the format u have mentioned i.e ts (timestamp(0), format 'MM/DD/YYYYBHH:MI:SS')in the second part and ... |
489 | 09 Mar 2006 @ 09:48 PST | PajinkO | Database | Reply | timestamp to timestamp(0) | Thanks TD_Arch |
488 | 09 Mar 2006 @ 04:40 PST | ayes | Database | Reply | teradata database service is not starting | Hi Barry,Yes , I am using Windows XP SP2. And ODBC DSN pointed to 127.0.0.1.Any other sugession?Regards, |
487 | 09 Mar 2006 @ 02:10 PST | Barry-1604 | Database | Reply | teradata database service is not starting | It must not be required to be started, because I can access the database fine without it being started.You should just need to start the database through the "Teradata Service Control" window and t... |
486 | 09 Mar 2006 @ 11:30 PST | shaik.feroz@aaa-calif.com | Tools | Reply | fastexport and fastload forutf8 table | Did you figure it out?your post helped me in figuring out how to extract with format fastload mode indicators and the use it to load in table using fastload script. Thank you very much.now regardin... |
485 | 09 Mar 2006 @ 11:20 PST | shaik.feroz@aaa-calif.com | Tools | Reply | Fast Export | This is very strange i am not sure why we get that extra char after casting each field in the select statement.The last post wich has cast( cast(......) as (sum of all the filed lengths) should wor... |
484 | 09 Mar 2006 @ 10:29 PST | Swamy | Tools | Reply | Alert by Email during mload error | Hi,One way would be After Mload use a BTEQ to query for the error table if present quit on some value say '99' and use your OS to mail when the return code is 99.Thanks. |
483 | 09 Mar 2006 @ 05:21 PST | TDUser-781 | Database | Reply | on product join | Well, this is a bit wide question....To start, try analyzing the explain plan and collecting statistics on the join fields.Bye,TDUser |
482 | 09 Mar 2006 @ 04:36 PST | dixon | Database | Topic | on product join | how to eliminate product join in a query? |
481 | 09 Mar 2006 @ 04:09 PST | TDUser-781 | Database | Reply | teradata Certification Question model help | Hi,take a look athttp://teradata.ncr-education.com/cgi-shell/wbt/dologin.pl?learning/TDCert/loginV2R5.htmand you'll find some tests.Bye,TDUser |
480 | 09 Mar 2006 @ 03:42 PST | chithuram | Database | Topic | teradata Certification Question model help | Hi every one..I am having a plan to do basic first level certification. pls send me model question with answer.reardsChidamMail Id :chithuram2003@yahoo.co.in |
479 | 08 Mar 2006 @ 10:47 PST | ayes | Database | Reply | teradata database service is not starting | hi barry,thanks for the response. yes , the services "Teradata GTW Reserve Port" and "Teradata inetd Service" are running perfectly fine, but still i am not able to access the database.Is`the servi... |
478 | 08 Mar 2006 @ 11:29 PST | Vik2006 | Tools | Topic | Alert by Email during mload error | I have this requirement when error table gets generated during the MLOAD, I want to send an email. If anyone has done this before, can you send me the possible solutions for this problem?Thanks. |
477 | 08 Mar 2006 @ 10:42 PST | Coghan | Database | Reply | How to Use Input Parameters | Yes, thanks. I did it and it worked. Was able to pass the parms to it via VB in ACCESS and it worked like a charm, so it is totally automated now. I appreciate the help! |
476 | 08 Mar 2006 @ 10:36 PST | TD_Arch | Database | Reply | How to Use Input Parameters | It will stay there in the database where you create it, as long as you dont drop it.So, you do not need to recreate it. Hope that answers you. |
475 | 08 Mar 2006 @ 08:48 PST | Coghan | Database | Reply | How to Use Input Parameters | Thanks. Hey it was weird how my colon and P turned into graphics. Obviously there is some setting in this forum that converted it from an emoticon to graphics... whatever, ha ha.Anyway, I have on... |
474 | 08 Mar 2006 @ 08:40 PST | Barry-1604 | Database | Reply | Secondary Index | I would not collect stats on the column every time you load unless the column is a date column that is always getting incremented with each load. You can also have an issue if you're doing range-b... |
473 | 08 Mar 2006 @ 08:28 PST | Barry-1604 | Database | Reply | teradata database service is not starting | If you are checking the "Teradata Database Initiator" service, it is normal for that to show as "stopped". The services that should be running are: "Teradata GTW Reserve Port" and "Teradata inetd... |
472 | 08 Mar 2006 @ 03:20 PST | GreatSushant | UDA | Reply | Data retrieval query | To add more on this select current_date;03/08/2006select extract(day from date-1);7select current_date-extract(day from date-1 );03/01/2006select current_date-extract(day from date);02/28/2006I t... |
471 | 08 Mar 2006 @ 02:57 PST | kusuma | Training | Topic | Preparing for Physical Implementation Level | Hi All, I have successfully completed my SQL also.Can anyone guide me in preparing for PI level.Is that only the teradata doccumentation doccuments enough for this level or is there any other th... |
470 | 08 Mar 2006 @ 02:09 PST | TD_Arch | Database | Reply | Delete Operation | Transient journalling had been in progress, so the rollback too will take a good time to complete. |
469 | 08 Mar 2006 @ 02:07 PST | TD_Arch | Database | Reply | How to Use Input Parameters | This is the way to create.CREATE MACRO MYDATABASE.MYMACRO(PARAM1VAL INTEGER,PARAM2VAL INTEGER)as(SELECT Emp_NameFROM MyTableWHEREEmp_Number Between :param1Val and :param2Val;);To execute, just give... |
468 | 08 Mar 2006 @ 02:03 PST | TD_Arch | Database | Reply | timestamp to timestamp(0) | This one will work for you : insert into destination ( dateA )select cast(cast(dateB as varchar(19)) as timestamp(0))from source |