#DateForumTypeThreadPost
1307 Jun 2007 @ 11:39 PDTConnectivityReplyRelated to Data Extraction.....HiI believe (I can't nconnect to a Teradata Db yet!) you can do it using Teradata SQL Assistant...In the menu Tools=>Option You can select "Write all export answer to a single file", and choose whi...
1230 May 2007 @ 10:17 PDTUDAReplyError T3932Thanks joedisilva.Your first suggestion has worked well.I have spoken with the DS user about your's last two suggestions, but it has not know to say me nothing about the first. About the last i tri...
1130 May 2007 @ 07:06 PDTUDATopicError T3932Hello.I have a store ptocedure that works well when i launch it from teradata.When i launch it from Data Stage returns this SQLCODE = T3932.The code of Store Procedure is :REPLACE PROCEDURE DOL.LOA...
1021 May 2007 @ 12:11 PDTUDAReplyPerformance Queries...Thanks a lot....I'm looking for around, following your useful suggestions.I continue my test and I tell you.Thanks again ...Massimiliao
918 May 2007 @ 01:32 PDTUDAReplyPerformance Queries...I.At the first i want to describe you my db characteristics.The DB is a snowflake schema DataMart. The dimension table have a low number of rows (2 to 200,000) and the fact table have a high numebe...
818 May 2007 @ 07:33 PDTUDAReplyPerformance Queries...Thanks very much...I'm following your suggestions...and I hope to answer you as soon as possible... :-)
717 May 2007 @ 12:43 PDTUDATopicPerformance Queries...Hello...The same query running on test Db go faster (difference is about 20 second )than prod DB.On all the environments, there're the same statistics....and the same data.These are the system char...
602 May 2007 @ 06:48 PDTDatabaseReplyQuery Formating in TeraData??>if you want the count to be taken as zero even when bus_hol is null then you >will have to use an ELSE 0 >clause instead of the last WHEN - THEN clause in the above queryOpss...that's right !! I'v...
502 May 2007 @ 04:19 PDTDatabaseReplyQuery Formating in TeraData??hello...you can try thisselectstart_date,end_date,(CASE WHEN bus_hol BETWEEN start_date AND end_date THEN 1 WHEN bus_hol NOT BETWEEN start_date AND end_date THEN 0END) ResultFROM Massimiliano
430 Apr 2007 @ 12:00 PDTToolsReplyGenerate DDLI found easily how do it...Menu Tools/Options/Export and then checking "Write all exported answer sets to a single file"...The last problem is some rows like "Request Text"and ---------------------...
330 Apr 2007 @ 11:11 PDTToolsReplyGenerate DDLI'm looking for that...!!The TBob's queries are very good. I've just used the DBC.TABLES.CHILDCOUNT (order by CHILDCOUNT DESC) for obtain the right order of creation...(not exact, but sure better !...
222 Jan 2007 @ 09:52 PSTDatabaseReplyAdding rights for use DDL in procedureThanks Dieter,You are right ! I solve my problem too !!!!
118 Jan 2007 @ 10:34 PSTDatabaseTopicAdding rights for use DDL in procedureHi all,first of all, thanks in advance... ;-)This is my problem: my user is granted for create,drop,select,insert and so on but when I would drop a existing table into a stored procedure I receive ...