892 | 09 May 2006 @ 02:24 PDT | Nytewynd | UDA | Reply | Importing Data from Teradata to Oracle | You can set up a Oracle heterogeneous service to connect to teradata through an ODBC connection, and then create a DBLink right to Teradata.You can use the DBMS_HS_PASSTHROUGH functions to run nati... |
891 | 08 May 2006 @ 03:23 PDT | Sunil Agrawal | Database | Reply | Something in Teradat as is CONNECT BY in Oracle | select item , sales , sum(sales) over () total_sum , sum(sales) over (rows unbounded preceding) as cum_sum , (cum_sum-sales)*100/total_sum as start_cum_perc , (case when start_c... |
890 | 08 May 2006 @ 09:40 PDT | Nits | Database | Topic | Something in Teradat as is CONNECT BY in Oracle | I am working on the design phase of a project. The coding for this project needs to be done in Teradata. The logic is as below: Item Sales Cumulative Percentage Service level Classificatio... |
889 | 08 May 2006 @ 04:01 PDT | TDUser-781 | Tools | Reply | Multiload pre-Begin Mload Target Table DELETE ALL | Hi bc,dropping/deleting tables or doing housekeeping sql before the .begin mload statement is permitted in a MLD thanks to the support environment that is a special environment that allows you to e... |
888 | 06 May 2006 @ 02:47 PDT | Fred | Tools | Reply | Importing with BTEQ | If you are using VARTEXT format for the input file, all the fields in the USING clause should be declared as VARCHAR, with the max allowable length. You may need to use explicit FORMAT, CAST, etc. ... |
887 | 06 May 2006 @ 01:00 PDT | FrontierBill | Tools | Topic | Multiload pre-Begin Mload Target Table DELETE ALL | I recently ran across an MLOAD Script that, prior to the BEGIN MLOAD, contained the standard set of DROP Work/ET/UV table statements along with anDELETE FROM TABLENAME ALL; all inside the Mload sc... |
886 | 05 May 2006 @ 08:40 PDT | duwest73 | Tools | Reply | Importing with BTEQ | Well, since I wasn't having much luck I'm now trying merely to insert a null string with bteq. However, I'm doing something wrong, because even that's not working.All I'm trying to do is use one bt... |
885 | 05 May 2006 @ 04:51 PDT | Vincent Gabrielli | Tools | Reply | delete primary index | Thanks to all the replies, I have corrected the SQL script accordingly |
884 | 05 May 2006 @ 02:56 PDT | BBR2 | Tools | Reply | delete primary index | You can change PI definition of table if the table is empty.You may want to refer SQL Reference: DDL for exact symantics.Vinay |
883 | 05 May 2006 @ 02:17 PDT | DEEPU | UDA | Reply | SQL syntax to check values in a group | Hi,Look for the "PREV_VALUE" & "RESULT" logic in below query.SEL SS_ID, CURR_VALUE, (SUM(CURR_VALUE)OVER(ROWS 1 PRECEDING) - CURR_VALUE) "PREV_VALUE" ,(CASE WHEN CURR_VALUE > PREV_VALUE THEN 'TRUE'... |
882 | 05 May 2006 @ 01:02 PDT | DEEPU | UDA | Reply | Fastexport help | Remove 'TRIM' from TRIM(Policy_Insurance_Score_Cd) in your Group By.GROUP BYTRIM(State_Cd) ,TRIM(Company_Cd) ,TRIM(SUBSTR(Line_Cd,1,1)) ,TRIM(Line_Of_business_Cd) ,TRIM(Policy_Form_Cd) ,TRIM(Policy... |
881 | 05 May 2006 @ 04:34 PDT | TDUser-781 | UDA | Reply | How to Create Flat File | Hi, if you have Teradata RDBMS installed somewhere, on the server you'll find the executable files to run. Usually you find them in Program Files\Ncr\Teradata Client\bin\ directory.You may execute ... |
880 | 05 May 2006 @ 12:48 PDT | Nits | UDA | Reply | How to Create Flat File | Please tell me where to get FastExport and BTEQ utilities.These are freewares or come as part of Teradata.We are currently using Teradata client version.RegardsNitin Bajaj |
879 | 04 May 2006 @ 09:46 PDT | kgraham@glotel.com | UDA | Topic | Seeking Data Warehousing Consultants for exciting careeer opportunities | Data Warehouse ConsultantNumerous positions availableCBD BasedGlobal Consultancy FirmThis is a superb chance to join a respected Market Leader and develop your consulting skills and progress in you... |
878 | 04 May 2006 @ 05:06 PDT | Fred | Tools | Reply | delete primary index | The Primary Index is part of the table structure and not a separate object. You'll have to do something like create a new table, copy (INSERT/SELECT) the data, drop the old, rename. |
877 | 04 May 2006 @ 04:50 PDT | Vincent Gabrielli | Tools | Topic | delete primary index | Hi trying to delete the primary index of a file that is created daily. However the index created is not using the right field and I would like to delete and recreate using a new field. we are us... |
876 | 04 May 2006 @ 02:53 PDT | jfoxpearson | Jobs | Topic | Trillium / Teradata Architect - Developer Position in Mpls. St. Paul | I am looking for a consultant for a client in MN. I am interested in talking to 1099, hourly or salaried individuals.The current project will last 6-9 months.Our firm is a solutions provider with a... |
875 | 04 May 2006 @ 10:46 PDT | Jim Chapman | Tools | Reply | How to display all columns with betq command | Use the ".set foldline on" command to allow BTEQ to fold a row across multiple lines. For a prettier format, also ".set sidetitles on". |
874 | 04 May 2006 @ 10:35 PDT | Jim Chapman | Database | Reply | How to find a lost password for a user | By design, passwords are stored in DBC.DBase using a one-way encryption method. If you forget a password, consider it gone forever. |
873 | 04 May 2006 @ 08:49 PDT | DGiabbai | UDA | Reply | How to Create Flat File | You could replicate the logic of the following example bteq script (which outputs the file as a CSV formatted file):.SET WIDTH 65531;.LOGON demo/dbc,dbc;.OS DEL /Q EventLog.txt.EXPORT DATA FILE=Eve... |
872 | 04 May 2006 @ 08:48 PDT | TDUser-781 | UDA | Reply | How to Create Flat File | Hi Nits,you can create a flat file using fastexport utility. at this file:.logtable |
871 | 04 May 2006 @ 07:50 PDT | Nits | UDA | Topic | How to Create Flat File | Hi,Please give inputs to create Flat File in Teradata containing the result set of a query. |
870 | 04 May 2006 @ 07:32 PDT | Pervez Ahmed | Database | Reply | MultiLoad utility using delimited file. | ThanksThis worked. |
869 | 04 May 2006 @ 07:13 PDT | TDUser-781 | Database | Reply | How to find a lost password for a user | Well, if you were on your personal server.... what about applying the best "stop and restart solution"? That, in your case, would be uninstall and install the RDBMS again? :-) Joking aside, I don'... |
868 | 04 May 2006 @ 06:59 PDT | DGiabbai | Database | Reply | drop database ? | You have to drop databases starting from the leafs.Here is a query that automatically generates all the needed SQL statements for you, in the correct sequence. You'll have then to manually run the ... |