18 | 14 Jun 2007 @ 11:20 PDT | Tools | Topic | Connect two different teradata box and retreive data | Hi,I was trying to figure out how to retrieve data from two different teradata boxes. For example, one table (A) is in development database and the same table (A) is in test database. I need to do ... |
17 | 14 Jun 2007 @ 09:01 PDT | Database | Topic | Connect two different teradata box and retreive data | Hi,I was trying to figure out how to retrieve data from two different teradata boxes. For example, one table (A) is in development database and the same table (A) is in test database. I need to do ... |
16 | 20 Feb 2007 @ 02:34 PST | Database | Topic | Need to delete duplicate records from table | Hi,I have many duplicate records in a table. Need to remove or delete these duplicate records from table. So that only one unique record exists. Thanks,rlaskar |
15 | 28 Jun 2006 @ 02:33 PDT | Database | Reply | Need to run many SQL's at one shot even if error occurs inbetween | Let's remove UNION from end of all SQL's. It's just that I tried to execute all SQL's and output to a single file instead of multiple output files for all SQL.Thanks Deiter.rlaskar |
14 | 28 Jun 2006 @ 01:51 PDT | Database | Topic | Need to run many SQL's at one shot even if error occurs inbetween | Hi,I need help in executing SQL's. I have some say 50 SQL's combined using UNION ALL. Now when we ran the SQL's at one shot, it stops when it found error like "Column/table does not exist for few S... |
13 | 19 May 2006 @ 05:57 PDT | UDA | Reply | SQL to retrieve datatype of a column | Thanks. |
12 | 18 May 2006 @ 09:46 PDT | UDA | Topic | SQL to retrieve datatype of a column | Hi,I was trying to identify the datatype of a column using teradata SQL. While TYPE returns datatype of the column for all rows. So if it's 1000's of record in a column then using TYPE for that col... |
11 | 01 May 2006 @ 12:08 PDT | UDA | Topic | Need to fire 1000 different SQL statements and verify results automatically | Hi,I have some 1000 SQL statements which I have written based on different logic. Now I need to run those scripts and verify results againse DB. I can manually run all scripts and verify the result... |
10 | 26 Apr 2006 @ 05:20 PDT | UDA | Topic | SQL syntax to check values in a group | Hi All,I am trying to verify a table group by say ss_id, and say it returns 10 rows (same ss_id). Now I am trying to verify whether 10th row value > 9th row, 9th row > 8th row ...I need some feedba... |
9 | 31 Mar 2006 @ 03:24 PST | UDA | Reply | NEED TO CHECK FORMAT TO 'YYYY-MM-DD' | Thanks. But it's still not working for me.The column that i have is of type varchar(20) and it have value as "ABCDEFGH".If I ran the above query it returns me all the rows from the table.Say Field ... |
8 | 31 Mar 2006 @ 12:16 PST | UDA | Topic | NEED TO CHECK FORMAT TO 'YYYY-MM-DD' | Hi,I have a column which is of type varchar(20) and which holds date value. Now i need to verify whether the data in the column is having correct date format.Date format should be YYYY-MM-DD.Thanks... |
7 | 28 Mar 2006 @ 02:41 PST | Database | Topic | Current Month End Date | Hi All,I was trying to identify current month end date. Let me know any sql syntax toidentify the current month end date.Thanks,rlaskar |
6 | 24 Mar 2006 @ 01:09 PST | Database | Topic | Need to identigy Primary key from a table using Select | Hi,I was trying to identify the Primary keys from a table. I can doshow table tablename or help table tablename which would give me details about whole tables. Is it some command available to displ... |
5 | 22 Mar 2006 @ 01:26 PST | UDA | Topic | Syntax to create surrogate keys in a table | I was trying to create a table with surrogate keys defined. |
4 | 22 Mar 2006 @ 12:09 PST | Database | Topic | Syntax to Create a surrogate key | Need to create a table with surrogate keys. |
3 | 17 Mar 2006 @ 11:06 PST | Database | Reply | Define Teradata? | http://www.info.ncr.com/Teradata/eTeradata-BrowseBy.cfm?page=Teradata%20DatabaseYou will find lot of document on teradataThanks,rlaskar |
2 | 17 Mar 2006 @ 11:02 PST | Database | Topic | How to validate date field in dd/mm/yyyy or yyyy/mm/dd format ? | I was trying to write a SQL which would validate a date column field. The validation would be whether the rows have data in 'dd/mm/yyyy' or 'mm/dd/yyyy' format. |
1 | 10 Mar 2006 @ 11:20 PST | Database | Topic | Need syntax on Dynamic SQL | I am trying to write a SQL which would generate SQL based on table name and column provided. The SQL should ask for tname and colname and after that it would generate a SQL. Sample of the SQL would... |