#DateForumTypeThreadPost
3522 Jun 2006 @ 09:37 PDTDatabaseReplyDuplicate valueHi,are you thinking about duplicate rows or duplicate PI values?If you're thinking about duplicate rows, then you'll probably have a multiset table with a NUPI on it.1- if you don't want to have du...
3421 Jun 2006 @ 10:08 PDTDatabaseReplycommand to see description of column in teradataHi, you can retrieve:1. column list using "help table " syntax2. DDL of your table using "show table " syntaxHope this helps,Bye,TDUser
3314 Jun 2006 @ 03:40 PDTDatabaseReplyNew to teradataHi,yes you can installa Teradata on your Windows computer.I don't know if you can donwnload the demo version from one Teradata website, but you can ask for the free demo cd. It will be sent to you ...
3213 Jun 2006 @ 04:25 PDTTrainingReplyTeradata Design ArchitectHi,the exam you are interested in is based on the same topics of the phisycal implementation one, but it requires a deeper knowledge of these topics.Take a look at http://www.teradata.ncr-education...
3116 May 2006 @ 05:12 PDTDatabaseReplyQuery to get the last day of each month in a year.Hi,what about joining your empl table with sys_calendar.calendar on employee_date = the last day of every month? Obviously you have to extract from sys_calendar.calendar view the last day for each ...
3011 May 2006 @ 07:57 PDTToolsReplyInvoke Teradata BTEQ/MLOAD scripts from unix shell scriptIn your shell script you can use the same commends you use in windows environment:betq < the ctl filename >> the log filenamehope this helps,bye,TDUser
2911 May 2006 @ 02:40 PDTAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedHi, what about defining alias for each field of the derived table???I haven't tested your query, but I would use correct aliasing in using derived tables as a general behaviour....Bye, TDUser
2810 May 2006 @ 05:05 PDTDatabaseReplyCOLLECT STATISTICSHi TS,I would answer like this to your questions:1. when writing about small tables you are thinking about lookup tables, aren't you? if so, thinking about a 3NF db, I would collect stats on the pk...
2708 May 2006 @ 04:01 PDTToolsReplyMultiload pre-Begin Mload Target Table DELETE ALLHi bc,dropping/deleting tables or doing housekeeping sql before the .begin mload statement is permitted in a MLD thanks to the support environment that is a special environment that allows you to e...
2605 May 2006 @ 04:34 PDTUDAReplyHow to Create Flat FileHi, if you have Teradata RDBMS installed somewhere, on the server you'll find the executable files to run. Usually you find them in Program Files\Ncr\Teradata Client\bin\ directory.You may execute ...
2504 May 2006 @ 08:48 PDTUDAReplyHow to Create Flat FileHi Nits,you can create a flat file using fastexport utility. at this file:.logtable
2404 May 2006 @ 07:13 PDTDatabaseReplyHow to find a lost password for a userWell, if you were on your personal server.... what about applying the best "stop and restart solution"? That, in your case, would be uninstall and install the RDBMS again? :-) Joking aside, I don'...
2304 May 2006 @ 06:19 PDTDatabaseReplyHow to find a lost password for a userHi Amit,I don't think you can retireve a pwd once it has stored in the DD. If you look at dbc.DBase table you may understand the reason...If I were you I would chenge the user pwd connecting with a...
2202 May 2006 @ 09:05 PDTDatabaseReplyError Code 2652. Operation Not allowed.You may use an empty file if the first fastload does't perform the "end loading" command.In this case its RC is = 4, that is FastLoad paused. this is a very good way to load several files into an e...
2102 May 2006 @ 08:22 PDTDatabaseReplyError Code 2652. Operation Not allowed.Hi,this means that the fastload RD isn't 0. You must have a look to the log and understand what is your problem.Could you please post the fld log?However, in most of cases if one FLD job ends with ...
2002 May 2006 @ 05:05 PDTDatabaseReplyhow to get the primary indexes of all the tables in a user using dbc tablesOoopsss, sorry, I was wrong in posting the sql; you are asking about PI and not only tables.... :-) !Well, you may query dbc.indicesx view and look at indextype = 'p'.Bye!TDUser
1902 May 2006 @ 04:34 PDTDatabaseReplyhow to get the primary indexes of all the tables in a user using dbc tablesTry this:select *from dbc.tableswhere databasename = '';If you query directly tablesx view, you'll get only the tables and views of the username you are logged in with.Hope this helps,Bye,TDUser
1828 Apr 2006 @ 12:55 PDTUDAReplyconfidence showned in explain planGreat!I've always supposed that index join confidence was not so good, due to my direct experience; but this was probably due to having poor statistics...Thank you for you explanation, have a nice ...
1713 Apr 2006 @ 05:57 PDTDatabaseReplyquestion on TD partition, need help!If:1. the values of your PI are unique2. the partitioning column isn't part of your PIthen you can define a USI on these columns.Then you're right!TDUser
1613 Apr 2006 @ 03:55 PDTDatabaseReplyquestion on TD partition, need help!Hi Young,you're right: if your Primary Index is defined as not unique (but its values ARE unique), in order to ensure uniqueness you may use a USI.But you write "PI value is not unique".... I proba...
1511 Apr 2006 @ 09:09 PDTToolsReplyHelp required BTEQ IMPORTHi Musomasu,try defining fornmat for you input file....if I were you I would define format vartext and declare eno variable as VARCHAR(1).Hope this helps,Bye,TDUser
1431 Mar 2006 @ 06:16 PSTToolsReplyTpump - Is blocking normal?Hi,I've already encountered the problem you are describing here. Some colleagues of mine experienced tpump sessions locking each other.At this moment I don't remember really exactly but if I'm righ...
1313 Mar 2006 @ 12:20 PSTUDAReplyconfidence showned in explain planHi dixon,if I were you I would collect stats on the joined columns of both right and left table.I think index join confidence is bettere than no confidence; I've heard that it is worst than low con...
1209 Mar 2006 @ 05:21 PSTDatabaseReplyon product joinWell, this is a bit wide question....To start, try analyzing the explain plan and collecting statistics on the join fields.Bye,TDUser
1109 Mar 2006 @ 04:09 PSTDatabaseReplyteradata Certification Question model helpHi,take a look athttp://teradata.ncr-education.com/cgi-shell/wbt/dologin.pl?learning/TDCert/loginV2R5.htmand you'll find some tests.Bye,TDUser

Pages