All forum activity

#DateUserForumTypeThreadPost
1515230 Mar 2010 @ 03:10 PDTRandom_ThoughtDatabaseReplyI'm a learner of teradata. And could you advise me How to study teradata?If you have experience of other databases, go on the 1 day initial introduction to teradata course, it will give you an understanding of the differences. If you have no experience of databases, go...
1515130 Mar 2010 @ 02:25 PDTnycleDatabaseTopicI'm a learner of teradata. And could you advise me How to study teradata?hello,every one, I'm nycle. I like database very much. But I am a learner of teradata. And I find that there are a few resources on the internet. And could you advise me How to study teradata? Co...
1515030 Mar 2010 @ 02:11 PDTswati savalagiGeneralReplyWelcome to the Teradata Developer Exchange discussion forums!Hi all, 2 sec ago i want to merge the results of many rows including duplicate values to one row.for example like consider column empid empid 100 200 400 100 500 200 . . . n numbers ...
1514930 Mar 2010 @ 02:11 PDTRandom_ThoughtDatabaseReplyHow to gain performance in manipulating and querying huge tables ?Gott, I hate to see a posting go unanswered, (Especially mine!) but I think to answer fully people may need a little more information. What is your teradata node configuration? How big is the...
1514830 Mar 2010 @ 01:43 PDTnycleDatabaseReplyMulti-Partitioning - how to hit the partition?I think the condition nerver use the column "day", so it doesn't hit the partition. If you want to hit the partition, so you should filter the conditon of column "day".
1514729 Mar 2010 @ 10:23 PDTsundeep.boseConnectivityReplyHow to mention default database when using Teradata OLEDB provider for connection(DSN LESS). thanks.
1514629 Mar 2010 @ 09:05 PDTdilip_023ToolsReplyerror occured in TPUMP utilityrevert to me if any issues
1514529 Mar 2010 @ 09:04 PDTdilip_023ToolsReplyerror occured in TPUMP utilityhey just look into the macro if u have any conflicting defintion i.e. in tpump u have the insert and inside the maro u have delete statement.
1514429 Mar 2010 @ 02:05 PDTGreyghostToolsReplyWindows 7 & SQL Assistant/Teradata AdministratorWhere could I download vesion 13 of the Teradata Utilities? I would like to try this with Windows 7, it may work since no one has heard of issues with this release. Thanks!
1514329 Mar 2010 @ 08:50 PDTwaqasshamiToolsReplySUN Solaris SPARC & Teradata 12 UtilitiesOn Average these 5 utilities requires about 500 MB of space. this space is just for installation of these utilities.
1514229 Mar 2010 @ 04:08 PDTklnleelaMarketing & CRMTopicBuffer clearing options are not workingHi, We are using the Automatic buffer claering, but it is not working fine. weekly we need to do manually. Please can any one explain why it is not happening. Thanks.
1514129 Mar 2010 @ 03:35 PDTvishwaTrainingReplyregarding learning teradata basics Hi all This is vishwa I am new to Teradata, I worked on EDI tools like AxS & zentran I want to learn teradata on my own i am just aware of the database concepts . Can anyone suggest me how ...
1514029 Mar 2010 @ 01:49 PDTdnoethToolsReplyinsert into problem in BTEQINSERT INTO tableName (col1, col2, col3) SELECT :next_var + row_number () over (order by ???) col2, col3 FROM tableName; Dieter
1513929 Mar 2010 @ 01:36 PDTdnoethUDAReplyjoining table A to table B only once where condition satisfiedHi Chris, only SPs with Dynamic SQL (not in this case) or DDL statements must be created within the creator (this limitation is lifted in TD13). So for a first try you might to drop/create the Vo...
1513828 Mar 2010 @ 11:34 PDTWAQToolsTopicinsert into problem in BTEQi want to insert some values in my table using INSERT INTO SELECT SQL as: INSERT INTO tableName (col1, col2, col3) SELECT col2, col3 FROM tableName; for col1 i need to pass the value comming...
1513728 Mar 2010 @ 09:20 PDTbarcooUDAReplyjoining table A to table B only once where condition satisfiedOh cool, you are still looking at this Dieter. Thanks What you have typed above is what I've been trying to write up, but stored procedures are outside my understanding. Currently reading the ma...
1513628 Mar 2010 @ 09:01 PDTFredDatabaseReplyMulti-Partitioning - how to hit the partition?You can't get "static" partition elimination, but you may be able to get a join plan that is "enhanced by dynamic partition elimination". What stats have you collected on t_day? How about multicolu...
1513528 Mar 2010 @ 08:52 PDTFredDatabaseReplydifference of values with datatype TimeBut duration would be an INTERVAL datatype. It's logically incorrect to assign an INTERVAL value to a TIME field. If you absolutely insist on storing the result as TIME(0) instead of the proper typ...
1513428 Mar 2010 @ 06:50 PDTQuantRecJobsTopicTeradata Application DBA Large Financial Company / NYC Senior, Team Member level Application DBA. 125K base +bonus. Email resumehttp://bit.ly/c6AQFQ Candidate invites of all types welcome. Send to email listed, and there may be positions for you in the near future, broaden and expand your contacts! If qualified, email...
1513328 Mar 2010 @ 06:48 PDTcodesaiConnectivityReplyError 7583 when calling external stored proceduredid anyone find a solution to this?.. i login to a different machine and get this error when i try to run a java udf. i login to vmware on that machine and try to run the udf. i get this same e...
1513227 Mar 2010 @ 11:47 PDTvenky3057DatabaseReplyNUSI Vs. FTSHi, I have similar request where my base table have around 2400 Million records :(. I have to join it to another table(with around 100 millions of data) based on a NON-INDEXED column. Is it prefe...
1513127 Mar 2010 @ 04:56 PDTdnoethToolsReplyusage of check point in fastloadIf Teradata restarts during a FastLoad it just waits for the DBMS to recover and then finishes the load, without resending data. If the FastLoad job has to be restartet (e.g. FastLoad crashes or...
1513027 Mar 2010 @ 04:13 PDTtmrmodest1ToolsTopicusage of check point in fastloadHi, Checkpoints is used to resume the paused job, at a point where it was paused, because of the error caused by the client or by the RDBMS. Am i right with the definition. Assume checkpoints ar...
1512926 Mar 2010 @ 05:35 PDTAnyutaDatabaseTopicCannot start db :(Hi everyone, I couldn't get my db started after I rebooted my host. I get this error: PDE not accessible: Cannot open PDE device What does it mean and how to fix it? I had to reboot the...
1512826 Mar 2010 @ 10:27 PDTJim ChapmanDatabaseReplyTD 13The most significant new features of each release are itemized the Release Summary in the documentation set for that release, which you can find at this site (http://www.info.teradata.com/).

Pages