All forum activity

#DateUserForumTypeThreadPost
5819205 Jul 2016 @ 07:48 PDThagrdanDatabaseReplyDatabase per object type -- Best practice or over engineered?I can tell you another downside.  A mistake was made in database creation whereas not enough space was allocated for our VIEWS database, resulting in our view creation script failing.  Th...
5819105 Jul 2016 @ 07:05 PDTnealvennaDatabaseTopicregexp_similar '^.$' issues Hi For data scrubbing I have lot of hard coded values in my code. I am trying to put those values in a table. One of the condition for this scrubbing is to find length of character and code ...
5819005 Jul 2016 @ 06:50 PDTtomnolanConnectivityReplyJDBC Fastload Error TablesGenerally speaking, there is no need for the JDBC FastLoad error tables to persist. The FastLoad error information is provided to your application as an exception chain.   Please remember th...
5818905 Jul 2016 @ 06:24 PDTDiraDatabaseTopicLast access timestamp is not getting updated in Dbc.Indices HI Team, Last access timestamp is not getting updated in Dbc.Indices though objectusage is set to T as shown below and we are on 14.10.05.07. Please help me on this... ...
5818805 Jul 2016 @ 05:29 PDTkartajGeneralReplyUpdate statment is getting failedThank you Dieter...:)
5818705 Jul 2016 @ 01:22 PDTlokmacDatabaseReplyDay Of Week or Week-Ending Function? SELECT TD_Day_of_Week(Date_Column) FROM Table1; I think many people have overlooked Ashok's excellent suggestion above, so to reiterate, you can use the Day_of_Week function bundled with Ter...
5818605 Jul 2016 @ 12:23 PDTkvzToolsReply<Internal Session> blocking users and causing deadlock We are getting blockings even in online backup. Blocking gets clear once the backup of that DB get completed. Locks will be applied on DB level or Table level during online backups? what...
5818505 Jul 2016 @ 12:17 PDTkvzDatabaseReplyOnline backup performance We are getting blockings even in online backup. Blocking gets clear once the backup of that DB get completed. Locks will be applied on DB level or Table level during online backups? what...
5818405 Jul 2016 @ 12:14 PDTkvzToolsReplyonline archive feature in Teradata 13We are getting blockings even in online backup. Blocking gets clear once the backup of that DB get completed. Locks will be applied on DB level or Table level during online backups? what is ...
5818304 Jul 2016 @ 11:51 PDTM.Saeed KhurramGeneralReplyUpdate statment is getting failedThank you Dieter. It is an addition to my knowledge as well :)
5818204 Jul 2016 @ 06:41 PDTgerald.watersDatabaseReplyDatabase per object type -- Best practice or over engineered?I'd like to reiterate a part of your question: Is "all views in a views DB, all procs in a procs DB, all data in a data DB, and DB names follow no pattern" really a Teradata best pra...
5818104 Jul 2016 @ 12:43 PDTCvinodhConnectivityReplyJDBC Fastload Error Tablesboth the fastload error tables are getting dropped as soon the JDBC fastload job completes. This happenes even when the error tables have error record entry. Is there a way with JDBC fastload to pe...
5818004 Jul 2016 @ 11:56 PDTdnoethGeneralReplyUpdate statment is getting failedSAMPLE is not allowed in subqueries (probably because this might be a correlated subquery), but in Derived Tables: UPDATE TABLE_NM SET EFF_STRT_DT = '2016-07-04' WHERE EFF_END_DT = '...
5817904 Jul 2016 @ 11:15 PDTkartajGeneralReplyUpdate statment is getting failedThanks for your revert Khurram, can you please suggest ,if there is any alternate way to write the update query (which reaches the above recuriment)
5817804 Jul 2016 @ 11:00 PDTM.Saeed KhurramGeneralReplyUpdate statment is getting failedHi,   It is very clear message, SAMPLE is not allowed in subquries. remove this sample caluse: UPDATE TABLE_NM SET EFF_STRT_DT = '2016-07-04' WHERE EFF_END_DT = '9999-12-31...
5817704 Jul 2016 @ 10:45 PDTkartajGeneralTopicUpdate statment is getting failedHi team, I was trying to update sample 100  active records with a specific date('2016-07-04'), But my query is getting failed...(i have tried using with qualify rank, even it was not ...
5817604 Jul 2016 @ 09:58 PDTpietro.nardellaDatabaseTopicTACTICAL QUERIES ON WINDOWS FUNCTIONDear ATRs, I have a "simple" view V made by a "driving" table T (250 Mln rows) and a "left table" L (220 Mln rows) with a window fu...
5817504 Jul 2016 @ 09:03 PDTdev1987DatabaseTopicNeed help on writing teradata stored procedureHello All, I have one simple requirement on writing stored procedure.Requirement is as follows.   create stored procedure xxxx(In load_type varchar(20),load_date date)   ...
5817403 Jul 2016 @ 11:05 PDTNoa_ShahakDatabaseReplyManually generate create tableHi Dieter, Thanks for your quick replay :) I'll explain my situation. We're using Teradata 14.10 and currently changing some prod tables schema to columnar. In order not to harm o...
5817303 Jul 2016 @ 08:47 PDTdasthuDatabaseReplyHow to call unix commands with in the BTEQ script?how to connect teradata to informatica? and unix to teradata?
5817203 Jul 2016 @ 08:26 PDTdnoethDatabaseReplyManually generate create tableDefine "manually generate". There's CREATE TABLE newtable AS existingtable..., which allows defining indexes. Or SHOW TABLE and then edit.
5817103 Jul 2016 @ 06:16 PDTNoa_ShahakDatabaseTopicManually generate create table Hi All,   I'm looking for a way to manually generate create table (as another table) script.  The output should be script because I need to edit it.   My f...
5817003 Jul 2016 @ 05:29 PDTzszmigieroAsterReplyINSERT undocumented syntaxMy question was not described clearly. Aster SQL mentions syntax INSERT INTO table query; my question is related to syntax: INSERT INTO table (query); Do exist any other undocumented syntaxes?...
5816903 Jul 2016 @ 02:20 PDTSyedShahDatabaseTopicCalling a stored procedure from Teradata Rest APIHi All, I am trying to call a stored procedure from Teradata Rest API and i am unable to do so. When i call a stored procedure like a normal SQL, it executes the procedure but does not displa...
5816803 Jul 2016 @ 12:49 PDTzarinaGeneralTopiccumulative sum and moving average Hi All   I am new to teradata and looking for the teradata query for the below situation query to retireve cumulative amount and moving average salary for each employee in the reporting per...

Pages