1442 | 20 Jul 2006 @ 01:49 PDT | Fred | UDA | Reply | Could I stop an abort session? | CANCEL ROLLBACK ON TABLE is not available prior to V2R5.1. |
1441 | 20 Jul 2006 @ 01:19 PDT | Fred | Connectivity | Reply | Trying to set up ODBC connection | The driver download file is actually a self-extracting "bundle" that includes the appropriate TeraGSS and TDICU as well as the driver itself. |
1440 | 20 Jul 2006 @ 10:28 PDT | j355ga | Database | Reply | "Select Into" can't be used in teradata? | SELECT INTO is supported in Teradata stored procedures. V2R5 and above. |
1439 | 20 Jul 2006 @ 04:34 PDT | Uwe Posselt | Connectivity | Reply | Trying to set up ODBC connection | Hi,I have the same problem. The newest ODBC driver (6/28/2006 11:25:48 AM) can be downloaded at "http://www.teradata.com/t/go.aspx/index.html?id=152251"But where I can download the "Teradata Generi... |
1438 | 20 Jul 2006 @ 01:27 PDT | John Mac | UDA | Reply | Could I stop an abort session? | oops..Alfredo,Do you have a friendly DBA around with access to the database window ?That's where you'll need to start the recovery manager.In the Supervisor screen of the database window, type 'sta... |
1437 | 20 Jul 2006 @ 01:25 PDT | John Mac | UDA | Reply | Could I stop an abort session? | Alfredo,Do you have a friendly DBA around with access to the database window ?That's where you'll need to start the recovery manager.In the Supervisor screen of the database window, type (you'll n... |
1436 | 20 Jul 2006 @ 12:10 PDT | Alfredo | UDA | Reply | Could I stop an abort session? | Yes I want to do that.I have a backup.Could you tell me how to do it?My version of teradata is VERSION 05.00.02.31RELEASE V2R.05.00.02.28Thank you |
1435 | 19 Jul 2006 @ 11:20 PDT | John Mac | UDA | Reply | Could I stop an abort session? | Alfredo,If you mean that you have an aborting session and you'd like to kill the abort process, then yes, you can by using the CANCEL ROLLBACK option in Recovery Manager.Bear in mind though, you'll... |
1434 | 19 Jul 2006 @ 07:38 PDT | j355ga | Database | Topic | risk associated with dynamic sql | Can anyone relate any risks they have encountered using dynamic sql in Teradata stored procedures?Rumors that I have head (but have not seen any documentation on):a) it is policy to not grant perm ... |
1433 | 19 Jul 2006 @ 04:34 PDT | Alfredo | UDA | Topic | Could I stop an abort session? | I have an abort session of a delete job.Are there some way to stop the abort session? |
1432 | 19 Jul 2006 @ 04:32 PDT | Alfredo | UDA | Topic | Problem with delte in an abort sesion | HiI hope that somebody could help me!!!I execute a delete sentence in a table with a lot of information, this table has 4 secondary indexes. My process had 2 hours running but we decide to abort th... |
1431 | 19 Jul 2006 @ 01:43 PDT | Fred | Tools | Reply | MLOAD VARTEXT FORMAT | TEXT or UNFORMAT don't recognize field delimiters, they are fixed format. If there are delimiters in exactly the same column position in every record, you could ignore them - either using explicit ... |
1430 | 19 Jul 2006 @ 01:32 PDT | Fred | UDA | Reply | NULL | If you don't COMPRESS, a NULL will occupy the same space on disk as blank or zero - e.g. for CHAR(10) that's 10 or 20 bytes (depends on the Character Set) plus an indicator bit in the rowheader. |
1429 | 19 Jul 2006 @ 12:53 PDT | ilyas | UDA | Topic | NULL | If I declare a NULL coulmn and don't COMPRESS that column then how much space that NULL value will take.e.g Address char(10) and I insert null for address field then how much space this null will o... |
1428 | 19 Jul 2006 @ 07:34 PDT | Barry-1604 | Database | Reply | "Select Into" can't be used in teradata? | You can also create the result table "on the fly" with:create table Temp_Persons as(select name,gender,age from persons where age>18) with dataprimary index(name); |
1427 | 19 Jul 2006 @ 06:23 PDT | tintin_rk | Tools | Topic | Loading data using TPUMP | How to eliminate/exclude the very first row while loading data using TPUMP utility? |
1426 | 19 Jul 2006 @ 02:37 PDT | deeps_v_37 | Database | Reply | "Select Into" can't be used in teradata? | If u r intending to select the name gender and age fields of Persons and trying to insert them into temp_persons, U can use Insert-into clause.Insert into Temp_Persons(name,gender,age)select name,g... |
1425 | 19 Jul 2006 @ 01:35 PDT | vinod_sugur | Database | Reply | Date format - FMDD? | The query helps in getting the desired output but the string format not able to convert back to date.select CASEWHEN SUBSTRING(CAST(DATE -11 AS FORMAT 'DD') FROM 1 FOR 1 ) = 0 THEN SUBSTRING(CA... |
1424 | 19 Jul 2006 @ 12:06 PDT | giri | Tools | Reply | teradata architecture | HiTry this SELECT hashamp (hashbucket (hashrow (Primary index)))as "AMP"FROM tablenamehashrow gives the row hash valuehashbucket gives the bucket value that maps the AMPhashamp gives the AMP in wh... |
1423 | 18 Jul 2006 @ 11:52 PDT | giri | Tools | Reply | MLOAD VARTEXT FORMAT | Hi,Thank u for the Suggestions . Now if I use FORMAT (TEXT or UNFORMAT)in multiload how will I specify the Delimiters and EOF condition.Thank U.Giri |
1422 | 18 Jul 2006 @ 11:50 PDT | n4247558 | Database | Topic | "Select Into" can't be used in teradata? | I found that "select into" function can't be used in teradata.e.g. SELECT * INTO Temp_PersonsSELECT name, gender, ageFROM PersonsWHERE age > 18;Any method in teradata can be used instead? |
1421 | 18 Jul 2006 @ 11:14 PDT | n4247558 | Database | Topic | Date format - FMDD? | In oracle, if date format is set to be "dd-mm-yyyy" -> 01-12-2006if it's set to be "fmdd-mm-yyyy" -> 1-12-2006.But how about in teradata......i wanna to use the function like 'fmdd', how to make it? |
1420 | 18 Jul 2006 @ 07:20 PDT | jklee | Tools | Topic | Looking for BTEQ Templates | I'm looking for a template to use for generating BTEQ scripts.Something that already has the standard audit info at the top (name, author, date, purpose, etc) and some standard options that need to... |
1419 | 18 Jul 2006 @ 05:45 PDT | TeradataStaffingSpecialist | Jobs | Topic | Teradata Professionals-All Positions!!! | Hello We are an Ohio based IT Consulting firm specializing in Teradata. We have several openings for Teradata professionals right from Developer to an architect If you have Teradata experience th... |
1418 | 18 Jul 2006 @ 02:00 PDT | Aquent | Marketing IT | NYC | Jobs | Topic | Business Intelligence Manager opportunity in NYC | Our client's Business Intelligence team seeks a Manager.The position has primary responsibility for developing user requirements and functional specifications specific to business initiatives for t... |