All forum activity

#DateUserForumTypeThreadPost
84202 May 2006 @ 05:14 PDTGlotelIncJobsTopicTeradata Opportunity in New JerseyHello,One of my Clients in Central/North Jersey has a permanent job opportunity for a Teradata Data Warehouse DBA. This is a PERMANENT position with a great salary at an excellent client site! Requ...
84102 May 2006 @ 03:22 PDTSathya ChristyDatabaseReplyUpdating a particular character in a fieldHi All... Its a urgent requirement.... Is there any function to do this ???????????????Can some one help please ....
84002 May 2006 @ 02:29 PDTTDAT123DatabaseReplyYear and Month only fieldThanks Sunil..The requirement is to have a Date field with only Month and Year data (YYYY/MM) and to retrieve it in the same format. I know that it can be done in Teradata as follows:Create table(T...
83902 May 2006 @ 01:06 PDTSunil AgrawalDatabaseReplySubstr causing problem-killing query performanceYou might want to define col3 as value order NUSI for improving the performance.But, it is a good practice to keep the substring data substr(col3,10,2) and substr(col3,15,2) as separate columns in ...
83802 May 2006 @ 12:45 PDTSunil AgrawalDatabaseReplyYear and Month only fieldPlease write down your requirement for this field, how/where you want to use this field. There can be many solutions and we can find the best solution best on requirements.Thanks.
83702 May 2006 @ 12:01 PDTSathya ChristyDatabaseTopicUpdating a particular character in a fieldHi All,Can some one help : I have to replace all commas ',' in address field in my table and with space ' ' .The address field has more than one commas.i've tried using Index function where i can...
83602 May 2006 @ 09:16 PDTTDAT123DatabaseReplyYear and Month only fieldThanks..that works. Do you know how to extract 'Year' or 'Month' out of this date field ?Looks like regular EXTRACT function doesn't work with this.
83502 May 2006 @ 09:05 PDTTDUser-781DatabaseReplyError Code 2652. Operation Not allowed.You may use an empty file if the first fastload does't perform the "end loading" command.In this case its RC is = 4, that is FastLoad paused. this is a very good way to load several files into an e...
83402 May 2006 @ 08:51 PDTPervez AhmedDatabaseReplyError Code 2652. Operation Not allowed.Thanks for your response. I will try to post the log later. I have to find out where the log is maintained. There was two other suggestions. 1. To run the scripts using an empty data file. I tried ...
83302 May 2006 @ 08:22 PDTTDUser-781DatabaseReplyError Code 2652. Operation Not allowed.Hi,this means that the fastload RD isn't 0. You must have a look to the log and understand what is your problem.Could you please post the fld log?However, in most of cases if one FLD job ends with ...
83202 May 2006 @ 07:52 PDTPervez AhmedDatabaseTopicError Code 2652. Operation Not allowed.I have installed TERADATA from the demo CD into my windows 2000 work station. I have created a table called AHMED.FAMILY. I used FASTLOAD utility to insert two rows from a comma delimited file. To ...
83102 May 2006 @ 05:05 PDTTDUser-781DatabaseReplyhow to get the primary indexes of all the tables in a user using dbc tablesOoopsss, sorry, I was wrong in posting the sql; you are asking about PI and not only tables.... :-) !Well, you may query dbc.indicesx view and look at indextype = 'p'.Bye!TDUser
83002 May 2006 @ 04:34 PDTTDUser-781DatabaseReplyhow to get the primary indexes of all the tables in a user using dbc tablesTry this:select *from dbc.tableswhere databasename = '';If you query directly tablesx view, you'll get only the tables and views of the username you are logged in with.Hope this helps,Bye,TDUser
82901 May 2006 @ 04:12 PDTSunil AgrawalDatabaseReplyYear and Month only fieldYou can define your column as INTERVAL type, example below: -Create Table xyz( ... ,cre_month interval year(4) to month ,...);Insert into xyz( ... ,cre_month ,...)values( ... ,'2006-02' ,...);H...
82801 May 2006 @ 03:54 PDTSunil AgrawalDatabaseTopicBenefit of collect stats on non-index columnsI was wondering what is the benefit of collecting statistics on Non-Primary Index and Non-Secondary Index columns. Isn't the search on this column always full table scan even if stats is collected ...
82701 May 2006 @ 03:45 PDTdak4sumitDatabaseTopichow to get the primary indexes of all the tables in a user using dbc tableshow to get the primary indexes of all the tables in a user using dbc tables
82601 May 2006 @ 03:17 PDTMsMaggieJobsTopicTeradata Professional needed in Dallas, TXInnovative Systems Group is looking for several Teradata specialists with a background in ETL development. Candidates would need to have a strong SQL background with excellent communications and s...
82501 May 2006 @ 01:11 PDTshaik.feroz@aaa-calif.comDatabaseReplyYear 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...
82401 May 2006 @ 12:08 PDTrlaskarUDATopicNeed 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...
82301 May 2006 @ 10:59 PDTTDAT123DatabaseReplyYear and Month only fieldBut the issue I am facing is while CREATING a table with 'Year/Month (YYYY/MM)' only field. Or in other words, it is possible to create a 'YEAR and MONTH only date field' in a Teradata table ? - Maku.
82201 May 2006 @ 10:48 PDTshaik.feroz@aaa-calif.comDatabaseReplyYear 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?
82101 May 2006 @ 10:28 PDTTDAT123DatabaseTopicYear and Month only fieldCould someone share some idea on how to create a 'YEAR/MONTH' only field in a teradata table? I tried it using the option 'TEST_DT DATE FORMAT 'YYYY/MM' ', but the 'DAY' portion still gets stored a...
82030 Apr 2006 @ 06:10 PDTAnuTrainingTopicTeradata Basic Certification HelpHiI'm a beginner to Teradata and would like to take the Basic level 1 v2r5 certification.I've just got into project involving teradata. I've got a few study materials and would be very grateful if...
81929 Apr 2006 @ 10:11 PDTDGiabbaiToolsReplyBTEQBTEQ is part of the Teradata Tools and Utilities. Depending on the version of the RDBMS, ask for TTU 7.x (for TD V2R5.x) or TTU 8.x (for TDv2R6.x)
81829 Apr 2006 @ 10:03 PDTDGiabbaiDatabaseReplyextract text string from text field in columnIn the first statement you misplaced "-1"Wrong : select trim(substr(C2T_EMAIL_ADDR_TXT,1,index(C2T_EMAIL_ADDR_TXT, '@'))-1) from dvu_111.t_c2t_empCorrect: select trim(substr(C2T_EMAIL_ADDR_TXT,1,i...

Pages