All forum activity

#DateUserForumTypeThreadPost
49210 Mar 2006 @ 07:15 PSTGreatSushantDatabaseTopicAMP in Online Catchup stateSome 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 ...
49110 Mar 2006 @ 06:33 PSTshrikrishnaDatabaseTopicSpool Space ErrorHi,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...
49010 Mar 2006 @ 05:05 PSTdixonDatabaseReplyTimestamp format on teradata retrievalHi 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 ...
48909 Mar 2006 @ 09:48 PSTPajinkODatabaseReplytimestamp to timestamp(0)Thanks TD_Arch
48809 Mar 2006 @ 04:40 PSTayesDatabaseReplyteradata database service is not startingHi Barry,Yes , I am using Windows XP SP2. And ODBC DSN pointed to 127.0.0.1.Any other sugession?Regards,
48709 Mar 2006 @ 02:10 PSTBarry-1604DatabaseReplyteradata database service is not startingIt 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...
48609 Mar 2006 @ 11:30 PSTshaik.feroz@aaa-calif.comToolsReplyfastexport and fastload forutf8 tableDid 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...
48509 Mar 2006 @ 11:20 PSTshaik.feroz@aaa-calif.comToolsReplyFast ExportThis 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...
48409 Mar 2006 @ 10:29 PSTSwamyToolsReplyAlert by Email during mload errorHi,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.
48309 Mar 2006 @ 05:21 PSTTDUser-781DatabaseReplyon product joinWell, this is a bit wide question....To start, try analyzing the explain plan and collecting statistics on the join fields.Bye,TDUser
48209 Mar 2006 @ 04:36 PSTdixonDatabaseTopicon product joinhow to eliminate product join in a query?
48109 Mar 2006 @ 04:09 PSTTDUser-781DatabaseReplyteradata Certification Question model helpHi,take a look athttp://teradata.ncr-education.com/cgi-shell/wbt/dologin.pl?learning/TDCert/loginV2R5.htmand you'll find some tests.Bye,TDUser
48009 Mar 2006 @ 03:42 PSTchithuramDatabaseTopicteradata Certification Question model helpHi 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
47908 Mar 2006 @ 10:47 PSTayesDatabaseReplyteradata database service is not startinghi 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...
47808 Mar 2006 @ 11:29 PSTVik2006ToolsTopicAlert by Email during mload errorI 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.
47708 Mar 2006 @ 10:42 PSTCoghanDatabaseReplyHow to Use Input ParametersYes, 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!
47608 Mar 2006 @ 10:36 PSTTD_ArchDatabaseReplyHow to Use Input ParametersIt 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.
47508 Mar 2006 @ 08:48 PSTCoghanDatabaseReplyHow to Use Input ParametersThanks. 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...
47408 Mar 2006 @ 08:40 PSTBarry-1604DatabaseReplySecondary IndexI 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...
47308 Mar 2006 @ 08:28 PSTBarry-1604DatabaseReplyteradata database service is not startingIf 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...
47208 Mar 2006 @ 03:20 PSTGreatSushantUDAReplyData retrieval queryTo 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...
47108 Mar 2006 @ 02:57 PSTkusumaTrainingTopicPreparing for Physical Implementation LevelHi 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...
47008 Mar 2006 @ 02:09 PSTTD_ArchDatabaseReplyDelete OperationTransient journalling had been in progress, so the rollback too will take a good time to complete.
46908 Mar 2006 @ 02:07 PSTTD_ArchDatabaseReplyHow to Use Input ParametersThis 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...
46808 Mar 2006 @ 02:03 PSTTD_ArchDatabaseReplytimestamp 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

Pages