#DateForumTypeThreadPost
5630 Aug 2016 @ 06:17 PDTViewpointReplyIs there a way to control RESPONDING STATE of large extracts using TASM Exceptions?OK Todd,  so we experience an issue with ETL sessions remaining in response for hours (and days), each of them with big spool ... Thanks for clarification, Pierre  
5530 Aug 2016 @ 05:21 PDTViewpointReplyIs there a way to control RESPONDING STATE of large extracts using TASM Exceptions?Hi all, i'm just looking for a clarification about the Spool displayed in Viewpoint portlet Query Monitor when a session is in a "response" state: Is that spool a Bynet owned spool,...
5404 Aug 2016 @ 06:17 PDTDatabaseReplyskew factorBTW, i just notice a case where a small table is displayed with a high skew by TD Administartor (15.00): Space by AMP gives 8 lines with almost the whole of 1.3 M lines on one AMP, although a que...
5304 Aug 2016 @ 06:03 PDTDatabaseReplyskew factorThis is because of the location of all NULLs on a same (and single) AMP, according to the hash process Pierre
5209 Feb 2016 @ 08:37 PSTDatabaseReplyCREATE SYSTEM TIME TABLE in errorHi Dieter, indeed ... waiting for TD15.10.  btw, is that "create system time table" accepted in an ANSI mode session only ? Thanks, Pierre
5109 Feb 2016 @ 06:06 PSTDatabaseTopicCREATE SYSTEM TIME TABLE in errorHi all, i try to create a SYSTEM_TIME table (ANSI) from a session in ANSI mode and in TERADATA mode as well (database V14.10, SQLA 14.10) in each case i get an error (3706 Syntax error: expected ...
5018 Jan 2016 @ 06:12 PSTDatabaseReplySQL problemHi Abhilash, please try something like that: UPDATE T from yourtable T , ( select RecoID, AudID Start_date, max(Start_Date) over(partition by RecoID, AudID order by Start_Date rows be...
4905 Nov 2015 @ 12:19 PSTDatabaseTopicNO USE OF PI IN VIEW WITH QUALIFY row_number()Hi all, A view on a big table (1,8 billions) joined to N smaller tables (500 M or less) doesn't use PI at all when QUALIFY row_number() is added at the end of the SQL: select cols from View w...
4821 Oct 2015 @ 05:58 PDTDatabaseReplyHow to check an invalid date in TeradataHi Sinara, an invalid date occurs when attempting to insert an erroneous date value (character chain or number) in a DATE DATATYPE column. You should consider the DATATYPE and the FORMAT. have ...
4721 Oct 2015 @ 01:37 PDTDatabaseTopicJOIN INDEX USAGEHi, User on site ask for locking a Join Index (single table T1)  in access in  a request for UPDATing T2 from SELECT from T2 JOIN base table T1 ... , does it make sense ? AFAIK a join I...
4616 Oct 2015 @ 12:53 PDTDatabaseReplyLOCK IN ACCESS SELECT timestamp effectivenessHi Dieter, Thank you for quick answer ! Pierre
4515 Oct 2015 @ 09:39 PDTDatabaseTopicLOCK IN ACCESS SELECT timestamp effectivenessHi, i'm in trouble when trying to distinguish transaction isolation and access on data with SELECT: what image of rows will be accessed ? A LOCK ROW IN ACCESS SELECT will ensure access on row...
4424 Sep 2015 @ 09:33 PDTDatabaseTopicTEMPORAL DATA & NONTEMPORAL a piece of the puzzleHi, I am trying to make a clear sight on the subject of NONTEMPORAL use: NONTEMPORAL is TRANSACTION related, and useful for operations on Transaction time axis only, i guess, not on Valid Time. ...
4320 Aug 2015 @ 02:53 PDTConnectivityReplyCalling a macro via JDBCyou are right, A new "connectivity" question about sending properly a "data parcel" with parameter values before an "exec macro" order via JDBC to ensure that the qu...
4214 Aug 2015 @ 12:57 PDTConnectivityReplyCalling a macro via JDBCThanks Tom, when looking for docs about cached plans i just found this page: http://www.info.teradata.com/HTMLPubs/DB_TTU_13_10/index.html#page/Database_Management/B035_1094_109A/ch17.19.35.html ...
4110 Aug 2015 @ 03:04 PDTConnectivityReplyCalling a macro via JDBCSo, when a parameterized macro is submitted many times from the same session (in a pool of sessions) and parameters are used to pass a date value always filtering on the same column , can we expect...
4031 Jul 2015 @ 04:51 PDTConnectivityReplyCalling a macro via JDBCAbout SQL PRPEPARE and MACRO: i had in mind that macros allow one parsing step only (with the first execution) , avoiding parsing at each execution of the request. I have no idea of what SQL PR...
3929 Jul 2015 @ 07:48 PDTGeneralReplyHow to update a datatype of a column in a table having huge dataThanks Dieter, you are right, an ultimate question (on this forum): is unuseful BIGINT a waste of space in spool too (8 bytes occupied instead of 4 for each value) ? Pierre
3829 Jul 2015 @ 06:37 PDTDatabaseReplyData Type Conversion BIGINT to INTEGERReplacing BIGINT with INTEGER in new tables: some issues in joins ? About changing datatype from now when creating new tables for an application existing column (ID_COL): i just wonder wether a...
3729 Jul 2015 @ 06:32 PDTGeneralReplyHow to update a datatype of a column in a table having huge dataSorry, i copy this question in DATABASE forum ! Pierre
3629 Jul 2015 @ 06:16 PDTGeneralReplyHow to update a datatype of a column in a table having huge dataHi Dieter, About changing datatype from now when creating new tables for an application existing column (ID_COL): i just wonder wether a use of INTEGER instead of BIGINT could impact join perform...
3531 Mar 2015 @ 07:48 PDTDatabaseReplyUsing Dynamic databasename and tablename in stored procedureHi, this is not an answer, just an additional question about the default type and format of COUNT(*) in a query (or stored procedure) when the output type/format is not specified: the default typ...
3427 Feb 2015 @ 07:05 PSTDatabaseReplyRuleType in tdwm.ruledefsHi, i have the same question, after some investigations in docs. Ruletypes are documented as follows: Rule Type INTEGER Rule ...
3305 Dec 2014 @ 12:57 PSTViewpointReplyAlerting criteria for sessions in response statusGary, good news, thanks, Pierre
3201 Dec 2014 @ 08:49 PSTViewpointTopicAlerting criteria for sessions in response statusHi, i try to determine a combination of criteria among those offered in Viewpoint portlet Teradata Sytems / Alerts / Sessions / Alert Rules, in lack of some 'response time' criterium avai...

Pages