#DateForumTypeThreadPost
2504 Aug 2016 @ 11:13 PDTDatabaseReplyComparing current column with next column and generating values dynamicallyHi All, Any input on this. Is there any way to do it in sql. Please help to solve this. Thanks in advance .   Thanks
2402 Aug 2016 @ 01:02 PDTDatabaseTopicComparing current column with next column and generating values dynamically --Source: =============== id|MainVal|st_tm|end_tm|subval1|st_tm|end_tm|subval2|st_tm|End_tm|subval3|st_tm|end_tm 01|xxx    |07:30|16:00 |aaa    |12:00|12:30 |bbb&...
2327 Jul 2016 @ 02:31 PDTDatabaseReplyNeed to get View Column derivation info from teradataHi Saeed, Thanks for your info,   i want know from which table Cal_val is coming. i dont want to use help or show view statement. Is there any way??   Thanks,  
2227 Jul 2016 @ 01:26 PDTDatabaseTopicNeed to get View Column derivation info from teradataHi All, I want to get all view columns derviation/definition information. Is there any way to get them. eg: my table name is - DB.ORG_Table which has 3 columns namely col1,col2,col3 i have cr...
2118 Jul 2016 @ 02:39 PDTGeneralTopicUse of TABLE Keyword select statement select subq.sub_col1,subq.sub_col2,c.c2,c.c3.c.c4 select a.col1 sub_col1,b.col2 sub_col2,b.col3 sub_col3 Schemaname.Tab1 a, (select col1,col2 col3 from Schemaname.Tab2) b on a.col1=b.col1) as ...
2008 Mar 2016 @ 12:58 PSTDatabaseTopicRecords moving to Error2 table in MloadHi All, I am having issue in mload process (loading thru datastage job). some of the records are moving to Error2 table with RDBMS Code 2754. But target table doesn't have these records...
1916 Oct 2015 @ 12:54 PDTDatabaseReplyHow to get previous row valuesHi Dieter, Thanks a lot. yes, i am using TD14.10. It works perfectly.
1815 Oct 2015 @ 12:36 PDTDatabaseReplyHow to get previous row valuesHi, Sorry, placed wrong SQL, here is the sql select id,name,case when place is null then coalesce(min(place) over (partition by name rows between 2 preceding and 1 preceding),null) Else place e...
1715 Oct 2015 @ 12:31 PDTDatabaseTopicHow to get previous row valuesHi All, i need to assign previous row value if current row has null. i have seen posts for this. But since thosed max/min the value is getting changed.  when i use the sql i am not getting t...
1618 Sep 2015 @ 04:17 PDTDatabaseReplyRecords are getting skipped in MloadHi All, Due to some control charaters in source data, records were skipped in teradata acquisition phase. I have handled(removed control characters) it in datastage. Now all records got inser...
1517 Sep 2015 @ 10:59 PDTDatabaseReplyRecords are getting skipped in MloadHi Sriraman, The issue with Teradata mload. Not with datastage. Xml file successfully parsed and sent to teradata connector. While loading its getting rejected (in acquisition phase). design: Se...
1414 Sep 2015 @ 02:45 PDTDatabaseReplyRecords are getting skipped in MloadThanks for your mani. The data met all table constraints. All data read from XML file and passed to teradata connector ( Which does the MLOAD). While loading to table some records are being reje...
1311 Sep 2015 @ 07:36 PDTDatabaseTopicRecords are getting skipped in MloadHi All, I am loading XML data into Terdata table thru datastage jobs. in datastage, using mload utility. but some of the records are getting skipped. even these records are not going to Error1 o...
1206 Aug 2015 @ 02:19 PDTDatabaseTopicUnable release mload lock in teradata 14.10 Rlease MLOAD #Tablename#; Rlease MLOAD #Tablename# in apply; Hi All, Teradata table has been loacked by mload process. While trying to release mload it says "RDBMS code 2572: Mload table ...
1130 Jun 2015 @ 03:33 PDTDatabaseReplyHow to use dervied table in another derived table using with cluase in SQL?Hi Yuva, Thanks for your reply. The derived table tmp has a big query with multiple joins and used in many places. if i repalce tmp table by sub query, it will be very big. I can achieve t...
1030 Jun 2015 @ 02:30 PDTDatabaseTopicHow to use dervied table in another derived table using with cluase in SQL? TD: with tmp as (select 1 as a,2 as b), tmp2 as (Select * from tmp) select * from tmp2; Output: select failed, object tmp doesn't exist. Db2: with tmp as (select 1 as a,2 as b fro...
929 Jun 2015 @ 02:08 PDTDatabaseReplyNeed clarification in date type conversion create volatile table tmp(Dt  varchar(20)) on commit preserve rows;. insert into tmp('15/06/03'); select '2015/06/03' (date) as str_dt,date as curr_date, dt (date),dt f...
828 Jun 2015 @ 11:02 PDTDatabaseTopicNeed clarification in date type conversion create volatile table tmp(Dt  date) on commit preserve rows; insert into tmp('2015-06-22'); select dt from tmp; dt: 2015-06-22 ============================= select date &...
723 Jun 2015 @ 05:02 PDTGeneralReplyHow to add time with hour in TD 14.10?Thanks for the explaination.... But why current_time is giving different output. CURRENT_TIME: :05:12:28 current_time-time '00:00:00' hour to second : 04:12:28 when we use interval it w...
623 Jun 2015 @ 02:53 PDTGeneralReplyHow to add time with hour in TD 14.10?Hi, As per my understanding, Local time --> local system time(PC/Lap/cloud) Server time --> server time where the teradata is installed. But when select current_time --> ...
523 Jun 2015 @ 02:16 PDTGeneralReplyHow to add time with hour in TD 14.10? select cast(current_date as timestamp(6))+(current_time - time '00:00:00' hour to second) ts ,   current_time at local as local_time,current_time ;   ts  ...
422 Jun 2015 @ 10:32 PDTGeneralTopicHow to add time with hour in TD 14.10? select cast(current_date as timestamp(6))+(current_time - time '00:00:00' hour to second) as ts,current_time; Output: ts          &nb...
326 Mar 2015 @ 11:06 PDTGeneralReplyRDBMS Code 25000 - error occurred during data acquisitionHi, no, i am loading into empty staging table. From staging table, load into target table using insert/select.   Thanks,
226 Mar 2015 @ 10:54 PDTGeneralReplyRDBMS Code 25000 - error occurred during data acquisitionHi experts, can anyone please give some advise for the above error??
123 Mar 2015 @ 11:19 PDTGeneralTopicRDBMS Code 25000 - error occurred during data acquisitionHi All, I am new to Teradata. I am using mload to load data to target table. When i am loading dat i got RDBSM code 25000 error occurred during data acquisition. I dropped error/work/log tab...