#DateForumTypeThreadPost
22805 Nov 2007 @ 07:15 PSTTrainingReplyVersion 12 certificationHi Ayes,i think you'll have plenty of time to finish V5 Master. There are no new test now, even no beta tests.After the new test version is released you still can run the old ones for several month...
22705 Nov 2007 @ 07:07 PSTDatabaseReplyHow to force duplication of the rows from a small table on all AMPsHi Annal,this is just to "help" the optimizer to forget about the index. This might change the plan, that's why you have to check explain.Dieter
22603 Nov 2007 @ 12:20 PDTTrainingReplyVersion 12 certificationHi Leo,of course there will be a new certification for TD12.The official annoucement was "new certification every other major release".V2R3 - V2R5 - TD12Dieter
22503 Nov 2007 @ 12:18 PDTDatabaseReplyHow to force duplication of the rows from a small table on all AMPsThere's an old trick when you don't want an index to be used (and this is working for most DBMSs):Do a calculation on that column, e.g.large_table l join small_table s on l.col = s.col + 0 or s.col...
22402 Nov 2007 @ 05:02 PDTDatabaseReplyHow to avoid round of functionality in AVG() ?The result of that AVG is already a float, so there's not need for a Typecast, this is probably just a display problem:You probably run that query in SQL Assistant and this defaults to 2 fractional...
22302 Nov 2007 @ 04:56 PDTDatabaseReplyDENSE_RANKDENSE_RANK calculates the number of proceeding distinct values, plus one. If multiple rows haveequal values, they all get the same rank, but there are no gaps. Each change in data value causes ther...
22202 Nov 2007 @ 04:47 PDTAnalyticsReplyUnion Character Data with Numeric dataI don't know about your case, but for any Set operations the first select determines the datatype and format of that column.You should check if there's a Date column in your first select and cast i...
22102 Nov 2007 @ 04:43 PDTAnalyticsReplyVolatile Tables - Current DisplayShure ;-)HELP VOLATILE TABLE;Dieter
22031 Oct 2007 @ 10:07 PDTDatabaseReplyAccessing Partition ID for a TablePARTITION exists since V2R5, but you select from a view:5879 Invalid Partition field.Explanation: Views and derived tables do not have aPartition field.Generated By: RES Module.For Whom: End-UserRe...
21931 Oct 2007 @ 10:03 PDTAnalyticsReplyLoading tables from Teradata 5 to Teradata 6Hi Shash,FastLoad et.al. are part of the Teradata Client and not of the Teradata DBMS.And the best way to copy x tables is a BACKUP on the old system followed by a COPY to the new system.Dieter
21830 Oct 2007 @ 08:00 PDTDatabaseReplyColumn compression and Table header sizeHi Annal,you can use MIN/MAX/AVG because the table header is stored on each AMP, so it's the same size per AMPDieter
21730 Oct 2007 @ 07:04 PDTDatabaseReplyColumn compression and Table header size"Table header size" is the size of the table without any data in it:create table dropme as exsiting_table with no data;select min(currentperm) from dbc.tablesizewhere databasename = database and t...
21630 Oct 2007 @ 07:01 PDTDatabaseReplyData DictionaryThere's a whole manual dealing with those systemtable-columns: Data Dictionay ManualQ -> PPIK -> PK within Create Table implemented as UPIDieter
21530 Oct 2007 @ 06:59 PDTDatabaseReplyDynamic SQL with Terdata"the query is prepared on run time by the application depending on the user input"Then there's no need for any Dynamic SQL within your example, just prepare a query/queries using plain SQL, e.g.:SE...
21430 Oct 2007 @ 05:39 PDTAnalyticsReplyInteger to date conversion - ErrorHi Laxmi,providing the actual error is more helpful than just "doesn't work".And why do you cast cal_id to an integer if it's already an integer?Dieter
21325 Oct 2007 @ 02:57 PDTDatabaseReplyDBC TablesHELP USER DBC simply doesn't return any table info unless user dbc submits that statement.Don't ask me why, it's probably because end users are not supposed to query any system table directly, but ...
21225 Oct 2007 @ 02:37 PDTDatabaseReplycase statement questionHi Joe,you can't use any Scalar Subquery in Teradata, it's still not supported :-(But you can rewrite it using an Outer Join:SELECT a.cust_num, CASE WHEN b.cust_num is not null THEN 'EAST COAST'...
21125 Oct 2007 @ 02:34 PDTDatabaseReplyAlter TableYou can change the datatype of a column as long as the physical storage remains the same, e.g. VarChar(5) -> Varchar(10), but not Varchar(10) -> Varchar(9)or Dec(5,0) -> Dec(9,0), nut not ...
21025 Oct 2007 @ 02:27 PDTDatabaseReplyAccessing Partition ID for a TableWell, yes...PARTITION and ROWID, but ROWID is usually switched off, so you can't use it anymore.Dieter
20925 Oct 2007 @ 02:25 PDTAnalyticsReplyVolatile Tables - Current DisplayHi Craig,HELP VOLATILE TABLE list all VT within your session, for column definitions use HELP TABLE vt_tabke_nameDieter
20824 Oct 2007 @ 02:54 PDTDatabaseReplyName convension problem.Just use double quotes:drop table test12."1sttable"Dieter
20723 Oct 2007 @ 02:43 PDTUDAReplyHow effceint the Teradata is ?There's almost no difference between an Integer PI and a 100 byte multi-column VarChar PI, because Teradata uses hashing. Of course there's more overhead to calculate a hash value from 100 byte com...
20623 Oct 2007 @ 02:36 PDTToolsReplyFastload UtilityHi Anil,interactive mode: start FastLoad/BTEQ/Mload from command line and then type in all the commands.batch mode:fastload outJust search the FastLoad manual for "interactive".Dieter
20522 Oct 2007 @ 12:31 PDTDatabaseReplyCasespecific ColumnHi Chichi,it's exactly the syntax you used :-)col varchar(x) UPPERCASEDieter
20414 Oct 2007 @ 11:13 PDTDatabaseReplyWhat exactly is Session?Hi Ravindra,yes, you're right, any PE/AMP can send messages to any AMP/PE within the system via BYNET.And sessions are established between TDP (on Mainframes, MTDP on LAN-clients) and a PE.Dieter

Pages