#DateForumTypeThreadPost
7419 Jan 2014 @ 11:31 PSTDatabaseReplyInserting into a timestamp(6) columnCT DD(DT VARCHAR(26)) INS INTO DD VALUES('2014-01-01-11:10:12:123456') INS INTO DD VALUES('2014-01-01-11:10:12:000000') SEL CAST(SUBSTR(DT,1,19) ||'.'||SUBSTR(DT,21)&nb...
7319 Jan 2014 @ 10:17 PSTDatabaseTopicInserting into a timestamp(6) columnHi, I have flat file as input and i receive a timestamp column in format 2014-01-01-10:30:30:123456 I need to load this into target timestamp(6) column.What will be better conversion to load it.
7216 Jan 2014 @ 12:39 PSTDatabaseReplyAccount balance SQLAre there only two columns  in the table.What are the primary indexes.Please mention with PI so that it will be easy to code.
7116 Jan 2014 @ 12:31 PSTDatabaseReplyColumn Addition in TeradataGo for a backup option.
7016 Jan 2014 @ 12:23 PSTDatabaseReplyIssues with importing file with Date to TableProbably that might be the case.Date formats are different in source and target.Check with the delimiter too in the options tab.
6916 Jan 2014 @ 12:21 PSTAnalyticsReplyWhy UV in MLOAD?Thanks for the information Dieter.
6816 Jan 2014 @ 12:12 PSTAnalyticsReplyHelp with SQL to deal with overlapping date rangeHere ID's are different.How can you say that there are overlapping records.Could you please elaborate your requirement.
6709 Jan 2014 @ 12:24 PSTGeneralTopicTeradata Database softwareHi I need to install Teradata DB in my machine.When I search,there is VMware provided by TD.Is there any chance of getting database exe file as we get in oracle to install.Appreciate your repsonse.
6626 Dec 2013 @ 11:36 PSTDatabaseReplyFetching the data for thelast quarter datesSuppose let's take 1st quarter Jan-March.If my job runs in March.I need to pick the data from Oct1st to Dec31st.
6526 Dec 2013 @ 11:33 PSTDatabaseTopicInserting to a table incrementallyHi    What's the best approach to load the target table from the source incrementally.Let's say we have 1 million rows.I need to load the table for every 1 lakh.
6426 Dec 2013 @ 10:24 PSTDatabaseTopicFetching the data for thelast quarter datesHi I am using TD13 version.I have a query which runs for on  particular dates.Whenever the query runs it has to pick up the last quarter dates.   How to extract last quarter dates in B...
6317 Dec 2013 @ 04:24 PSTDatabaseReplyError in update statementStill it gives same error.. I have written case statement in SELECT condition itself.It got solved . But Is there any other way of writing the case stmt in set?
6217 Dec 2013 @ 04:15 PSTDatabaseTopicError in update statementUPDATE CUST_T FROM (SELECT A.CUST_ID,A.CUST_DT FROM CUST_T B INNER JOIN CUST__HIER A ON B.LAST_CUST_ID = A.CUST_ID)  UPD1 SET CASE WHEN IMMED_CUST_DT = '9999-12-31' THEN ...
6110 Dec 2013 @ 05:20 PSTDatabaseTopicRewriting the Self joinMERGE_ID is the primary index in  CUST_HIST SELECT * FROM (SEL A.MERGE_ID,A.REM_ID, A.EFF_DT, A.FIRST_MERGE_DT , A.CURR_CUST_MERGE_DT FROM CUST_HIST A INNER JOIN CUST_HIST B ON A.REM_...
6006 Dec 2013 @ 12:36 PSTDatabaseReplyStroed Procedure:Executing succesfully without errors while calling but the output is not being affectedYes.It worked.Thanks Dieter.But one doubt is Why it does not work for dbc.tablesize?
5905 Dec 2013 @ 11:31 PSTDatabaseTopicStroed Procedure:Executing succesfully without errors while calling but the output is not being affectedHi,  I have a stored procedure to drop the join indexes when databasename and indexname are passed as parameters. REPLACE  PROCEDURE db1.DROP_JI( IN databasename VARCHAR(130), IN jiname...
5805 Dec 2013 @ 02:47 PSTDatabaseReplyrecursive tableThis is the output of my recursive query.My strong point is Is it necessary to give any control like LEVL<10 like that or Will it stop based on the data.Please give me clarity. MERGE_ID ...
5705 Dec 2013 @ 12:53 PSTDatabaseTopicDistinct LogicI have a table like ct table1(name1 varchar(10),name2 varchar(10)) ins into table1 values('ABC','XYZ') ins into table1 values('ABC','ABC') ins into table1 valu...
5604 Dec 2013 @ 11:50 PSTDatabaseTopicrecursive tableHi,  I have the below logic.My doubt is Should I have the control in the second part of the UNION ALL statement to end the recursive logic or automatically it gets stopped once there is no c...
5503 Dec 2013 @ 02:06 PSTDatabaseReplySplit the dates bi-weeklyFor eg:If I want to run my job on Jan14th 2013 then i should process the data from 31-Dec-2012 to jan-13-2013.
5403 Dec 2013 @ 02:04 PSTDatabaseReplySplit the dates bi-weeklyHi Dieter    I am maintaining a process table with start date and end date.I need to run a job on Monday's only that too bi weekly.So that if i give the dates as sample Jan-1-2013 t...
5328 Nov 2013 @ 10:34 PSTDatabaseReplySplit the dates bi-weeklySEL B.STARTDATE,COALESCE(MAX(STARTDATE) OVER( PARTITION BY 3 ORDER BY STARTDATE ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING)-1,STARTDATE+13) AS DW_EXPR_DT FROM (SEL A.DD as STARTDATE, RANK() OVER(...
5228 Nov 2013 @ 10:04 PSTDatabaseReplySplit the dates bi-weeklyI have written like this.I feel this is complex. SEL B.STARTDATE,COALESCE(MAX(STARTDATE) OVER( PARTITION BY 3 ORDER BY STARTDATE ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING)-1,CAST('9999-12-31' AS ...
5128 Nov 2013 @ 09:56 PSTDatabaseTopicSplit the dates bi-weeklyI want to run my job bi-weekly.No date should not miss.I can take the nearest Monday. I am going to run alternate Mondays(bi-weekly).The process dates should be split like below. Eg:Suppose I t...
5028 Nov 2013 @ 03:29 PSTDatabaseReplyRe-writing a query interms of performanceFor CUST_T Date Time Unique Values Column Names 13/11/24 1:57:25 1,090 FIRST_DT 13/11/24 1:58:15 163,402,379 VISITOR_ID 13/11/24 1:58:39 4,192,811 CUST_ID 13/11/24 1:58:52 4 DOMN_ID 13/11/2...

Pages