123 | 24 Nov 2009 @ 04:13 PST | Jobs | Reply | Teradata DBA Wanted in UK | I am interestd in yer job.I am afrade my spelling is as bad az yers - du yu thinkzis iz a problm? |
122 | 23 Nov 2009 @ 09:08 PST | Database | Reply | Problem with Global Temp table | The database with the stored procedure needs Select/ Insert/ Update and delete (if used in the proc) with Grant option on the database containing the views. |
121 | 22 Nov 2009 @ 02:09 PST | Tools | Reply | UTY1802 Processing Import Sequence 1, Source 10600000 in MLOAD | There is no problem.It is just giving you a progress report in the aquisition phase, as it reads the records.Then at the end of this phase, it tells you how many records where applied and how many ... |
120 | 21 Nov 2009 @ 12:26 PST | Database | Reply | question about explicit access rights | Apologies - it was late!
Select RMM.Grantee As UserName
, RMM.RoleName
, ARR.AccessRight
, ARR.Databasename
, ARR.Tablename
From DBC.RoleMembers RMM
Join DBC.AllRoleRights ARR
ON RMM.Ro... |
119 | 20 Nov 2009 @ 11:13 PST | Database | Reply | question about explicit access rights | Use DBC.RoleMembers
Select RMM.Grantee As UserName
, RMM.RoleName
, ARR.AccessRight
, ARR.Databasename
, ARR.Tablename
From DBC.RoleMembers RMM
Join DBC.AllRoleRights ARR
ON RMM.RoleN... |
118 | 20 Nov 2009 @ 04:02 PST | Tools | Reply | any one plz give me brief explain about this error | If you have duplicates in the input file, they will go to the error table - not give a duplicate table violation.Table databasename_tablename_Log. Is this the LG table for mload, or is this a table... |
117 | 20 Nov 2009 @ 03:21 PST | UDA | Reply | Copying Table structure | If you specify the index definition on the create table, it will use the new index definition - so lose the partition information.So:CREATE TABLE ABC.partyas XYZ.party WITH NO DATA Primary index (c... |
116 | 20 Nov 2009 @ 03:06 PST | UDA | Reply | How to compare date in Varchar2(25 Byte) with dates | Be careful. I am not sure whether Oracle will do the compare as dates or characters.I would use:to_date(substr(column,1,10),'mm/dd/yyyy') < to_date('30Oct2009','ddmmmyyyy') |
115 | 19 Nov 2009 @ 04:42 PST | UDA | Reply | Numeric Overflow error | The total columns will have the same datatype and size as the columns you are totalling.So if column F is smallint and the total does not fit in a smallint, you get numeric overflow.As a last resor... |
114 | 19 Nov 2009 @ 04:36 PST | UDA | Reply | How to compare date in Varchar2(25 Byte) with dates | I assume your date is dd/mm/yyyy - modify this if it is mm/dd.Select Substr('10/08/2009 12:04:23 AM',1,10) (Date, Format 'dd/mm/yyyy')Where Date LT Current_Date - 30or Select Substr(col1,1,10) (Dat... |
113 | 17 Nov 2009 @ 09:32 PST | Database | Reply | Question on Insert | I assume your data is comma delimited, variable width.Use Multiload to load it - it allows SQL functions directly in the loading..Logtable Logtable002; /* Connect to the Teradata DBS */.Logon td... |
112 | 17 Nov 2009 @ 09:10 PST | Database | Reply | Finding the index of last occurrence | You need to get the Oracle UDF's installed on your system.The "Instr" function (compatible with Oracle) allows backward searches.The following script sets up a test and gives the correct values:Cre... |
111 | 17 Nov 2009 @ 07:58 PST | Database | Reply | Select Month Date in German | SelectSubstr((Current_Date (Format 'dd.bmmmbyyyy')),1,4)||Trim(CASE Substr((Current_Date (Format 'dd.bmmmbyyyy')),5,3) WHEN 'Jan' THEN 'Januar' WHEN 'Feb' THEN 'Februar' Whe... |
110 | 09 Nov 2009 @ 01:57 PST | Database | Reply | Teradata express edition on windows 7 --help. | http://www.teradata.com/t/express-download-form.aspx?id=12297This takes you to the form to request it. |
109 | 08 Nov 2009 @ 04:24 PST | Database | Reply | Teradata express edition on windows 7 --help. | Teradata Express Version 13 supports Windows 7.You can request it from Teradata.com |
108 | 05 Nov 2009 @ 02:01 PST | UDA | Reply | To create a volatile table in crystal reports on terdata | Yes.If you can split your request in two, so that the Create is in one request from Crystal Reports, with the second request of Insert and Select.The Global Temp is more efficient though. |
107 | 05 Nov 2009 @ 10:48 PST | UDA | Reply | To create a volatile table in crystal reports on terdata | If all this code is submitted in one request to the Teradata, it will run as an implicit transaction - hence you cannot run DML after the DDL Crerate Table.You can either split it up so that the Cr... |
106 | 02 Nov 2009 @ 03:34 PST | UDA | Reply | Select (SHOW sometable) into volatile table | It depends what differences you are looking for.DBC.Columns contains details of every column, DBC.Indices contains details of the indices.You can do a relatively simple compare based on these.The o... |
105 | 30 Oct 2009 @ 11:07 PDT | UDA | Reply | Interval Overflow Error | The code below converts each interval to days (with decimal part-days), adds them up and then converts it back to a character interval looking string with up to 5 days.You can only have a maximum o... |
104 | 29 Oct 2009 @ 03:13 PDT | Analytics | Reply | How to search through multiple stored procedures?? | Run the following script in bteq--------------------.Export Report File = c:/outfile.txt.FORMAT OFF.WIDTH 255SHOW PROCEDURE database_name.procedure_name_1;SHOW PROCEDURE database_name.procedure_nam... |
103 | 29 Oct 2009 @ 03:00 PDT | Database | Reply | 3800: DATATYE MISMATCH IN THEN/ELSE EXPRESSION | You created table employee in SQL Assistant when the "Allow Use Of ODBC Extensions" was allowed.If you do a show table on Employee, it will show column as " A INTEGER FORMAT '99:99:99' NOT NUL... |
102 | 29 Oct 2009 @ 02:50 PDT | Database | Reply | Global temporary table | create global temporary table t1 as (sel * from employee)WITH NO DATA --------------------------on commit preserve row;Are you sure you want a Global table, not a volatile... |
101 | 28 Oct 2009 @ 03:38 PDT | Database | Reply | rank() (partition by....) help | See below:- Create Volatile Table Tst1("Time" Smallint Not Null, Price Smallint Not Null)Unique Primary Index ("Time")On Commit Preserve Rows;Insert Into Tst1 Values (1,6);Insert Into Tst1 Values ... |
100 | 27 Oct 2009 @ 06:16 PDT | Database | Reply | NUSI maintenance | Secondary indices will definitely slow down performance on high volume delete/ insert.If you are regularly affecting 20-30% of the table, I would look at building a new table - Insert the rows you ... |
99 | 27 Oct 2009 @ 06:06 PDT | Analytics | Reply | Validate column data | Check if you have the Oracle UDF's installed - you can get them from the Teradata Download centre.There is an otranslate finction - Oracle's Translate - which can check them for you.See: http://ter... |