#DateForumTypeThreadPost
2413 Jul 2009 @ 10:59 PDTDatabaseTopicUsing Insert Mode in TeradataWhat is the difference between using 1) Insert into table1sel * from table2;Insert into table1 ;Instead of 2) Insert into table1sel * from table2;Insert into table1 ;Whether there will be a differe...
2313 Jul 2009 @ 07:14 PDTDatabaseReplyStrange Problemya its very strange ... I dont have rights to insert data in other production databases except the one I am using.My peers will definitely dont have access rights to delete data in production and m...
2213 Jul 2009 @ 07:01 PDTDatabaseReplyStrange ProblemHi Adeel,I am not using any temporary tables and the insert scripts are the actual production scripts.The difference is just that I am trying to insert data in a separate database in production for...
2113 Jul 2009 @ 06:53 PDTDatabaseTopicStrange ProblemHi All,I am facing a very strange issue wherein I am trying to load data into a specific database using some insert scripts.But the data is getting lost after few minutes.Could anyone please let me...
2009 Jul 2009 @ 01:53 PDTDatabaseReplyReplacing Macros ProblemHi Friends,Any body can help me on this ??Thanks a lot for your quick answers.
1908 Jul 2009 @ 12:22 PDTDatabaseTopicReplacing Macros ProblemHi,I am trying to replace or rather create a set of macros in my dev env but facing an error 3932:Only an ET or null statement is legal after DDL statement.For example :Replace macro mac_1( );Repla...
1803 Jul 2009 @ 05:32 PDTToolsReplyCreate Table Access in TeradataGot it Guys ...thanks Anyways :-)
1703 Jul 2009 @ 05:22 PDTToolsTopicCreate Table Access in TeradataCan anybody please tell me the syntax for granting Create Table access to any database ??Thanks !!!
1603 Jul 2009 @ 03:39 PDTToolsTopicUsing Parameter in BTEQHi All,I have a requirement in which I need to pass the same DATE parameter to a set of macros.I want to incorporate all the macros in one bteq script so that the user can just specify the paramete...
1502 Jul 2009 @ 06:49 PDTDatabaseReplyUrgent NeedThanks a million Adeel...U really are a supreme being of this forum :-) ....I dont know why it dint clicked my mind to remove Month_End :-( ...
1402 Jul 2009 @ 06:04 PDTDatabaseTopicUrgent NeedHi All,I have a requirement in which I am passing two parameters Month_Start and Month_End and I need to fetch the data for the previous month based on that.I have used Add_months function to get t...
1315 Jun 2009 @ 09:32 PDTDatabaseReplyUsing Dynamic Sql Stored ProcedureHi Adeel,thanks for your reply.But the simple query like below is also giving me the same error.COuld you be ablt to help ?Replace PROCEDURE DATABASENAME.Proc_Dynamic (IN X INTEGER, IN Y DATE, IN ...
1215 Jun 2009 @ 07:32 PDTDatabaseReplyUsing Dynamic Sql Stored ProcedureCan anybody please reply to this ?I need this info as early as possible..Thanks in Advance !!!
1112 Jun 2009 @ 07:11 PDTDatabaseReplyUsing Dynamic Sql Stored ProcedureJust correcting the SP :CREATE PROCEDURE Proc_Dynamic (IN X INTEGER,IN Y DATE,IN MYTABLE VARCHAR(30))BEGINCALL DBC.SysExecSQL('INSERT INTO Databasename'|| '.' || :MYTABLE ||'SELECT' ||A,B,C,SUM(D...
1012 Jun 2009 @ 07:00 PDTDatabaseTopicUsing Dynamic Sql Stored ProcedureHi ,I am trying to write a dynamic sql using Stored procedure wherein I am using the underlying table as one of the input parameters.Below is the SP which I am trying to create but I am facing Inva...
920 Oct 2008 @ 05:11 PDTAnalyticsReplyAbout PEHi,The ques asked is when we fire a query on hashamp()Say :sel hasham() + 1 :Does the above query returns the number of Amp's OR does it returns the number of Amp's + PE's?If it returns the number ...
817 Oct 2008 @ 03:17 PDTUDATopicMulti Currency Problem in Building DatawarehouseHow will you handle the multicurrency problem while gathering data from various countries' database to build a Datawarehouse and how to handel the schema changes over period of time?Quich responses...
716 Oct 2008 @ 07:28 PDTDatabaseReplySchema for Teradata DatawarehouseHi Guys,Any answers to my ques above?Thanks
616 Oct 2008 @ 06:06 PDTDatabaseReplyAMPs PEs and NODEs in a Teradata Datawarehouse.Thanks guys for your reply....but still I have got no info to get the number of PE's in a Datawarehouse?
516 Oct 2008 @ 05:59 PDTDatabaseReplyCompression In TeradataHi Dieter,That means compression information is stored in table header ?Could you please explain how the query I mentioned above will work in Teradata in little detail.Thanks!!!
415 Oct 2008 @ 07:24 PDTDatabaseReplyrowkeyCan anybody pls expalin what a rowkey actually is ?Is it the combination of Partition Id+Row Hash + Uniqueness Value or it is just the Row Hash value being given the same name.
315 Oct 2008 @ 07:15 PDTDatabaseTopicCompression In TeradataHow does Compression works in Teradata?Where in Teradata Compressed value information is stored and retrieved ?Say For example :If I have compressed a column value "Ansh" then how does teradata wil...
215 Oct 2008 @ 01:36 PDTDatabaseTopicSchema for Teradata DatawarehouseHi All,Could you tell me which schema does Teradata Follows ?Is there any way we can get this info by firing any query ?Regards,Ansh
115 Oct 2008 @ 01:31 PDTDatabaseTopicAMPs PEs and NODEs in a Teradata Datawarehouse.Hi Guys,Could anyone of you can tell me how to get the number of AMPs,PEs and NODEs in a Teradata Datawarehouse ?Regards,Ansh

Pages