617 | 24 Mar 2006 @ 04:53 PST | kpothen | Jobs | Topic | Teradata DBA or Developer - Canada | I'm currently looking for a Teradata DBA or Developer for a contract position in Canada. Kim PothenP3, Inc.952/955-1890www.p-3-inc.comkim.pothen@p-3-inc.com |
616 | 24 Mar 2006 @ 03:14 PST | nudoam | Tools | Topic | Tpump - Is blocking normal? | We are attempting to performance tune some tables in our database. One of the items we are testing is join indexes.The current load utility for the table we are tuning is mload which cannot be use... |
615 | 24 Mar 2006 @ 02:40 PST | davli | Database | Reply | Identity Column Not Coming in a sequence. Need Suggestion. | thanks,now in Teradata V2R6 we cannot directly copy a table containing Identity column - is there any recommended workaround that would allow us to copy such a table in 2 or 3 steps? but still pre... |
614 | 24 Mar 2006 @ 02:32 PST | shaik.feroz@aaa-calif.com | Database | Reply | Need to identigy Primary key from a table using Select | Rishab,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... |
613 | 24 Mar 2006 @ 01:09 PST | rlaskar | 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... |
612 | 24 Mar 2006 @ 12:25 PST | Barry-1604 | Database | Reply | some problems about TD KEYWORD 'NOT IN' | If you want rows that have NULL in the Num column, you could also use COALESCE to do this:sel *from table_namewhere COALESCE(Num,-99999) not in (2,3)You just have to pick a value that you're not lo... |
611 | 24 Mar 2006 @ 12:19 PST | Barry-1604 | Database | Reply | URGENT:how to find col names and its values matching to my condition | To expand on the last reply, you can then format the results into a SELECT statement and execute all of those:select 'SELECT COUNT(*) FROM ' || b.databasename || '.' || b.tablename || ' WHER... |
610 | 24 Mar 2006 @ 12:14 PST | TimLind53 | Database | Topic | Reverse string search (right to left)? | How do do a reverse string search? I want to find the position of the last dash in the string starting on the right and scanning to the left. The number of dashes are unknown and some strings may h... |
609 | 24 Mar 2006 @ 11:42 PST | shaik.feroz@aaa-calif.com | Database | Reply | URGENT:how to find col names and its values matching to my condition | try 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, ... |
608 | 24 Mar 2006 @ 11:18 PST | shaik.feroz@aaa-calif.com | Database | Reply | some 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... |
607 | 24 Mar 2006 @ 10:56 PST | shaik.feroz@aaa-calif.com | UDA | Reply | Default spaces | Tbob 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... |
606 | 24 Mar 2006 @ 10:43 PST | RGlass | UDA | Reply | Default spaces | My understanding of Varchar has been that no trailing spaces where storedalso, and that Chars function was specially suited to Varchar for this reason.So I reran you queryresults: aKey vText Charac... |
605 | 24 Mar 2006 @ 07:10 PST | matty.jiang | Database | Topic | some problems about TD KEYWORD 'NOT IN' | image one col named 'Num' contains value domain (null, 1 ,2 , 3)if we writesel *from table_namewhere Num not in (2,3)we just can get answer set containing rows with (Num=1), losing rows having null... |
604 | 24 Mar 2006 @ 04:00 PST | shrikrishna | Database | Topic | URGENT:how to find col names and its values matching to my condition | Hi,We have 500+ views and i have to look for particular column name whcih contains string 'XYZ'.Column name may be like 'XYZ_CUST' or 'CUST_XYZ_CD' or anything containing 'XYZ' string.Also its poss... |
603 | 24 Mar 2006 @ 03:43 PST | Manoj_Kumar_Parmar | Tools | Topic | O/p file heading | Hi All, We are running Bteq from Mainframe and creating an Output file GDG base in a PDS of Mainframe. we need the the report should contains the headings, hence exporting the data with REPORT form... |
602 | 24 Mar 2006 @ 01:06 PST | TD_Arch | Database | Reply | Dates and Foreign Keys | You can considering partitioning your table on the data field. |
601 | 24 Mar 2006 @ 01:05 PST | TD_Arch | Database | Reply | Identity Column Not Coming in a sequence. Need Suggestion. | No, you dont have anything thats same as Sequence of Oracle. |
600 | 23 Mar 2006 @ 10:07 PST | matty.jiang | Database | Reply | why does sql cannot pass systax? | thanks a lot! |
599 | 23 Mar 2006 @ 06:27 PST | Fred | UDA | Reply | Default spaces | Not quite accurate, and a frequent misconception. Trimming trailing spaces from VARCHAR doesn't happen by magic - you need to be careful on the client side and/or use the TRIM function:CREATE TABLE... |
598 | 23 Mar 2006 @ 06:01 PST | Fred | Database | Reply | why does sql cannot pass systax? | Or use quotes to force the p****r to treat the token as an identifier rather than a keyword: "MONTH", "YEAR", etc. |
597 | 23 Mar 2006 @ 05:31 PST | Jonny | Database | Topic | command line | Does anyone know how to submit backups from a command line.I googled and saw the text below from Jose. I need to wait for the Arcmain return code. Is there any documentation on how to do this?Thank... |
596 | 23 Mar 2006 @ 02:40 PST | davli | Database | Reply | Identity Column Not Coming in a sequence. Need Suggestion. | hi,In Teradata, is there an equivalent of the Sequence feature such as in Oracle? Identity is good but currently you cannot copy table with identity column, also it's less than ideal that you have... |
595 | 23 Mar 2006 @ 10:46 PST | shaik.feroz@aaa-calif.com | Database | Reply | why 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 ... |
594 | 23 Mar 2006 @ 08:45 PST | dixon | Database | Topic | steps to work on TERADATA | Hi Allonce i installed teradata demo into my system. what is the next step. when, where and what i need to start to work Onto it. since bcoz i am new to TERADATA i need this basic information.Thanks. |
593 | 23 Mar 2006 @ 07:55 PST | matty.jiang | Database | Topic | why does sql cannot pass systax? | CREATE MULTISET TABLE ODS_TIME ( DATE_ID DATE NOT NULL, DAY_OF_WEEK VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC, MONTH VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC, ... |