#DateForumTypeThreadPost
12324 Nov 2009 @ 04:13 PSTJobsReplyTeradata DBA Wanted in UKI am interestd in yer job.I am afrade my spelling is as bad az yers - du yu thinkzis iz a problm?
12223 Nov 2009 @ 09:08 PSTDatabaseReplyProblem with Global Temp tableThe 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.
12122 Nov 2009 @ 02:09 PSTToolsReplyUTY1802 Processing Import Sequence 1, Source 10600000 in MLOADThere 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 ...
12021 Nov 2009 @ 12:26 PSTDatabaseReplyquestion 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...
11920 Nov 2009 @ 11:13 PSTDatabaseReplyquestion 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...
11820 Nov 2009 @ 04:02 PSTToolsReplyany one plz give me brief explain about this errorIf 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...
11720 Nov 2009 @ 03:21 PSTUDAReplyCopying Table structureIf 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...
11620 Nov 2009 @ 03:06 PSTUDAReplyHow to compare date in Varchar2(25 Byte) with datesBe 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')
11519 Nov 2009 @ 04:42 PSTUDAReplyNumeric Overflow errorThe 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...
11419 Nov 2009 @ 04:36 PSTUDAReplyHow to compare date in Varchar2(25 Byte) with datesI 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...
11317 Nov 2009 @ 09:32 PSTDatabaseReplyQuestion on InsertI 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...
11217 Nov 2009 @ 09:10 PSTDatabaseReplyFinding the index of last occurrenceYou 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...
11117 Nov 2009 @ 07:58 PSTDatabaseReplySelect Month Date in GermanSelectSubstr((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...
11009 Nov 2009 @ 01:57 PSTDatabaseReplyTeradata 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.
10908 Nov 2009 @ 04:24 PSTDatabaseReplyTeradata express edition on windows 7 --help.Teradata Express Version 13 supports Windows 7.You can request it from Teradata.com
10805 Nov 2009 @ 02:01 PSTUDAReplyTo create a volatile table in crystal reports on terdataYes.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.
10705 Nov 2009 @ 10:48 PSTUDAReplyTo create a volatile table in crystal reports on terdataIf 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...
10602 Nov 2009 @ 03:34 PSTUDAReplySelect (SHOW sometable) into volatile tableIt 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...
10530 Oct 2009 @ 11:07 PDTUDAReplyInterval Overflow ErrorThe 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...
10429 Oct 2009 @ 03:13 PDTAnalyticsReplyHow 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...
10329 Oct 2009 @ 03:00 PDTDatabaseReply3800: DATATYE MISMATCH IN THEN/ELSE EXPRESSIONYou 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...
10229 Oct 2009 @ 02:50 PDTDatabaseReplyGlobal temporary tablecreate 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...
10128 Oct 2009 @ 03:38 PDTDatabaseReplyrank() (partition by....) helpSee 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 ...
10027 Oct 2009 @ 06:16 PDTDatabaseReplyNUSI maintenanceSecondary 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 ...
9927 Oct 2009 @ 06:06 PDTAnalyticsReplyValidate column dataCheck 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...

Pages