#DateForumTypeThreadPost
1309 Feb 2009 @ 11:33 PSTDatabaseTopicRedistribution and duplication of records across all Ampshello all,I am running an update statement which tries to update A.BOSS_Appln_Id to B.BOSS_Appln_Id. The statement is as below.UPDATE EDWST1E_DATA_SRVC_ORDER.A FROM (SELECT BOSS_Appln_Id FROM ...
1229 Jan 2009 @ 07:17 PSTDatabaseReplyMLOADHi,The answers to your questions1. Create a table - Yes, Mload does support Create table statement to create new tables.2. Load the table from a file - Yes3. From that table have to insert to anoth...
1120 Jan 2009 @ 08:41 PSTDatabaseTopicANSI versus Teradata Mode TransactionsHi,I have read that in ANSI mode a DDL statement should be followed immediately with a Commit statement. But in Teradata mode all the statements are implicitly commited or within a BT/ET.I am facin...
1020 Jan 2009 @ 12:47 PSTAnalyticsReplyCode help needed to summarise tableThe answer to the query selectAccount_Num, Call_Timestamp, call_idfrom EDWST1E_WORK_IN.call_summarywith min( Call_Timestamp) by call_id (Title 'Minimum call Duration')with max( Call_Timestamp) by ...
920 Jan 2009 @ 12:43 PSTAnalyticsReplyCode help needed to summarise tableLike joe and Tim said we definitely need a Flag for Start and end of the calls. If we have one like Call_id then below query can be used to acheive the same.selectAccount_Num, Call_Timestamp, call_...
830 Jul 2008 @ 10:54 PDTDatabaseReplyextracting table names given a Column name from different databaseswe can remove the databasename filter and keep only the columnname filter.likeSELECT TABLENAME,DATABASENAME FROM DBC.COLUMNS DBC WHERE DBC.COLUMNname = 'ABC' ;it should give all the databases on a ...
716 Jul 2008 @ 09:40 PDTToolsReplyERROR Loading Pipe delimited file thorugh MLOADThanks a lot Jeff. I would try as suggested.The userId and pwd mentioned in the script were just Dummy..Cheers,Saur
615 Jul 2008 @ 09:18 PDTToolsTopicERROR Loading Pipe delimited file thorugh MLOADHi All,I am struggling to load a simple pipe | delimited file into a table. The table is loaded but the UPI is populated with NULL or a different value.Table Structure ---------------CREATE SET TAB...
503 Jun 2008 @ 08:33 PDTUDAReplyMload Login ErrorThe problem is solved by converting windows file into unix format..dos2unix filename;this removes unwanted characters.
403 Jun 2008 @ 05:55 PDTUDAReplySql hierarchy treehi maverick, I have tried creating a tree struture of employee - manager relationship and tried wrote a Recursive SQL to get the requrird outpur let me know if it helps.create volatile table t1 /*...
326 May 2008 @ 08:59 PDTUDAReplyMload Login ErrorThanks Fred,my password contains only characters and numbers but i tried making changes to .logon as suggested..logon tdpid/userid,"pwd";but still the same error.Regards,Saurabh
226 May 2008 @ 04:48 PDTUDATopicMload Login ErrorHi,I am trying to write a simple mload script to load few records into an empty table. Below is the script that i have written.logtable abclog;.Logon tdpid/userid,pwd;database dev_work;Create table...
122 Sep 2007 @ 01:48 PDTUDAReplyData SkewYesdropping the table and recreating with a new PI will result in automatic reallocation of the data across AMPs.cheers,

Pages