598 | 20 Feb 2014 @ 03:23 PST | Database | Reply | Multiple values using case statement | Also, your CREATE TABLE and INSERTs are not correct.
Providing correct/actual scenario/SQLs generally help getting you a solution quickly.
|
597 | 20 Feb 2014 @ 03:22 PST | Database | Reply | Multiple values using case statement | In case you execute following:
EXECUTE samplemac(2061001) ;
You need following rows:
2061001 Jugal
... |
596 | 20 Feb 2014 @ 02:54 PST | Database | Reply | ODBC client on windows | The 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... |
595 | 20 Feb 2014 @ 02:52 PST | Database | Reply | Sequence Generator | You 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... |
594 | 20 Feb 2014 @ 02:49 PST | Database | Reply | Table Stats | You 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... |
593 | 20 Feb 2014 @ 02:43 PST | Database | Reply | Order by Date | My 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.
... |
592 | 20 Feb 2014 @ 02:30 PST | Database | Reply | Keep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsert | This 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.
|
591 | 20 Feb 2014 @ 12:29 PST | Viewpoint | Reply | Analyze Query logs | You 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 ... |
590 | 19 Feb 2014 @ 11:49 PST | Database | Reply | Keep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsert | Jumps around .... ? Can you share complete DDLs and the SQL you are using?
|
589 | 19 Feb 2014 @ 11:48 PST | Database | Reply | EXEC 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 ... |
588 | 19 Feb 2014 @ 11:47 PST | Database | Reply | Order by Date | Thats 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... |
587 | 19 Feb 2014 @ 09:31 PST | General | Reply | error: The format or data contains a bad character | You 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... |
586 | 19 Feb 2014 @ 09:29 PST | Database | Reply | Regular Expression On Teradata 14.0 | Very nice post Satyaki. You can also evolve this post into an article and publish it on Develop Exchange.
Good sharing.
|
585 | 19 Feb 2014 @ 09:25 PST | Database | Reply | SSIS and Global Temp Tables | Welcome Richard! :)
|
584 | 19 Feb 2014 @ 09:24 PST | Database | Reply | Delete table from within SSIS | Its 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.
... |
583 | 19 Feb 2014 @ 09:22 PST | Database | Reply | Keep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsert | No there is no cache .... have you checked if there are actually full-row duplicates coming from source?
|
582 | 19 Feb 2014 @ 09:20 PST | Database | Reply | ODBC client on windows | Is 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?
|
581 | 19 Feb 2014 @ 10:24 PST | General | Reply | FYP ideas | What 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... |
580 | 19 Feb 2014 @ 10:19 PST | Database | Reply | Best way to generate the Sequential numbers : CSUM or IDENTITY columns? | Reddy, just replied to your post .... please have a look.
|
579 | 19 Feb 2014 @ 10:18 PST | Database | Reply | Table Stats | Also .... 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 ... |
578 | 19 Feb 2014 @ 10:15 PST | Database | Reply | Table Stats | You 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... |
577 | 19 Feb 2014 @ 10:12 PST | Database | Reply | SQL help | Is the table SET or MULTISET? You used INSERT .... SELECT for inserton?
Can be due to full row duplicate getting suppressed.
|
576 | 19 Feb 2014 @ 10:10 PST | Database | Reply | Sequence Generator | The 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
... |
575 | 18 Feb 2014 @ 10:21 PST | Tools | Reply | SELECT statement in a TPT EXPORT script | 'seleSELECT' .... ? Hope its not the actual code.
|
574 | 18 Feb 2014 @ 09:36 PST | General | Reply | error: The format or data contains a bad character | This 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... |