All forum activity

#DateUserForumTypeThreadPost
139217 Jul 2006 @ 12:28 PDTshaik.feroz@aaa-calif.comToolsReplyTeradata load utility : Fast loadThe fastload only loads data into empty tables.when a job fails after a certain checkpoint and when the job is rerun, this does not mean that the table has data in it. The table is still in loading...
139117 Jul 2006 @ 12:26 PDTsourcyanideDatabaseReplysomebody help me its very urgent!!!!!!!well i tried the command net start but it says "'net' is not recognized as an internal or external command, operable program or batch file."
139017 Jul 2006 @ 12:24 PDTdnoethDatabaseReplyUnable to login througj BTEQHi Manik,MessagesChapter 17: Client UTYUTY-Series Messages"UTY6214 Reminder: A .Logtable statementmust be entered for a successful logon.Explanation: The .Logon and .Logtable statementsmust both be...
138917 Jul 2006 @ 12:22 PDTshaik.feroz@aaa-calif.comToolsReplyProblem in fast load (Urgent)try thisset record vartext "|" NOSTOP;sessions 2;.errlimit 50;.LOGON DemoTDAT/dbc,dbc;.set record textDATABASE ez;DROP table CartLine1;drop table CartLine1_ERR1;drop table CartLine1_ERR2;CREATE TAB...
138817 Jul 2006 @ 12:21 PDTdnoethDatabaseReplyCollect Stats on Global Temporary TableHi Manne,MessagesChapter 6: Teradata Database Messages5000-Series Messages"5343 This statement is not allowed when thetarget temporary table is already materialized.Explanation: The user cannot sub...
138717 Jul 2006 @ 11:36 PDTsunitha-2928ToolsTopicTeradata utilityI want to know about the layout parameters continueif and nullif with example.
138617 Jul 2006 @ 11:36 PDTsunitha-2928ToolsTopicTeradata utilityI want to know about the layout parameters continueif and nullif with example.
138517 Jul 2006 @ 11:32 PDTManikDatabaseReplyUnable to login througj BTEQHi Dennis and Daniel,Your replies have really helped me in logging into BTEQ AND FastLoad.I have modified the entry in my hosts file as follows127.0.0.1 localhost DemoTDAT DemoTDATcop1 ak a...
138417 Jul 2006 @ 11:30 PDTsunitha-2928ToolsTopicTeradata load utility : Fast loadConsider a fast load job that maintains checkpoint of 10,000.The fast load stops at 15,000th record.Now the fast load when restarted will restart from the checkpoint ie.10,001th record.Now from 10,...
138317 Jul 2006 @ 11:00 PDTilyasUDATopice-mail NotificationsI have created some BTEQ scripts. I want to know that if my scripts abort, is it possible for me to send some e-mails through some teradata utility as in oracle we do. Thanks
138217 Jul 2006 @ 09:57 PDTManoj_Kumar_ParmarDatabaseReplydifference between Hash join and Merge joinHi Barry, Since it is not the case of merge join and nested join, but how will it decides between product join and Hash Joini.e. as per my understanding I am finding that when, one table is very...
138117 Jul 2006 @ 09:07 PDTstami27-2406ConnectivityReplyEfficiency UDF scalar function vs.conventional SQLThanks A lot for the response.I had already altered the UDF in unprotected mode befor calling and benchmark it.But it is running under Teradata V2R5.1.I guess that the Teradata V2R6.1 come out with...
138017 Jul 2006 @ 08:19 PDTmanneDatabaseTopicCollect Stats on Global Temporary TableHi All,According to manuals, we can collect statistics on global Temporary table.I tried collecting statistics on an materialized/populated Gloabal Temporary table, But Teradata is throwing the fol...
137917 Jul 2006 @ 08:07 PDTabidmanzoorToolsTopicProblem in fast load (Urgent)Dear All,I am totally new in Teradata. I have problem in fastload.I have a data file containing following information100,59,PEARL HEART LOCKET,285,1,40.99,4/11/2005101,63,HARRY POTER,286,1,$40.99,4...
137817 Jul 2006 @ 07:32 PDTBarry-1604ConnectivityReplyEfficiency UDF scalar function vs.conventional SQLWhen you executed the UDF, were you in protected or unprotected mode? Protected mode is safer when you're first testing the UDF, but it is much slower. You have to ALTER the function to put it in...
137717 Jul 2006 @ 06:32 PDTdnoethDatabaseReplysomebody help me its very urgent!!!!!!!Submit "net start recond" from commmand line. Then check the windows eventlog (applications) for errormessages, if it's still not starting...Dieter
137617 Jul 2006 @ 06:15 PDTsourcyanideDatabaseReplysomebody help me its very urgent!!!!!!!i uninstalled and converted my drive to NTFS and then installed but it is still not running the teradata service.. and also cant seem to find StartTeradata.bat anywhere in the drive..
137517 Jul 2006 @ 02:45 PDTdnoethDatabaseReplysomebody help me its very urgent!!!!!!!You probably talk about the V2R5 demo version. IIRC there's a help file which talks about installing it on FAT32, you have to run a script afterwards. If you converted FAT32 to NTFS already then tr...
137417 Jul 2006 @ 01:32 PDTNitsDatabaseReplyhow to create function with parametersBarry,Thanks A lot I would give try to it and come back to you if have any questions.RegardsNits
137316 Jul 2006 @ 03:49 PDTsourcyanideDatabaseReplysomebody help me its very urgent!!!!!!!well i discovered i was installing on fat32 drive... i converted my drive to ntfs.. n then installed teradatanow its saying when i type pdestart on command prompt that "Cannot locate node global fi...
137216 Jul 2006 @ 03:31 PDTsunitha-2928DatabaseTopicTeradata specific processesWhat are the teradata's specific processes that can be seen from unix.
137116 Jul 2006 @ 03:29 PDTsunitha-2928DatabaseTopicteradata and oracle architectureWhat is the difference between teradata's shared nothing architecture and oracle's distributed architecture.
137015 Jul 2006 @ 05:00 PDTsourcyanideDatabaseTopicsomebody help me its very urgent!!!!!!!i m having trouble in connecting to teradata...the service is down/stopped.. and when i type pdestate in command prompt i get the error "'pdestate' is not recognized as an internal or external comm...
136914 Jul 2006 @ 06:55 PDTWomperConnectivityReplyEfficiency UDF scalar function vs.conventional SQLI had a similar problem in testing for a numeric value, and couldn't get any performance out of any procedural udf style function.This was most efficient/clearest thing i could come up with:Ok, so ...
136814 Jul 2006 @ 03:49 PDTcholletiTrainingTopicNeed teradata Basic Fundomental notes or pdfhi guys can any body help me to find out teradata fundomental tutorials...regardscholleti

Pages