#DateForumTypeThreadPost
4724 May 2006 @ 12:53 PDTDatabaseTopicComparing two tablesHi GurusI have two huge tables TABLE-A and TABLE-B (200 Million rows in each table)Now I am checking to see if both the table are identical or not.one way of testing it is sel * from table-Aminusse...
4618 May 2006 @ 03:31 PDTDatabaseReplyReverse string search (right to left)?Thanks!I am on V2R5
4518 May 2006 @ 10:59 PDTDatabaseReplyReverse string search (right to left)?Jeff,I was getting an error while executing the query you provided.failure 3706 syntax error: expected something between the beginning of the request and the 'with' keyword.I was using bteq.Thanks
4417 May 2006 @ 12:19 PDTUDAReplyAmp lock table overflow.Found the cause:Too many transactions running at the same time.
4317 May 2006 @ 12:18 PDTDatabaseReplyThe AMP Lock table has overflowedFound the cause:Too many transactions running at the same time.
4217 May 2006 @ 12:02 PDTUDATopicAmp lock table overflow.Hi All,I am using informatica to load data from MSSQL tables to Teradata.This is the error that I am getting while loading data into a few tableWRITER_1_*_1> WRT_8229 Database errors occurred: FnNa...
4117 May 2006 @ 12:01 PDTDatabaseTopicThe AMP Lock table has overflowedHi All,I am using informatica to load data from MSSQL tables to Teradata.This is the error that I am getting while loading data into a few tableWRITER_1_*_1> WRT_8229 Database errors occurred: FnNa...
4001 May 2006 @ 01:11 PDTDatabaseReplyYear and Month only fieldI am not sure if you can create a date field that will have only year and month yyyy/mm. (I never did that). If you create a date field it looks for a numeric value that convers to a valid date.sor...
3901 May 2006 @ 10:48 PDTDatabaseReplyYear and Month only fieldselect substr(current_date, 1, 7) year_mo 2006-05select substr(current_date (format 'yyyy/mm'), 1, 7) year_mo2006/05This will be a string.will this work?
3819 Apr 2006 @ 11:02 PDTDatabaseReplyNumber of weeks in a given month and yearhello Vinay!SELDistinct Year_Of_Calendar (TITLE 'YEAR'),Month_Of_Year (TITLE 'MONTH'),Week_Of_Month + 1 (TITLE 'WEEK') --,Calendar_Date (TITLE 'DATE')FROM sys_calendar.calendar WHERE year_of_calend...
3717 Apr 2006 @ 04:23 PDTDatabaseReplyNumber of weeks in a given month and yearIf you want to count the number of actual weeks that were in a month (i.e if the first of a month fall on wednesday this is considered a week of the month even though it did not have the whole 7 da...
3611 Apr 2006 @ 02:09 PDTUDAReplyMload delimited file with delimiter embedded in fieldMike,If the file is not huge I would do the follwing stepsif you are on a unix env.assume the delimiter is comma , and all the actual text commas are specified as ","replace all the "," s with a ch...
3510 Apr 2006 @ 06:55 PDTDatabaseReplyweird issue importing from excel to TD.....I guess the delimeter that is used as default in your import/export option is set to something other than comma.In queryman check this (click on the follwing menu option)Tools -> Options -> Export ...
3406 Apr 2006 @ 02:12 PDTToolsReplyTpump - Is blocking normal?This is a good way to do:alternative way to load the data:1. fastload file into empty staging table2. insert select via btequse the same PI for staging and destination tableand we did the following...
3328 Mar 2006 @ 08:24 PSTDatabaseReplyCurrent Month End DateTry thisselect cast(current_date as date) - (extract (day from cast(current_date as date)) - 1) + interval '1' month - 1I am sure there are many more methods. (some of our guru's will provide)The l...
3227 Mar 2006 @ 10:47 PSTDatabaseReplyNeed to identigy Primary key from a table using SelectThank you very much Dieter for the post.I am sorry for the answer i gave. Good to know this info.
3124 Mar 2006 @ 02:32 PSTDatabaseReplyNeed to identigy Primary key from a table using SelectRishab,There is nothing like a primary key in the tables.This is logical term, you will find this in sqlserver or oracle, but not in Teradata.you will find primary Index wich has nothing to do with...
3024 Mar 2006 @ 11:42 PSTDatabaseReplyURGENT:how to find col names and its values matching to my conditiontry thisselect a.*from dbc.columns a, dbc.tables bwhere a.databasename = b.databasenameand b.tablekind = 'V'and a.columnname like '%XYZ%'this will give all the rows from dbc.columns (databasename, ...
2924 Mar 2006 @ 11:18 PSTDatabaseReplysome problems about TD KEYWORD 'NOT IN'Matty,I dont think it is problem with the NOT IN clause.NOT IN is nothing but where value NOT EQUAL TO.so sel * from tablewhere num NOT IN (2,3)will take each value and see it is not equal to 2 and...
2824 Mar 2006 @ 10:56 PSTUDAReplyDefault spacesTbob That is true..I am not sure how some one else gets different results,I ran the same queries that you gave and got the results as expectedselect aKey, vText, CHARACTERS(vText) from devdata.fero...
2723 Mar 2006 @ 10:46 PSTDatabaseReplywhy does sql cannot pass systax?MONTH and YEAR are KEY WORDS you cannot use them as a field name or table name.There are many such KEY WORDS that you cannot use as table or column names.change the name to MONTH_NUM, or MONTH_VAL ...
2621 Mar 2006 @ 04:15 PSTDatabaseReplyRun an Update with a subselectThe query will fail with "illegal usage of alias name "because we cannot alias a table with the update clausethe aliasing should be done at the from clause.so update table1 awill failthis can be wr...
2520 Mar 2006 @ 07:00 PSTDatabaseReplymacroscreate macro samplemacro(variable1 int, variable2 char(3))as(Update table1 set col1 = col1 * :variable1where col2 = :variable2;);in the shell scriptexec samplemacro(2,'ABC')orexec samplemacro(varia...
2420 Mar 2006 @ 06:47 PSTDatabaseReplyselect first N recordsAre you trying to get just 10 records?if this is the case use sample (BUT THIS WILL GIVE ANY 10 records)select emp_name from employeesample 10;Are you trying to get the first 10 or last 10 based on...
2316 Mar 2006 @ 06:59 PSTConnectivityReplyHow to use Decimal(15,2)you have to increase the output lenght. leave the input as is decimal (15,2)so the largest number you can provide is 9999999999999.99 set the output: Decimal(18,2) {I guess 18 is the max that is ...

Pages