#DateForumTypeThreadPost
300308 Aug 2014 @ 03:07 PDTData ModelingReplyCalendar dimensionHi Mahesh, assuming that 2013 Week52 was a typo and should be 53, too? This is based on the built-in sys_calendar, so you can easily adjust it to your calendar: SELECT -- Jan 1st = (...
300207 Aug 2014 @ 12:20 PDTDatabaseReplyWhat is mean by STAT FUNCTION in TeradataAsk the developer team if they got DBQL information or an old Explain for this query, then you can spot differences and start investigating.
300107 Aug 2014 @ 12:14 PDTDatabaseReplycoalesce functionAssuming that AP.RECORD_DATE is a date, you're trying to combine a DATE and a VARCHAR. As you can't turn 'Not yet recorded' into a valid date you must cast the date to a VarCh...
300007 Aug 2014 @ 09:37 PDTGeneralReplyQuery to update the sequence number of duplicate rowsYou can get the count using a ROW_NUMBER() OVER (PARTITION BY field1, field,2, field3, field4 ORDER BY 1) But there's no way to use this in an UPDATE. You could INSERT SELECT those rows wi...
299907 Aug 2014 @ 09:22 PDTDatabaseReplyWhat is mean by STAT FUNCTION in TeradataWhat do you mean by "Previously this query was running fine"? Exactly the same query, similar data? Can you check if DBQL step/explain information is available for the previous run? Is...
299807 Aug 2014 @ 09:14 PDTDatabaseReplyCreate Table Syntax ErrorThere's no display width for INT in Teradata, this looks like MySQL syntax. Simply remove it (int (1) -> int), if it's actually less digits you might consider 1, 2, 4 or 8 byte integers...
299707 Aug 2014 @ 06:36 PDTData ModelingReplyCalendar dimensionYour current calendar is an Oracle calendar :-) What about 2013-12-30 and 2013-12-31, should it be 2014 Week 01, too, or 2013 Week 53?
299607 Aug 2014 @ 06:07 PDTDatabaseReplyWhat is mean by STAT FUNCTION in TeradataStep 7 is one of the ROW_NUMBERs, both are a bit strange as they PARTITION and ORDER BY the same columns. You might simply change the ORDER BY to ORDER BY 1 instead. And you might not need them at...
299507 Aug 2014 @ 06:03 PDTDatabaseReplyBTEQ Import going to DELAYED stateUsing PACK you still get delayed by TASM, but instead of inserting a single row PACK rows are processed, so all 400 should be inserted at once. You might also talk to your DBA the exclude short wo...
299407 Aug 2014 @ 02:44 PDTDatabaseReplyTactical queriesdbc.QryLogV.CacheFlag Value Description T Query is found in step cache. S Query is a parameterized query and a specific plan is generated. G Query is parameterized query and a gener...
299307 Aug 2014 @ 02:42 PDTDatabaseReplyUser not listed in DBC.UsersVYou need to be an owner of a user or the DROP USER right to see them in dbc.UsersV
299207 Aug 2014 @ 02:39 PDTTrainingReplyNeed Teradata TE0-123 Physical implementation materials and dumps.Well, did you know that you sign a "TCPP Candidate Agreement" including non-disclosure of test questions when you do a certification test? So if there are actual dumps they would be illeg...
299107 Aug 2014 @ 02:21 PDTDatabaseReplyWhy did the numeric value search in the varchar field fail; and a date format display questionThat's it, a binary '00' is not a blank '20'. If it's supposed to be a VARCHAR you probably need to remove the trailing 00 using TRIM(TRAILING '00'xc FROM new_txt) ...
299006 Aug 2014 @ 02:44 PDTDatabaseReplyDetermine how much space a Global Temporary Table is using - TD 13.10/14.10Hi Robin, afaik there's no info about temp space usage in DBQL.  But you can get the combined size of all GTTs within a session using SELECT VProc, CurrentTemp FROM dbc.diskspaceV ...
298906 Aug 2014 @ 02:24 PDTDatabaseReplySybase to TerdataUnless the ampersand has a special meaning it's exactly the same in Teradats, simply remove the ampersand or replace it with a valid character, e.g. case when mx_as_of_dt0 > #as_of_dt the...
298806 Aug 2014 @ 02:20 PDTDatabaseReplyWhy did the numeric value search in the varchar field fail; and a date format display questionAny trailing blank will be ignored during comparison ('1' = '1  '), only a leading blank will not be equal ('1' <> ' 1'), but TRIM removes both leading an...
298706 Aug 2014 @ 02:14 PDTDatabaseReplyFront-end object does not exist errorAs goldminer said, different users might have different default databases  (if there's no default set on user level it's the user himself). so you need to qualify the tablename in your...
298606 Aug 2014 @ 09:33 PDTDatabaseReplyBTEQ Import going to DELAYED stateYou might try using a high PACK (e.g. PACK 10000) for the import, then it will be a single request. But if the PACK number is too high you will get an error, so check for Failure 5966 Too man...
298505 Aug 2014 @ 06:54 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverHi Sachen, please post totally unrelated questions as a new topic.
298404 Aug 2014 @ 11:54 PDTDatabaseReplyWhat is mean by STAT FUNCTION in TeradataWhat's the remaining text of this step? STAT FUCTION step might be TOP or a Windowed Aggregate Function like RANK or SUM OVER.
298303 Aug 2014 @ 04:06 PDTAnalyticsReplyPython in DatabaseAs for any new feature, check the Release Summary for this version. The SCRIPT table operator is not for implementing Python functions, but Phyton/Perl/etc. scripts, i.e. TD pipes rows as strings ...
298203 Aug 2014 @ 03:56 PDTToolsReplyBTEQ REPORT EXPORT AND IMPORT Hi Jugal, your CASTs still don't match, you use DeptId twice: CAST(EmpId AS CHAR(3)),EmpName,CAST(DeptId AS CHAR(10)),CAST(DeptId AS CHAR(3)). Regarding the error this looks like you didn...
298102 Aug 2014 @ 03:56 PDTToolsReplyBTEQ REPORT EXPORT AND IMPORT When you export in report format there's a .SEPERATOR (by default 2 blanks). Your number of column and length in EXPORT don't match your IMPORT definition: CAST(EmpId AS CHAR(3)),EmpName,...
298002 Aug 2014 @ 03:48 PDTTrainingReplyWhere can I get the Advanced Teradata SQL pdf documentCourse #25966 is a Teradata instructor-led training, a PDF copy would not be available in a legal way :-)
297902 Aug 2014 @ 03:44 PDTDatabaseReplyTeradata Table Naming Btw, the "lowest common denominator" is not Teradata, even Oracle 12c still supports only 30 characters for object names and 8 characters for database names :-)

Pages