#DateForumTypeThreadPost
1223 Aug 2006 @ 01:08 PDTDatabaseReplyHow do I make an exact copy of a current tableThe exact syntax is as below:create table product_1 as product with data;
1123 Aug 2006 @ 12:20 PDTDatabaseReplyHow do I make an exact copy of a current tableSorryrewritting the syntaxCreate table a as old_table_namesushant
1023 Aug 2006 @ 12:19 PDTDatabaseReplyHow do I make an exact copy of a current tableYou can also try out this Create table a as ;Which will be the exact replica of your old table.
921 Aug 2006 @ 05:06 PDTDatabaseReplyTeradata Parallel Transporter TPT APIHi Let me know this is th eone you want fot your postings on forum===================================================================PCNVFESP utility converts FastExport scripts into TWB jobscripts...
821 Aug 2006 @ 04:05 PDTDatabaseReplyHow to retrieve Metadata info using TPT API?I do not know if you are really asking about the below information1-Get list of all the databases from a Teradata serverSelect databaseName from dbc.databases where dbkind='D'2-Get list of all the ...
721 Aug 2006 @ 04:04 PDTDatabaseReplyHow to retrieve Metadata info using TPT API?1-Get list of all the databases from a Teradata serverSelect databaseName from dbc.databases where dbkind='D'2-Get list of all the tables, views from a Teradata DBSelect tablename from dbc.tables w...
629 Mar 2006 @ 06:19 PSTToolsReplyCode = 2644 No more room in databasedrop unwanted tables from the database .
512 Mar 2006 @ 11:23 PSTDatabaseReplyTable sizing in bytesFormula(BlockSize -38_/RowSize = RowsPerBloclRowCount /RowsPerBlock = BolcksNumAmps *1024 = Header(Blocks * BlockSize )+ Header = Nofallback(Blocks * BlockSize )*2 + Header = fallbackParameters38 =...
410 Mar 2006 @ 07:15 PSTDatabaseTopicAMP 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 ...
308 Mar 2006 @ 03:20 PSTUDAReplyData 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...
223 Feb 2006 @ 11:47 PSTDatabaseReplyWhy the follwing query is getting lockedSee every time this query is only getting locked since during the single user operation also here if i want to get rid from this locking issue what step should i perform
121 Feb 2006 @ 11:59 PSTDatabaseTopicWhy the follwing query is getting lockedselect this.Job_Id as Job_Id0_, this.Label as Label0_, this.Description as Descript3_0_, this.User_Name as User_Name0_, this.Active_Ind as Active_Ind0_, this.Job_Event_Key as Job_Even6_0_, this.Gro...