All forum activity

#DateUserForumTypeThreadPost
166724 Aug 2006 @ 02:09 PDTvarun-2294TrainingTopichas anyone given teradata cert in second shot scheme...hi has anyone given the teradata cert in second shot scheme ... please let me know the procedure...
166624 Aug 2006 @ 02:03 PDTshuklapUDATopicBest case practise docsHi,I am in the process of creating some internal standards for views on Teradata. Is there any document that highlights best case practices or discusses scenarios/past implementation white paper th...
166523 Aug 2006 @ 11:52 PDTsfyeu1AnalyticsReplyAny function like Oracle "months_between"?e.g. start date: 2005-08-01end date: 2006-07-31result: 12 (months)But use your method to calculate the no of months, it would be -1. I expected the result which is 12.
166423 Aug 2006 @ 08:21 PDTJohn MacAnalyticsReplyAny function like Oracle "months_between"?If the dates of tenure are going to span one or more year-ends, then something like this might be quite groovy...select a.month_of_calendar - b.month_of_calendarfrom sys_calendar.calendar a cross...
166323 Aug 2006 @ 03:16 PDTRGlassAnalyticsReplyAny function like Oracle "months_between"? extract(month from end_date) - extract(month from start_date);
166223 Aug 2006 @ 05:48 PDTsfyeu1AnalyticsTopicAny function like Oracle "months_between"?I need to calculate the tenure between two date fields. The result should be number of months.e.g. case1 Start date: 2006-06-01End date: 2006-08-01Result: 2e.g. case2Start date: 2006-07-01End date:...
166123 Aug 2006 @ 01:08 PDTGreatSushantDatabaseReplyHow do I make an exact copy of a current tableThe exact syntax is as below:create table product_1 as product with data;
166023 Aug 2006 @ 12:20 PDTGreatSushantDatabaseReplyHow do I make an exact copy of a current tableSorryrewritting the syntaxCreate table a as old_table_namesushant
165923 Aug 2006 @ 12:19 PDTGreatSushantDatabaseReplyHow 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.
165822 Aug 2006 @ 06:55 PDTHari SrinivasanDatabaseTopicCONNECT BY.. PRIOR Equivalent in Teradata?Hello Gurus,Is there an equivalent statement for CONNECT BY..PRIOR in Oracle. I'm trying to simulate a hierarchy in Teradata SQL and i'm using the WITH RECURSIVE query. It is not solving my require...
165722 Aug 2006 @ 06:53 PDTHari SrinivasanUDATopicHierarchy SQLHello Gurus,Is there an equivalent statement for CONNECT BY..PRIOR in Oracle. I'm trying to simulate a hierarchy in Teradata SQL and i'm using the WITH RECURSIVE query. It is not solving my require...
165622 Aug 2006 @ 05:22 PDTtrying_to_learnDatabaseTopicOracle "REPLACE" function equivalant function in TeradataCan any one help me (if possible, with the syntax and an example) to find a equivalent function in Teradata that works like 'REPLACE' function in Oracle?
165522 Aug 2006 @ 02:24 PDTdnoethDatabaseReplyHow do I make an exact copy of a current tableDefinition plus data?create table newtab as oldtab with data;Or just the definition?...with no data;check the manuals for details...Dieter
165422 Aug 2006 @ 11:45 PDTMattW At ATTDatabaseTopicHow do I make an exact copy of a current tableAny Ideas?Can I just Create Table 1 as(Select * from Table 2)
165322 Aug 2006 @ 11:01 PDTsparanToolsReplyDate Format Problemselect cast( (date (format 'YY-MM-DD')) as char(10)) ;
165222 Aug 2006 @ 10:04 PDTSamantha-3071ToolsReplyProblem using Teradata import - making me crazy!!OMG Thank you!That worked great!You don't know how much time you have just saved me!Thanks againSamantha
165122 Aug 2006 @ 04:49 PDTJohn MacConnectivityReplyCreating New User Defined FunctionsIf, instead of clicking on 'Discussion forums', you move down a bit and right a bit on the Teradata.Com page, you'll see a link to 'Drivers and UDFs'.You can pinch a pre-written UDF from there and ...
165022 Aug 2006 @ 01:16 PDTJohn MacToolsReplyDate Format ProblemHow about this, which WILL work with ODBC...(courtesy of my mate Andy)..select cast(cast(date as date format 'YY-MM-DD') as char(8)) ;
164922 Aug 2006 @ 01:05 PDTJohn MacToolsReplyDate Format ProblemAre you using SQL Assistant ? ODBC doesn't cope with Formatting.
164821 Aug 2006 @ 08:25 PDTTimMannsToolsReplyDate Format ProblemI'm fairly new to Teradata (background in SPSS and data mining). This CAST statement has worked well for me;CAST(my_dt AS DATE FORMAT 'YYYY-MM-DD') AS my_new_dtI also used this to get date differe...
164721 Aug 2006 @ 07:04 PDTspsinghToolsTopicDate Format ProblemHi There,I am trying to format my SQL query but Date format is not working.I want to see the Date format like YY-MM-DDHere is my query. Please helpsel EDATE( FORMAT 'YY-MM-DD') from EMP
164621 Aug 2006 @ 04:13 PDTPat.BuckleyDatabaseTopicHow long does reconfig typically take?Trying to install an instance of V2R6.1.1 on Windows 2003, and PUT seems to be stuck on reconfig, pdestate shows the following:PDE state is RUN/STARTED.DBS state is 6: RECONFIG is runningI've let t...
164521 Aug 2006 @ 11:56 PDTjackdelongUDATopicback and restoreI have a table that is appox. 900gb but with fallback applied it is near 1.8tb. My question is that when I backup the table the data dictionary marks the table as fallback so when I try to restore...
164421 Aug 2006 @ 05:06 PDTGreatSushantDatabaseReplyTeradata 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...
164321 Aug 2006 @ 04:05 PDTGreatSushantDatabaseReplyHow 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 ...

Pages