92 | 05 Jan 2006 @ 10:47 PST | Padmini-2242 | Database | Topic | Login to Teradat SQL assistant | I am new to Teradata and I am trying to connect to sql assistant. I got the ODBC set up but when I try to login it gives an error message "160 specified driver could not be loaded system error 126... |
91 | 05 Jan 2006 @ 06:20 PST | tfader | Database | Reply | Cancel online transaction recovery after break big delete operation | Thank You so much for Your answer, butunfortunatenly, my version is 2 release 4 (FOUR) ! It's any posibility to break transaction recovery in this one. What about DB startup parameters, TPA boot mo... |
90 | 05 Jan 2006 @ 05:50 PST | gajula | Tools | Topic | About ETL process using Teradata utilities | hi, I am working on Informatica. I would like to know about the ETL process in Teradata using BTEQ,FastLoad,MultiLoad and FastExport. which one is used more in the process and how.And how to connec... |
89 | 04 Jan 2006 @ 09:41 PST | esexton@ebay.com | Connectivity | Topic | tdodbc.03.03.00.13: core dump Solari 5.8 | Hello-I upgraded tdodbc from 03.03.00.00 to 03.03.00.13, and when running an odbc connection (samples/C/adhoc), I receive a core dump.When I rollback to 03.03.00.00, everything works fine.Could you... |
88 | 04 Jan 2006 @ 03:42 PST | Jim Chapman | Database | Reply | Cancel online transaction recovery after break big delete operation | You can use the CANCEL ROLLBACK ON TABLE command of the Recovery Manager utility. I believe this is available in 5.1 and later releases. If you use this command, the table is marked unusable, and... |
87 | 04 Jan 2006 @ 02:46 PST | tfader | Database | Topic | Cancel online transaction recovery after break big delete operation | I'm looking for any issues for canceling online transaction recovery when TPA starts.I cannot drop, truncate or restore table because is locked by transaction recovery. The table is with no fallbac... |
86 | 04 Jan 2006 @ 11:49 PST | DGiabbai | Database | Reply | String Replacement | The following stored procedure performs the task of a Replace function for character data.In this form it can be used only from within another stored procedure.REPLACE PROCEDURE SysDBA.StringReplac... |
85 | 04 Jan 2006 @ 08:51 PST | BBR2 | Database | Reply | String Replacement | Akhil,Crude as "Can be improved further"Vinay |
84 | 04 Jan 2006 @ 08:15 PST | TDUser-781 | Training | Reply | Is Teradata Certified Professional V2R6 (NR0-011) available to be taken? | Hi, from the website you can find that it's TCPP v2r5.Bye,TDUser |
83 | 04 Jan 2006 @ 06:57 PST | Meenakshi | Training | Topic | Is Teradata Certified Professional V2R6 (NR0-011) available to be taken? | Hi,Can anyone please tell me what's the latest version in NR0-011? Is it TCPP V2R5 or V2R6?Regards,Meena |
82 | 04 Jan 2006 @ 04:49 PST | akhil.bansal@gmail.com | Database | Reply | String Replacement | Hi Vinay, It works fine. thanks.But what do you mean by crude form ? |
81 | 03 Jan 2006 @ 06:09 PST | pattit | Jobs | Topic | 3+ month contract in San Francisco for C# & Teradata Developer | Our financial client has an immediate opening for a C#, .net with Teradata Developer.NO H-1Bs or 3rd parties for this position!!!!Preference to candidates local to the SF Bay Area!!!Job Description... |
80 | 03 Jan 2006 @ 03:48 PST | Jim Chapman | Database | Reply | Gateway ports | All Teradata clients connect to TCP port 1025. That is the only port that you should need to forward through your firewall. |
79 | 03 Jan 2006 @ 02:43 PST | BBR2 | Database | Reply | String Replacement | I came up w/t a Macro that can accomplish this.You may want to use the same logic in your procedure or SQL.REPLACE MACRO SYSDBA.REPLACE_STR ( SEARCH_STR VARCHAR(400), CHNG_STR VARCHAR(400)) AS (SEL... |
78 | 03 Jan 2006 @ 01:32 PST | GlotelInc | Jobs | Topic | Needed: Teradata Data Warehouse DBA in New Jersey | Hello,One of my Clients in Central/North Jersey needs a Teradata Data Warehouse DBA. This is a PERMANENT position with a great salary! Required:Sr. Level Teradata DBA, proficient in Teradata tool... |
77 | 03 Jan 2006 @ 11:53 PST | Dennis Calkins | Database | Reply | table size without indexes | You can run ferret from Teradata Manager. |
76 | 03 Jan 2006 @ 09:35 PST | surmik | Tools | Topic | FastLoad vs NL Character | I have a text file with records I want to import into Teradata with FastLoad. Columns are separated with a "|" character. There is a problem with a 'Comments' column containing rows with a new line... |
75 | 03 Jan 2006 @ 09:23 PST | Nytewynd | Database | Reply | Passing the value for an IN clause to a stored procedure. | Very helpful. Tagging for later. |
74 | 03 Jan 2006 @ 04:43 PST | ANGEL | Tools | Topic | .DISPLAY in MLOAD | Hi,I have a file which contain date fields. There is a possibility in which one of the fields can be blank so i am using .DISPLAY command to output the message to MVS. But it gives the error "End o... |
73 | 03 Jan 2006 @ 04:28 PST | surmik | Database | Reply | String Replacement | Or you can:create table your_table2 as your_table with no data;insert into your_table2 select substring(your_field FROM 1 FOR INDEX(your_field,' and') -1) || ' or ' || substring(your_field FROM IN... |
72 | 03 Jan 2006 @ 03:27 PST | phil1212 | Database | Reply | table size without indexes | Ok thanks.I need just an sql query, only dba have the tools gives in the first answer.For the second, are you sure this doesn't include indexes size ? |
71 | 03 Jan 2006 @ 01:27 PST | XTUPIE | Tools | Reply | FastLoad Checkpoint | HiJust a quick tip, if your Checkpoint is set to below 60 it defaults to minutes not records!So you might not want a checkpoint every 2 minutes, would you?Rememebr Checkpoint has got to do with fal... |
70 | 03 Jan 2006 @ 01:22 PST | XTUPIE | Tools | Reply | SQL Query - DBQL table | HiJust remember to occasionally clean out those DBQL tables in DBC, it is possible to fill your DBC and run out of space if you are not careful. I suggest that you create a copy of them in another ... |
69 | 03 Jan 2006 @ 01:09 PST | XTUPIE | Database | Reply | table size without indexes | HiI generally use the following query to determine table sizes.select databasename, tablename, sum(currentperm)from dbc.tablesize where databasename = 'DBA' and tablename = 'testing' group by... |
68 | 03 Jan 2006 @ 01:02 PST | XTUPIE | Database | Reply | String Replacement | HiI agree, I have tried using a normal Update "update dba.testing set linea = 'or' where linea like '%and%' ;"But one gets a duplicate error. You can do this with a program or a UDF.Divvy |