167 | 20 Jan 2006 @ 02:24 PST | terausr | UDA | Topic | SQL to update a column using another column | I need the logic/ansi sql to update a column, LP_Qty in my table using another col in the same table this is RF_Qty. RF_Qty gets updated everyday as the table refreshes everyday. But LP_Qty should ... |
166 | 20 Jan 2006 @ 01:19 PST | vinodG | Database | Topic | Parameterized queries vs using queries | 1.Can any one tell me the exact difference between Parameterized query and Using query.2.Can any one tell me the difference between P mode and S mode requests??ThanksVinod |
165 | 20 Jan 2006 @ 12:48 PST | TD_Arch | Tools | Reply | Update with subquery | Hi, The following is the equilavent Teradata query :Update GAM_EV from (Select b.hh_idFrom GAM_EV aLeft Outer Joinuse_0511 b On a.arng_id = b.arng_idLeft Outer Joinffw_0511 c On b.hh_id = c.hh_idWh... |
164 | 19 Jan 2006 @ 11:00 PST | Fred | Database | Reply | duplicate unique primary key error | GENERATED BY DEFAULT columns are not guaranteed to be unique anyway, but if you're sure that's what you want: create another table but specify that generated values START WITH a value beyond anythi... |
163 | 19 Jan 2006 @ 10:57 PST | Dennis Calkins | Database | Reply | Can a teradata database trigger/stored procedure call a java program or Executable? | UDF or Stored procedure? Teradata Stored procedures follow the ANSI standard and have a specific language as per the ANSI standard. Not C, Not Java, it is called Stored Procedure Language. It... |
162 | 19 Jan 2006 @ 10:43 PST | Fred | Database | Reply | PUBLIC User | If the user holds a right WITH GRANT OPTION, he is free to grant that right to ANY database, user, or role. And the creator of a table automatically is given rights WITH GRANT OPTION. |
161 | 19 Jan 2006 @ 10:22 PST | Raom | Jobs | Topic | Looking for Teradata Developer Position (contract/full-time) or TCRM opportunity | Hi,I have very good experience working on Teradata and TCRM for the last 6 years plus.I am looking for a change now. Interested in either full-time or contract position. Here is a link to my resume... |
160 | 19 Jan 2006 @ 05:55 PST | MChoo | Jobs | Topic | Teradata DBA Needed!! | Safeway, Inc. is seeking a Teradata DBA for our IT Technology Support Center, located in Phoenix, Arizona. Key Responsibilities include, but are not limited to:1) Work with Operations Support and E... |
159 | 19 Jan 2006 @ 04:05 PST | mustaqbasha | Database | Topic | Can a teradata database trigger/stored procedure call a java program or Executable? | Hi,My project requirement is that a Teradata database trigger/stored procedure needs to call java program to put data in a JMS queue. I wanted to know if it is possible to call executable or java p... |
158 | 19 Jan 2006 @ 04:01 PST | mustaqbasha | Jobs | Topic | Can a Teradata trigger/stored procedure call java progarm or executable? | ....... |
157 | 19 Jan 2006 @ 03:55 PST | Silas | Database | Topic | DW Database Designer III | Job Description : Transforms a Logical Data Model into a high performance Teradata database design according to business and technical requirements. Creates and tests table structures, indexes, vie... |
156 | 19 Jan 2006 @ 03:46 PST | sharad | Database | Topic | duplicate unique primary key error | Hi, I had to modify a column's width so i created a temporary table, with modified column width, and populated that temporary table through (insert into temp select * from original_table).Later I d... |
155 | 19 Jan 2006 @ 03:40 PST | BBR2 | Database | Reply | PUBLIC User | I wanted to limit the user to anything on PUBLIC database.I don't want user ABC to give GRANTS such as GRANT SELECT ON SANDBOX_DB.TABLE TO PUBLIC;User may have done this to provide implicit access ... |
154 | 19 Jan 2006 @ 12:37 PST | paloma.palacios@accenture.com | Database | Topic | BTEQSQL: .EXPORT FILE DATA | We would like create a bteq with the command ".EXPORT FILE DATA", but we must used the result of this execution bteqsql to the command ".IMPORT FILE".The result of this exported file must be separa... |
153 | 19 Jan 2006 @ 11:04 PST | Dana | Tools | Topic | Update with subquery | Is there a way using Teradata to update like in Oracle:update GAM_EVset hh_id = (select b.hh_id from GAM_EV aleft outer join use_0511 bon a.arng_id = b.arng_idleft outer join ff... |
152 | 19 Jan 2006 @ 11:04 PST | TEKRecruiter | Jobs | Topic | Teradata Developers Needed! | Company: TEKsystems, Inc. Location: Raleigh,North Carolina Category: Information Technology Jobs Rate: Based upon experience per Hour Job Type: Contract-to-Hire Information Technology Description:... |
151 | 19 Jan 2006 @ 10:27 PST | Rick-2304 | Database | Topic | PPI | I'm trying to use " insert into ... select * " to populate a table with PPI and am getting an error saying "Invalid Date Supplied for tablename.columnname" where tablename.columnname is the target ... |
150 | 19 Jan 2006 @ 08:00 PST | Manoj_Kumar_Parmar | Training | Topic | BTEQ sample scripts | Hi All,I have installed the Teradata Demo CD on my system and want to learn the BTEQ, can any body give the sample BTEQ scripts, or the link where I can get the ScriptsPlease, I need as early as po... |
149 | 19 Jan 2006 @ 06:24 PST | arunkumark2000@yahoo.com | Tools | Reply | import MultiLoad problem | Hi Valery,Guess this reply isn't quickest but i haven't logged in for a long time due to work. I faced a similar problem with multi loads with date, time and timestamp fields. Just remove the forma... |
148 | 19 Jan 2006 @ 01:01 PST | DEEPU | Database | Reply | renaming a column name.....? | I ASSUME THAT YOU ARE HAVING THE TABLE STRUCTURE LIKE:CUSTOMER...... MNTHX................. 1 Y................. 2 V................. 1Z................. 2 A... |
147 | 19 Jan 2006 @ 12:37 PST | TD_Arch | Database | Reply | PUBLIC User | Vinay,It should be REVOKE ALL ON ABC FROM PUBLIC; |
146 | 18 Jan 2006 @ 05:28 PST | BBR2 | Database | Topic | PUBLIC User | All,I need some information on GRANTS/REVOKE on system user PUBLIC.I believe if we grant any privilege to PUBLIC, all system wide users get that privileges implicitly.I also know that this is not t... |
145 | 18 Jan 2006 @ 12:42 PST | realpro | Jobs | Topic | Teradata data warehouse developer in Atlanta needed!! | Position Description: We requesting resumes for a contract position as a Teradata data warehouse developer to design and potentially lead development in a Mainframe-Teradata environment. The pos... |
144 | 18 Jan 2006 @ 11:21 PST | Krishan.R | Tools | Reply | Unlocking tables after fastload failure | Thanks Dennis, I will follow up with the other post.Krishnan.R |
143 | 18 Jan 2006 @ 11:20 PST | Krishan.R | Tools | Reply | Remove a table lock if fastload fails | Dennis,I have one quick question. Do we need to run the empty fastload script with same user id through a different session or we can use any available userid? An example: User report a fastload fa... |