#DateForumTypeThreadPost
1814 Jun 2007 @ 11:20 PDTToolsTopicConnect two different teradata box and retreive dataHi,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 ...
1714 Jun 2007 @ 09:01 PDTDatabaseTopicConnect two different teradata box and retreive dataHi,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 ...
1620 Feb 2007 @ 02:34 PSTDatabaseTopicNeed to delete duplicate records from tableHi,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
1528 Jun 2006 @ 02:33 PDTDatabaseReplyNeed to run many SQL's at one shot even if error occurs inbetweenLet'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
1428 Jun 2006 @ 01:51 PDTDatabaseTopicNeed to run many SQL's at one shot even if error occurs inbetweenHi,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...
1319 May 2006 @ 05:57 PDTUDAReplySQL to retrieve datatype of a columnThanks.
1218 May 2006 @ 09:46 PDTUDATopicSQL to retrieve datatype of a columnHi,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...
1101 May 2006 @ 12:08 PDTUDATopicNeed to fire 1000 different SQL statements and verify results automaticallyHi,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...
1026 Apr 2006 @ 05:20 PDTUDATopicSQL syntax to check values in a groupHi 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...
931 Mar 2006 @ 03:24 PSTUDAReplyNEED 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 ...
831 Mar 2006 @ 12:16 PSTUDATopicNEED 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...
728 Mar 2006 @ 02:41 PSTDatabaseTopicCurrent Month End DateHi All,I was trying to identify current month end date. Let me know any sql syntax toidentify the current month end date.Thanks,rlaskar
624 Mar 2006 @ 01:09 PSTDatabaseTopicNeed to identigy Primary key from a table using SelectHi,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...
522 Mar 2006 @ 01:26 PSTUDATopicSyntax to create surrogate keys in a tableI was trying to create a table with surrogate keys defined.
422 Mar 2006 @ 12:09 PSTDatabaseTopicSyntax to Create a surrogate keyNeed to create a table with surrogate keys.
317 Mar 2006 @ 11:06 PSTDatabaseReplyDefine Teradata?http://www.info.ncr.com/Teradata/eTeradata-BrowseBy.cfm?page=Teradata%20DatabaseYou will find lot of document on teradataThanks,rlaskar
217 Mar 2006 @ 11:02 PSTDatabaseTopicHow 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.
110 Mar 2006 @ 11:20 PSTDatabaseTopicNeed syntax on Dynamic SQLI 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...