#DateForumTypeThreadPost
59820 Feb 2014 @ 03:23 PSTDatabaseReplyMultiple values using case statementAlso, your CREATE TABLE and INSERTs are not correct.   Providing correct/actual scenario/SQLs generally help getting you a solution quickly.
59720 Feb 2014 @ 03:22 PSTDatabaseReplyMultiple values using case statementIn case you execute following:   EXECUTE samplemac(2061001) ;   You need following rows:   2061001 Jugal                  ...
59620 Feb 2014 @ 02:54 PSTDatabaseReplyODBC client on windowsThe string 'i386' in your version suggests you installed 32 bit driver.   Hence it will only be visible in ODBC 32Bit and wont be available in ODBC 64Bit (which opens up by default o...
59520 Feb 2014 @ 02:52 PSTDatabaseReplySequence GeneratorYou can visit the following thread, it has several options listed:   http://forums.teradata.com/forum/database/generate-surrogatekey-with-a-huge-table#comment-129849   How much data y...
59420 Feb 2014 @ 02:49 PSTDatabaseReplyTable StatsYou can use HELP STATISTICS <TableName> or from Teradata Administrator you can right-click on a table and click on 'Statistics' to get the stats that are collected.   It will l...
59320 Feb 2014 @ 02:43 PSTDatabaseReplyOrder by DateMy bad Reddy .... yes you can't have an order by in a view.   Having it in a MACRO is possible, but i believe it wont be very useful in your scenario as you cant use a MACRO in SELECT. ...
59220 Feb 2014 @ 02:30 PSTDatabaseReplyKeep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsertThis is due to the fact that sequence number is generated on AMP-local basis.   It is not called a sequence for a reason, but it will surely not repeat the values.
59120 Feb 2014 @ 12:29 PSTViewpointReplyAnalyze Query logsYou can find DBQL information for below link:   http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1093_111A/ch14.033.17.html   Following two ...
59019 Feb 2014 @ 11:49 PSTDatabaseReplyKeep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsertJumps around .... ? Can you share complete DDLs and the SQL you are using?
58919 Feb 2014 @ 11:48 PSTDatabaseReplyEXEC Privilege & Table access?Yes, the database in which that Macro resides should have access to the underlying tables. Without which you cant compile a Macro. And all you need is the right to execute Macro to get the desired ...
58819 Feb 2014 @ 11:47 PSTDatabaseReplyOrder by DateThats true, and we have many discussions on the forum relating to comparison between Teradata and Oracle/other RDBMS.   But you can surely get all the DWH needs fulfilled by simple or comple...
58719 Feb 2014 @ 09:31 PSTGeneralReplyerror: The format or data contains a bad characterYou have 1 extra ')' at the end of high-lighted text, following is correct:   (a12.FiscalWeekID =CAST(substr(a13.FiscalWeekID,1,4) AS INTEGER) -1) ||  cast(substr(a13.FiscalWeek...
58619 Feb 2014 @ 09:29 PSTDatabaseReplyRegular Expression On Teradata 14.0Very nice post Satyaki. You can also evolve this post into an article and publish it on Develop Exchange.   Good sharing.
58519 Feb 2014 @ 09:25 PSTDatabaseReplySSIS and Global Temp TablesWelcome Richard! :)
58419 Feb 2014 @ 09:24 PSTDatabaseReplyDelete table from within SSISIts SSIS question .... you need to find a way to run SQL from your package .... and then you can simply send   DELETE <Database Name>.<Table Name> ALL;   to achieve this. ...
58319 Feb 2014 @ 09:22 PSTDatabaseReplyKeep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsertNo there is no cache .... have you checked if there are actually full-row duplicates coming from source?
58219 Feb 2014 @ 09:20 PSTDatabaseReplyODBC client on windowsIs the DSN created? Is it a 64-bit Windows? Which ODBC are you checking .... ODBC 64-bit or ODBC 32-bit? Which tool are you trying to connect with .... Teradata Admin? SQL Assistant?
58119 Feb 2014 @ 10:24 PSTGeneralReplyFYP ideasWhat will be the duration in which you can work? 12 months?   I would suggest you to first finalize the team .... single or more .... but to finalize and start thinking/working like a team s...
58019 Feb 2014 @ 10:19 PSTDatabaseReplyBest way to generate the Sequential numbers : CSUM or IDENTITY columns?Reddy, just replied to your post .... please have a look.
57919 Feb 2014 @ 10:18 PSTDatabaseReplyTable StatsAlso .... in case you have some queries handy .... which will be frequently executed .... you can execute following command in a session:   DIAGNOSTIC HELPSTATS ON FOR SESSION;   And ...
57819 Feb 2014 @ 10:15 PSTDatabaseReplyTable StatsYou need to select which columns would be used frequently in JOINs and then you need to collect stats using below command:   COLLECT STATISTICS ON <Database Name> COLUMN (<Colu...
57719 Feb 2014 @ 10:12 PSTDatabaseReplySQL helpIs the table SET or MULTISET? You used INSERT .... SELECT for inserton?   Can be due to full row duplicate getting suppressed.
57619 Feb 2014 @ 10:10 PSTDatabaseReplySequence GeneratorThe format you have used .... is for defining a column in a table, like below:   CREATE TABLE TABLE1 ( Col1 INTEGER GENERATED ALWAYS AS IDENTITY Start with 1 Increment By 1 MinValue 1 ...
57518 Feb 2014 @ 10:21 PSTToolsReplySELECT statement in a TPT EXPORT script'seleSELECT' .... ? Hope its not the actual code.
57418 Feb 2014 @ 09:36 PSTGeneralReplyerror: The format or data contains a bad characterThis error usually occurs when you try to compare integer values with varchar [containing alpha-numeric values].   From what it appears to be .... FiscalWeekID must be INT and SUBSTR returns...

Pages