#DateForumTypeThreadPost
242807 Dec 2013 @ 02:03 PSTDatabaseReplyTD Lock Upgrade and Downgrade OptionsHi Santanu, there's no automatic downgrade. When you request a READ lock you get a READ lock, the session will be blocked until the other session commits. You can check if the request will be...
242706 Dec 2013 @ 01:57 PSTDatabaseReplyDefault date column not aligning in xcelThis is probably because Excel can't handle dates before 1900, regardless of how it's formatted. You can only use that date as a string.
242606 Dec 2013 @ 01:14 PSTDatabaseReplyStroed Procedure:Executing succesfully without errors while calling but the output is not being affectedIt's working using dbc.TableSize, but it's not the best way to get that info. TableSize returns multiple rows per table while it's only a single row in TablesV 
242505 Dec 2013 @ 11:59 PSTDatabaseReplyStroed Procedure:Executing succesfully without errors while calling but the output is not being affectedThe SP is running in ANSI mode and there's no COMMIT within the SP.  Do you COMMIT after the CALL?   CALL db1.DROP_JI('DB1','INDEXNAME'); COMMIT; And why don...
242405 Dec 2013 @ 02:51 PSTDatabaseReply Teradata BTEQ - Error: Invalid logon!When you use BTEQ in interactive mode you can't specify the password in your logon string, this is just for batch mode. Just use .logon 127.0.0.1/dbc and BTEQ prompts for the password.
242305 Dec 2013 @ 09:34 PSTViewpointReplyUsers Online at a particular time durationHi Mohammad, what do you mean by "online"? Logged on to your Teradata system?    dbc.LogonoffV keeps the history of sessions, there's a row with LogonDate/LogonTime for ...
242205 Dec 2013 @ 09:03 PSTDatabaseReplyDistinct LogicSeems you want an indicator if a Name exists in Name1 or Name2, but your result doesn't match. SELECT name, MAX(Name1), MAX(Name2) FROM ( SELECT name1 AS name, 'Y' AS Name1, &...
242105 Dec 2013 @ 08:55 PSTDatabaseReplyHow to use CASE statement when having multiple hierarchy picksPut a filter using ROW_NUMBER in a Derived Table and join to it: SELECT * FROM tab QUALIFY ROW_NUMBER() OVER (PARTITION BY LINE_ITEM ORDER BY CASE STATUS_...
242004 Dec 2013 @ 12:12 PSTDatabaseReplyWhom can help me explain the ‘46.06:18:08’ time.This strange value is only returned when you have an ODBC connection, so it seems to be a SQLA or ODBC bug:  SELECT CAST(-1008 AS SMALLINT FORMAT '99:99:99'), CAST(-1008 AS ...
241904 Dec 2013 @ 11:36 PSTDatabaseReplyQuery to find tables with no stats defined/old statisticsHi Nilesh, if you need to get that info you have to talk to your DBA to grant access.
241802 Dec 2013 @ 07:47 PSTDatabaseReplyNeed guidanceCan you share the definition of both fact tabe and JI, the MERGE and explain? What's the spool size assigned to your load user?
241702 Dec 2013 @ 07:45 PSTDatabaseReplyNeed help getting rid of parcel length error in BTEQ scriptHi Mike, yes, REPEAT repeats the following SQL-command. In your case it run the ";" 230 times :-) .REPEAT * EXECUTE DBADMIN.ShowDatabase (:DatabaseName); There's "=n...
241601 Dec 2013 @ 07:55 PSTDatabaseReplyConversion of Time to INTERVALHi Khurram, simply change the resulting type: Converted_Time - time '00:00:00' hour to minute
241501 Dec 2013 @ 05:08 PSTAsterReplyAster Demo on running on OS X Hi Vinay, could you please elaborate? I use VMWare Fusion on my Mac and never had problems running a Teradata or Aster VM. Should be similar with Parallels or Virtual Box, but you probably have ...
241401 Dec 2013 @ 05:01 PSTDatabaseReplySplit the dates bi-weeklyI don't get what your exactly trying to achieve. "run my job bi-weekly": scheduling a job on Unix or retriving rows in a SELECT? "nearest monday": based on what, first of ...
241301 Dec 2013 @ 04:53 PSTCloud ComputingReplyTD-14 VM Ware IssueHi Khurram, does the GUI start when you enter a "init 5" after logging on a root on command line?
241201 Dec 2013 @ 04:52 PSTDatabaseReplyError 7628 happened in TRANSACTION mode whiling trying to insert a table that has "WITH CHECK OPTION" foreign key≈Hi Khurram, within the transaction the row will be visible without commiting it, the error must be caused by something else.#   @zhiyanshao: What do you mean by TRANSACTION mode? ANSI vs....
241101 Dec 2013 @ 04:41 PSTData ModelingReplyPPI VS NPPIHi Khurram, afaik there's no such term, UPI/NUPI/USI/NUSI/VOSI/NoPI/PPI/MLPPI/CPPI/JI/AJI/HI are more than enough :-) I never use NPPI, it's just the same as PI, a table which is not part...
241001 Dec 2013 @ 04:35 PSTDatabaseReplyConversion of Time to INTERVALHi Khurram, TIME -TIME results in an interval: Converted_Time - time '00:00:00' hour to second(0)  
240929 Nov 2013 @ 02:03 PSTDatabaseReplyRegarding StatementText in accesslogHi Praveen, if this was an ANSI session it might be due to case sensitivity, but based on explain you seem to run in Teradata session mode. Are you shure that Access Logging is switched on for th...
240828 Nov 2013 @ 07:41 PSTDatabaseReplyRegarding StatementText in accesslogYour WHERE-condition on LogonDate is not valid, 11/28/2013 is not a DATE, it's a numeric calculation resulting in an INTEGER 0. sel StatementText from dbc.accesslog where UserName= ...
240728 Nov 2013 @ 05:48 PSTTeradata ApplicationsReplyFAST LOAD FAILINGFastLoad doesn't support concatenation, you need to use the MultiLoad protocol for that.
240628 Nov 2013 @ 05:40 PSTDatabaseReplyRounding hour and minute from time stamp to the closest hourHi Ozge, ROUND always results in a DATE (blame Oracle), so you can't use it in that case. What's the datatype of solved_at_ts and what datatype do you need as result? When you add 30...
240528 Nov 2013 @ 04:04 PSTDatabaseReplyRe-writing a query interms of performanceThere's no PARTITION stats on KEY_T and no re-collection for three weeks. The UPI on T_CUST does not provide a better distribution than a NUPI (FIRST_DT ,VISITOR_ID), but prevents a fast ...
240428 Nov 2013 @ 03:17 PSTDatabaseReplyRe-writing a query interms of performanceThe explain looks like expected, redistributing CUST_T and then a local join to KEY_T. There's "no confidence" for join and aggregate (which stats are collected?), if the actual numb...

Pages