All forum activity

#DateUserForumTypeThreadPost
169228 Aug 2006 @ 02:43 PDTvinod_sugurDatabaseReplyCONNECT BY.. PRIOR Equivalent in Teradata?Hi,I am sorry i could not test the below query as i don't have the V2R6 box avaliable in my environment.Create Table Test_Recursive(I Integer);INSERT INTO Test_RecursiveValues(1);INSERT INTO Test_R...
169127 Aug 2006 @ 03:18 PDTTagSoupToolsReplyProblem using Teradata import - making me crazy!!Hi Samantha,The sample information you have posted in this public forum for “ssn” seriously disturbs me.(try to unravel what the “ssn” acronym means)http://en.wikipedia.org/wiki/Social_secu...
169027 Aug 2006 @ 02:50 PDTsamit_9999UDAReplySplit a row into multiple rows based on a Date RangeThanks Once Again!Those sql's were damn good!
168927 Aug 2006 @ 02:41 PDTdnoethUDAReplySplit a row into multiple rows based on a Date RangeHi Sam,i can't tell you which is more efficient, you'll have to test it with your data.It probably depends on:number of rows in your calendar table to be cross joined vs.number of recursion levelsD...
168827 Aug 2006 @ 02:12 PDTsamit_9999UDAReplySplit a row into multiple rows based on a Date RangeThanks Dieter!!!Both the sql's work gr8.From the performance perspective which one is the better of the 2.Thanks,Sam
168727 Aug 2006 @ 08:50 PDTBBR2DatabaseReplyBteq Export LImitation???I think there is a file limitation of 2 GB.You cannot create a file greater that 2 GB.Vinay
168627 Aug 2006 @ 07:10 PDTdnoethUDAReplyproblem in mloadPossible reasons might be:- someone dropped the worktable - you specified the wrong name during a restart- a previous MLoad was cancelled without RELEASE MLOAD...From the messages manual:2583 %VSTR...
168527 Aug 2006 @ 07:03 PDTdnoethUDAReplySplit a row into multiple rows based on a Date RangeHi Sam,create table sam(Emp int, Start_date Date, End_date Date);insert into sam values(10, date '2006-01-01', date '2006-12-31');insert into sam values(20, date '2005-05-01', date '2005-12-31'); /...
168426 Aug 2006 @ 08:05 PDTleo.issacUDAReplyNeed to fire 1000 different SQL statements and verify results automaticallyAs suggested by Mr.Shastry, you can either use SQL assistant's export option or re-direct the out while running the BTEQ script.One other way is to use BTEQ's .Export command.You have several modes...
168326 Aug 2006 @ 07:59 PDTleo.issacUDAReplyproblem in mloadCan you try specifying worktables in your script and check if you get the same error message.I hope we can mentione worktable names explicitly in mload scripts.
168225 Aug 2006 @ 11:37 PDTteratarunUDATopicproblem in mloadwhen I trying to run my mload scrip in command prompt it shows me error like********2583 worktable missing for databse.tablename during mload*****
168125 Aug 2006 @ 08:42 PDTsamit_9999UDATopicSplit a row into multiple rows based on a Date RangeHi,I am selecting data from a table which has Start Date and End Date as followsEmp Start Date End Date10 01/01/2006 12/31/200620 05/01/2005 12/31/2005I want to results as followsEmp Months10 Ja...
168025 Aug 2006 @ 04:31 PDTshiv_vermaUDAReplyProblem in MloadWas this issue resolved? We are having exact same issue and unable to find the cause... Please provide input in case you had a resolution.. Thanks, Shiv
167925 Aug 2006 @ 02:58 PDTleo.issacDatabaseReplyBteq Export LImitation???There is an option called RetLimit in BTEQ. You can specify the number of records that bteq can export.The maximum can be 2,147,483,407 records. So if you are exporting beyond the maximum limit I h...
167825 Aug 2006 @ 02:39 PDTleo.issacToolsReplyDate Format Problemit worked for me in bteq and SQL assistant too. Can you try it this way.select date (format 'yy-mm-dd');select date (format 'yy-mm-dd'); *** Query completed. One row found. One column returned. **...
167725 Aug 2006 @ 02:35 PDTleo.issacToolsTopicTeradata Manager Monitor optionHi All,I tried to monitor my sessions using the teradata managers Monitor->Sessions option. A window popped up but it does not show me sessions information. Infact I could see the following error i...
167625 Aug 2006 @ 12:30 PDTCoca-Cola EnterprisesJobsTopicCoca-Cola Enterprises Has Openings for Senior Level Teradata ProsCoca-Cola Enterprises has 2 senior level Teradata positions available – Teradata Architect Lead and Senior Teradata Application DBA. The positions are based in Atlanta, Georgia and are full-time...
167525 Aug 2006 @ 06:35 PDTmagrawalDatabaseTopicWhere to locate TPT API?I have installed the TTU8.1 but couldn't locate the include/libs for TPT API.Any idea from where to get developer's c++ sdk for TPT API like header files, libraries?Thanks.Mataprasad
167425 Aug 2006 @ 04:26 PDTdnoethUDAReplyHierarchy SQLHi Hari,i don't know your data, but it looks like you want to calculate the Transitive Closure, i.e. all existing paths.For all rows it's probably:WITH RECURSIVE HARI_TMP(mgr,emp,LEVEL) AS(SELECT m...
167325 Aug 2006 @ 03:54 PDTshuklapUDATopicDynamic row level security implementation ...I have created a view common to department A and B,REPLACE VIEW DEPT_EMP select NAME, POST, ADDR1, DEPT CDfrom EMPLOYEE;NAME, POST, ADDR1, DEPT CDTEST1 ABC TEST ATEST1 ABC TEST B when the u...
167224 Aug 2006 @ 07:19 PDTtodorpConnectivityTopichow to link TD to SQL Server using OLE DB Provider?I am trying to link a SQL Server to TD using OLE DB Provider. The TD is the Datawarehouse, holds the source of truth and the SQL Server runs a small application. I downloaded and installed the late...
167124 Aug 2006 @ 05:08 PDTFredToolsReplyDate format conversionOne possibility would be CAST(:fld AS DATE FORMAT 'DD-MMM-YY') but whether or not that does what you want depends on Century Break setting (those pesky two-digit years!). And since Century Break is...
167024 Aug 2006 @ 02:33 PDTCaleksToolsTopicDate format conversionPls help: Does anyone know how to convert the following date format into YYYY-MM-DD?Eg.:I need to convert 01-OCT-06 into 2006-10-01.Im building an Insert statement on Mload script on Unix plataform.
166924 Aug 2006 @ 09:01 PDTHari SrinivasanUDAReplyHierarchy SQLHi Dieter,Thanks for your Reply.This is the recursive query i wrote DATABASE EDW;WITH RECURSIVE HARI_TMP(mgr,emp,LEVEL) AS(SELECT mgr,emp,0FROM EMPDATAWHERE JOB_TITLE='PRESIDENT'UNION ALL SELECT EM...
166824 Aug 2006 @ 02:58 PDTdnoethUDAReplyHierarchy SQLHi Hari,of course it's possible, you just have to code it the right way :-)Maybe show us what you wrote so far...Returning the hierarchy of Teradata databases & users as an example:WITH RECURSIVE p...

Pages