342 | 22 Feb 2006 @ 06:08 PST | TD_Arch | Database | Reply | Why the follwing query is getting locked | Not sure as to what is the question that you want to ask. Can you elaborate? |
341 | 22 Feb 2006 @ 02:45 PST | Shefali | UDA | Topic | find out the number of nodes in a teradata architecture | How 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? |
340 | 22 Feb 2006 @ 01:07 PST | Manoj_Kumar_Parmar | Tools | Reply | Bteq in Report format | I 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... |
339 | 21 Feb 2006 @ 10:20 PST | s90570809 | UDA | Topic | Why 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... |
338 | 21 Feb 2006 @ 11:59 PST | GreatSushant | Database | Topic | Why the follwing query is getting locked | select 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... |
337 | 21 Feb 2006 @ 10:54 PST | dixon | Database | Topic | confience showned in explain | if 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,... |
336 | 21 Feb 2006 @ 02:07 PST | TD_Arch | Database | Reply | describe equivalent | These will describe the columns :HELP TABLE ;HELP VIEW ; |
335 | 21 Feb 2006 @ 01:16 PST | Manoj_Kumar_Parmar | Tools | Topic | Bteq in Report format | Hi, 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... |
334 | 20 Feb 2006 @ 02:41 PST | Renato Dba | Database | Reply | How 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. |
333 | 20 Feb 2006 @ 12:37 PST | stami27-2406 | Database | Reply | Stored Procedures | Thanks 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... |
332 | 20 Feb 2006 @ 12:12 PST | Barry-1604 | Database | Reply | describe equivalent | You can use "help column":HELP COLUMN databasename.viewname.*;Thanks,Barry |
331 | 20 Feb 2006 @ 10:53 PST | dixon | Database | Topic | describe equivalent | like 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... |
330 | 20 Feb 2006 @ 08:51 PST | Barry-1604 | Database | Reply | Stored Procedures | One 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... |
329 | 20 Feb 2006 @ 08:40 PST | Barry-1604 | Database | Reply | can 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... |
328 | 20 Feb 2006 @ 04:51 PST | kusuma | Training | Reply | Preparation for the Teradata SQL exam | Hi... 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... |
327 | 17 Feb 2006 @ 04:03 PST | stami27-2406 | Database | Topic | Stored Procedures | Hi,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... |
326 | 17 Feb 2006 @ 03:27 PST | Sunil Agrawal | Database | Reply | can 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... |
325 | 17 Feb 2006 @ 10:40 PST | hh | Database | Reply | Need help on executing the BTEQ commands through PERL script | If 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... |
324 | 17 Feb 2006 @ 10:10 PST | ccepero | Jobs | Topic | Senior level Teradata DBA | My 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... |
323 | 17 Feb 2006 @ 08:35 PST | TDUser-781 | Database | Reply | BTEQ Connection | Hi 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... |
322 | 17 Feb 2006 @ 07:00 PST | KM | Database | Topic | BTEQ Connection | I 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... |
321 | 16 Feb 2006 @ 08:12 PST | Sunil Agrawal | Database | Reply | Import 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 ... |
320 | 16 Feb 2006 @ 07:54 PST | Sunil Agrawal | Training | Reply | How many Certified Teradata Masters | Thanks 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 ... |
319 | 16 Feb 2006 @ 06:21 PST | TDUser-781 | UDA | Reply | confidence showned in explain plan | Hi 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... |
318 | 16 Feb 2006 @ 05:11 PST | dixon | UDA | Topic | confidence showned in explain plan | Hi 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... |