#DateForumTypeThreadPost
337831 Dec 2014 @ 03:24 PSTGeneralReplyLoading data from Netezza table to Teradata table using TPTHi Vigneshwar, you should try TPT's ODBC operator to connect to Netezza.
337730 Dec 2014 @ 10:49 PSTDatabaseReplyBTEQ exits with Wrong Error codeThe only way is testing the SQL code before in BTEQ :-)
337630 Dec 2014 @ 09:15 PSTData ModelingReplyImplimenting Seconday indexesCan you show some DDL and how those tables are actually joined?
337530 Dec 2014 @ 09:11 PSTDatabaseReplyGET DIAGNOSTICS v_Variable_Name = ROW_COUNT giving wrong outputHi Parth, can you show the DECLARE v_Variable_Name? Might be defined as a SMALLINT and there's no error returned when it overflows...
337430 Dec 2014 @ 09:08 PSTDatabaseReplyHow to Enable Temporal Feature Hi Ravi, simply talk to your TD support, they know which internal dbscontrol field has to be modified.
337330 Dec 2014 @ 09:07 PSTDatabaseReplyQuery on efficient join and update Hi Santanu, Q1: Of course a single UPDATE works best. Q2: Based on statistics the optimizer should choose the best plan, the alternative will be duplicating rows from the calendar table to all AM...
337230 Dec 2014 @ 08:53 PSTGeneralReplyStored Procedure in TeradataHi Amit, if you can do the same in a macro, this would be prefered over an SP. But if there's more complex logic there's no other way (at least within the database) than using an SP....
337130 Dec 2014 @ 08:53 PSTDatabaseReplyINSTR and SUBSTRING are not working in SHELL SCRIPTThe variation you wrote will never work in shell (=BTEQ), remove the INSTR and you still get the same error while INSTR standalone will work.
337030 Dec 2014 @ 08:38 PSTDatabaseReplyBTEQ exits with Wrong Error codeEvery SQL statement is termintated by a semicolon and this is missing before the 'IF', so the '.IF' is part of the UPDATE statement (I already wrote that in the 2nd copy of your que...
336930 Dec 2014 @ 03:50 PSTToolsReplyTERADATA TPUMPHi Shankar, all rows go to the same AMP and are appended at the 'end' of the table probably in a single datablock, that's why it's much more efficient than distributing them to mul...
336830 Dec 2014 @ 03:40 PSTDatabaseReplyWhere summary stats are storedThe stats created by "COLLECT SUMMARY STATS" are also stored in the 'Histogram' column of dbc.StatsTbl with StatsId = 0
336730 Dec 2014 @ 03:37 PSTDatabaseReplyusing update with WITH clauseHi Parth, you simply can't update a Common Table Expression in Teradata. What are you trying to achieve, maybe there's a workaround.
336630 Dec 2014 @ 03:35 PSTDatabaseReplyMload in with multiple delimiterIn TD14 you could use '^' as delimiter in MLOAD and STRTOK(actvy_msg_txt, '|', n) for the subparts within the SQL INSERT.
336530 Dec 2014 @ 03:31 PSTGeneralReplyBteq exits with wrong error codeDue to the missing semicolon the .IF is considered being part of the UPDATE statement, the 'Syntax  error' message clearly indicates this. So the UPDATE doesn't fail, it's just...
336430 Dec 2014 @ 03:27 PSTDatabaseReplyINSTR and SUBSTRING are not working in SHELL SCRIPTHi Naveen, There are two variations of substring in Teradata: SUBSTRING(str FROM startpos FOR length) -- Standard SQL SUBSTR(str, startpos, length) -- Teradata SQL SUBSTR(str FROM ...
336322 Dec 2014 @ 10:58 PSTDatabaseReplyHow to store output of show table in a variable in Stored procedureHi Rohan, dbc.TextTbl keeps the full source code if it's more than 12500 characters, but for tables it's still the last DDL, e.g. SELECT C.TEXTSTRING FROM DBC.TVM A INNER JO...
336222 Dec 2014 @ 10:54 PSTGeneralReplyData Quality checks on the user dataOTranslate plus regular expressions are implemented in TD14, before there's only oTranslate as part of the Oracle UDFs, ask your TD support for the latest release.  
336122 Dec 2014 @ 02:12 PSTGeneralReplyData Quality checks on the user dataYour requirements should be covered by some simple regular expression using REGEXP_SIMILAR
336022 Dec 2014 @ 02:10 PSTDatabaseReplycreate a composite Collect stats commandHi Vince/Rohan,  you need to add IndexNumber to the join condition, too.   Btw, you can also utilize my StatsInfo view for creating COLLECT STATS on indexes: pre-TD14: How to dec...
335922 Dec 2014 @ 01:58 PSTDatabaseReplySelect Access Error in Procedure Hi Sandeep, you probably didn't set the SP's SQL SECURITY. Check  http://www.info.teradata.com/HTMLPubs/DB_TTU_15_00/index.html#page/SQL_Reference/B035_1144_015K/privilege_violation...
335822 Dec 2014 @ 01:52 PSTToolsReplyTERADATA PROFILER QUERIESIf I want to know the exact SQL submitted by an application I simlpy extract it from DBQL :)
335722 Dec 2014 @ 01:46 PSTDatabaseReplyHow to store output of show table in a variable in Stored procedure@Rohan: Please check the code in dbc.TablesV.RequestText after doing any DDL on a table.   @teradatauser2: There's no way to get the actual source code for a table beside SHOW TABLE. ...
335620 Dec 2014 @ 03:09 PSTDatabaseReplyHow to store output of show table in a variable in Stored procedureRequestText contains the source code of the last modification of a table definition, i.e. ALTER TABLE or CREATE INDEX instead of CREATE TABLE. Have a look at Glenn McCall's article how to solv...
335517 Dec 2014 @ 01:59 PSTDatabaseReplySQL to TERADATA MigrationYou do the same you should do in MS SQL Server instead of the proprietary [] syntax, use double quotes: "CUSTOMER ID" You CONVERT example is not valid syntax in MS. But col1 seems t...
335417 Dec 2014 @ 01:41 PSTGeneralReplyDynamic Date Range in where clauseHi Vinay, why do you post the same question twice?   What's your TD release? WHERE calendar_date BETWEEN NEXT_DAY(CURRENT_DATE-8, 'mon') AND CURRENT_DATE-1 WHERE calendar_...

Pages