#DateForumTypeThreadPost
297802 Aug 2014 @ 01:09 PDTDatabaseReplyRank with Qualify not giving the exact results.Hi Amit, you probably need to partition by your part column, PARTITION BY FROM_ID?
297731 Jul 2014 @ 03:14 PDTDatabaseReplyDistribution in ampsThe table header is not always 1 KB, in fact it's usually larger, might be up to 1 MB per AMP The actual size per AMP depends on the number of columns & indexes, multi value compression, e...
297631 Jul 2014 @ 03:12 PDTDatabaseReplyAvoid Product Join StepYou need to show the actual query plus explain to find out.
297531 Jul 2014 @ 03:08 PDTDatabaseReplynumber of rows per AMP - BEFORE RECONFIGURATIONHi Piotr, I don't know if I understood you correctly, but if the reconfig didn't run yet, the new AMPs are unknown to the system. So you run the same query as before...    
297431 Jul 2014 @ 02:25 PDTDatabaseReplyDeferred name resolutionIf you check the message it should be a Warning instead of an error and the SP should be created.
297331 Jul 2014 @ 02:23 PDTDatabaseReplyTimestamp format on teradata retrievalHow does your input data look like? Is there a formatting rule? Based on yor actual needs you might use a Regular Expression in TD14 to check for valid date/time.
297231 Jul 2014 @ 02:20 PDTDatabaseReplyconcatenate timestamp with charThere's no automatic typecast for Timestamps, you need to cast them explicitly: cast(current_timestamp as varchar(32))||'abc'
297131 Jul 2014 @ 02:17 PDTDatabaseReplyfilter numeric letters from combination of alpha numeric letters and numeric lettersHi Satvik, what's your TD release? In TD14 you can utilize a Regular Expression: regexp_substr(col, '[0-9]+') This will extract the first seqence of digits.
297031 Jul 2014 @ 02:14 PDTDatabaseReplyHow to sleep/pause in a Stored Procedure?It's probably not filling the Query Log or Access Log, but it's a waste of resources, it's a loop possibly consuming 100% CPU during the sleep.
296929 Jul 2014 @ 01:31 PDTDatabaseReplyremove line feed, carriage return from column'0D0A'XB returns a binary string, you need to change it to '0D0A'XC. And instead of oReplace you better use oTranslate to remove both characters independently: oTranslate(col...
296829 Jul 2014 @ 01:10 PDTDatabaseReplyAvoid Product Join StepBoth steps show no confidence, are you sure that the necessary stats exist?
296729 Jul 2014 @ 01:03 PDTDatabaseReplyDeclare and Set then Open and FetchStandard SQL's LAG and LEAD functions are not implemented in TD, but it easy to rewrite. E.g. get the previous row's value  min(gpi10) over (partition by memberId order by ...
296627 Jul 2014 @ 07:35 PDTDatabaseReplyDeclare and Set then Open and FetchThe logic can be easily be ported to a Teradata Stored Procedure. Most of the syntax is the same, e.g. declare cursor/while/fetch/set, but some has to be adjusted, e.g. - TD doesn't allo...
296527 Jul 2014 @ 02:42 PDTDatabaseReplySecondary Index and No PI tableThere's no difference for a NUSI on PI vs. NoPI tables, each row in a NoPI table still has a RowID: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/Database_Management/B035_...
296427 Jul 2014 @ 02:35 PDTDatabaseReplyhexadecimal--->decimal It would be nice to actually pose a question. 16hex = binary|string? result = binary|string|numeric?    
296326 Jul 2014 @ 08:55 PDTDatabaseReplyAvoid Product Join StepAs there's a good join-condition the product join was choosen by the optmizer cause it's the best way to get the result. Did you check in DBQL if the estimated number of rows is actually i...
296226 Jul 2014 @ 02:24 PDTToolsReplyTPT : Suppress or Redirect stdout/stderr logsHi Tarun, I don't think you can switch off the output to stdout within TPT. The TRACELEVEL option controlling what is written to the log is set to NONE by default, setting it to a higher...
296126 Jul 2014 @ 02:11 PDTDatabaseReplyTeradata Reports are running very slowHi Mahendra, the way you describe it, the TASM settings don't look optimal :-) But there's no way to deal with that doing a post here on DevEx.  
296026 Jul 2014 @ 02:09 PDTDatabaseReplyDate_Insert_errorThere are two issues with that timestamp (only Oracle calls a timestamp a date) string: 9 digits for fractional seconds, Teradata allows only up to 6. You need to strip of the addition...
295925 Jul 2014 @ 01:36 PDTGeneralReplyMAX() OVER () function producing inconsistent resultsWithout ORDER BY the result is random, based on you expected result you probably need: , MAX(GOVT_ID) over (partition by AGREEMENT_ID, PDCR_ID ORDER BY OWNR...
295825 Jul 2014 @ 07:21 PDTToolsReplyTPT : Suppress or Redirect stdout/stderr logs"level of IO"? For a few lines? You're joking :-) if you don't want that output redirect to /dev/null
295725 Jul 2014 @ 05:44 PDTDatabaseReplyProblem with Polish special characters in WHERE clauseLATIN can't store polish characters, you must use UNICODE and use UTF8 or UTF16 sessions. After inserting those polish characters in an ASCII session you should select them. You'll notice ...
295625 Jul 2014 @ 03:03 PDTToolsReplyIssues with loading date field using BTEQ script- when you define VARTEXT all fields must be defined as VARCHAR in USING - a FLOAT is a FLOAT and not a DATE
295525 Jul 2014 @ 02:08 PDTDatabaseReplyerror in UPDATE statementHi Carlos, of course you're right :-) I didn't read your anwer before my post and also didn't notice the bad syntax.
295425 Jul 2014 @ 01:25 PDTDatabaseReplyIdentify Multicolumn Foreign key on TD 14It's an easy task to provide the info about multicolumn FKs using the dbc views as each column of a  multicolumns FK is stored as a row in those views (similar to dbc.IndicesV).

Pages