All forum activity

#DateUserForumTypeThreadPost
34222 Feb 2006 @ 06:08 PSTTD_ArchDatabaseReplyWhy the follwing query is getting lockedNot sure as to what is the question that you want to ask. Can you elaborate?
34122 Feb 2006 @ 02:45 PSTShefaliUDATopicfind out the number of nodes in a teradata architectureHow can you find out the number of nodes in a particular teradata database architecture? Is there any query that you can fire to find this out?
34022 Feb 2006 @ 01:07 PSTManoj_Kumar_ParmarToolsReplyBteq in Report formatI want to add more things that, o/p file should contain the column headings and correspoding column's data, like below:-Emplno ',' Deptno ',' Empname----- --- ------ --- ------------2134 , 34...
33921 Feb 2006 @ 10:20 PSTs90570809UDATopicWhy drop Table need 10 minutes?Dears:case 1. In batch time (22:00 ~ 09:00) batch jobs drop table used 1 second but after 09:00 user begin use the teradata database drop table used 10 minutes. I used PMON monitor these job no lo...
33821 Feb 2006 @ 11:59 PSTGreatSushantDatabaseTopicWhy the follwing query is getting lockedselect this.Job_Id as Job_Id0_, this.Label as Label0_, this.Description as Descript3_0_, this.User_Name as User_Name0_, this.Active_Ind as Active_Ind0_, this.Job_Event_Key as Job_Even6_0_, this.Gro...
33721 Feb 2006 @ 10:54 PSTdixonDatabaseTopicconfience showned in explainif the explain plan shows Index Join Confidence for a particular join condition is it better than High Confidence. and also interested to know that how exactly optimizer uses Index Join Confidence,...
33621 Feb 2006 @ 02:07 PSTTD_ArchDatabaseReplydescribe equivalentThese will describe the columns :HELP TABLE ;HELP VIEW ;
33521 Feb 2006 @ 01:16 PSTManoj_Kumar_ParmarToolsTopicBteq in Report formatHi, I am using the Bteq to export the report in a flat file in CSV format, but the o/p file is containing the SQL too as a first line, FYI:- The O/P is requied to contain headings, hence I am usin...
33420 Feb 2006 @ 02:41 PSTRenato DbaDatabaseReplyHow to get Teradata Version ?Hi,for the graphical environment, it goes in: Open Teradata Administrator > Help > Server Info.it is the same way of "select in dbcinfo"Regards.
33320 Feb 2006 @ 12:37 PSTstami27-2406DatabaseReplyStored ProceduresThanks Barry,I have found a Solution with the Dynamic SQL using the INSERT..SELECT statement.This is my Solution: SET hselt1='INSERT INTO sgia2708.AccLogTbl SELECT * FROM dbc.AccLogTbl where D...
33220 Feb 2006 @ 12:12 PSTBarry-1604DatabaseReplydescribe equivalentYou can use "help column":HELP COLUMN databasename.viewname.*;Thanks,Barry
33120 Feb 2006 @ 10:53 PSTdixonDatabaseTopicdescribe equivalentlike describe command, is there any command available in Teradata to know the columns stored in a viewfor e.g describe(in short desc) user_constraints;the above one will show all the columns availa...
33020 Feb 2006 @ 08:51 PSTBarry-1604DatabaseReplyStored ProceduresOne option is to join the two tables together in your first cursor:SELECT dbname AS db,tablename,count(*)FROM user_tables AS tbl, dbc.AccessLog AS acl where acl.databasename = tbl.dbnameAND acl...
32920 Feb 2006 @ 08:40 PSTBarry-1604DatabaseReplycan insert the derived table in Between clause?You can code this as a derived table, rather than putting a subquery in the WHERE clause.Try this:select * from date_exmp a ,(select max(date - 10) derived_dt from some_table) bwher...
32820 Feb 2006 @ 04:51 PSTkusumaTrainingReplyPreparation for the Teradata SQL examHi... I am Kusuma.I too am in need of sample practice papers of Teradata SQL as i am planning to take the test for this weekend...Can anyone send the quetions which they have attended for this...
32717 Feb 2006 @ 04:03 PSTstami27-2406DatabaseTopicStored ProceduresHi,I'm 'newbie' to Teradata but with some experience in Oracle PL/SQL.I would like to do samthing like this:(Read a User-Table with Table names and get some Information from DBC.AccessLog-Table)CRE...
32617 Feb 2006 @ 03:27 PSTSunil AgrawalDatabaseReplycan insert the derived table in Between clause?Why BETWEEN not working and comparison operator working is probably because of their syntax. Given below is thier syntax as given in Teradata manuals.1. Syntax of BETWEEN is: -expression1 BETWEEN e...
32517 Feb 2006 @ 10:40 PSThhDatabaseReplyNeed help on executing the BTEQ commands through PERL scriptIf your perl script can call out to an OS command, then you can execute bteq script. However, if you are just trying to get some result sets from teradata using bteq and export the results to file...
32417 Feb 2006 @ 10:10 PSTcceperoJobsTopicSenior level Teradata DBAMy client in Central NJ needs a Teradata DBA... This is a very prosperous company, with fantastic benefits and tons of growth potential.The candidate must be a senior level Teradata DBA and must b...
32317 Feb 2006 @ 08:35 PSTTDUser-781DatabaseReplyBTEQ ConnectionHi KM,when you log on via bteq, you have stg like this:.logon /,;suppose that your server's name is TDSERVER, you need to:1. write in the bteq file: .LOGON TDSERVER/,2. have in you hosts file an en...
32217 Feb 2006 @ 07:00 PSTKMDatabaseTopicBTEQ ConnectionI want to connect to a remote machine using BTEQ from my system (DEMO Teradata installed).The entry has been added to the hosts file , I can ping the machine using the alias .But while I try to con...
32116 Feb 2006 @ 08:12 PSTSunil AgrawalDatabaseReplyImport from MS XLS (EXCEL) file to teradata table.This is what Queryman help has to say on import rules: -The Import file must be a delimited text file containing data values that are separated from each other by the delimiter character specified ...
32016 Feb 2006 @ 07:54 PSTSunil AgrawalTrainingReplyHow many Certified Teradata MastersThanks for the information ! What is the name of your office and where it is? .. I am just kidding.I posted that question because i wanted to know if i complete the master certification, i will be ...
31916 Feb 2006 @ 06:21 PSTTDUser-781UDAReplyconfidence showned in explain planHi Dixondixon,the difference between these types of confidences is in the way the optimizer succeeds to estimate the dimension and the number of rows for each step of the query.No and Low confidenc...
31816 Feb 2006 @ 05:11 PSTdixonUDATopicconfidence showned in explain planHi i want to know that, what exactly the difference b/w NO, Low, High and Index Join Confidence showned in the explain plan. And how exactly we convert No Confidence to High confidence.Any Suggesti...

Pages