23 | 18 Jun 2009 @ 06:45 PDT | Database | Reply | VONUSI VS PPI | Assuming you have a value ordered NUSI on column, the optimizer will determine approximately how many rows lie between a and b. If the number is small enough (c 10%), it will pass the NUSI to get t... |
22 | 18 Jun 2009 @ 01:07 PDT | Tools | Reply | delete and delete all | Fred is right! "Delete All" requires you to type 3 extra characters - that is the only difference.Under certain circumstances, Delete will use a Fastpath which avoids taking before images to the tr... |
21 | 18 Jun 2009 @ 12:50 PDT | UDA | Reply | use teradata table field values in shell script? | This exports the shell variable DBVAR to the value in colname in load_work.setmonth. it goes into file newvar.shbteq<< EOD.RUN FILE /home/nbk6cst/dbpass;.os rm newvar.sh.export report file = ... |
20 | 17 Jun 2009 @ 06:53 PDT | Database | Reply | How to find the row difference in Teradata | The following will work:Select D1.InsNo, D1.StartDate,D2.EndDateFrom -- Get All The Start Dates(Select InsNo, StartDateFrom InsurancesWhere (InsNo, StartDate) NOT IN (Select InsNo, EndDate From... |
19 | 17 Jun 2009 @ 12:56 PDT | Database | Reply | How to speed up inserting data into volatile table ? | You do not seem to have a primary index on your volatile table spec. The Create table will use the first column - does this have a wide range of values?Volatile tables use the same rules as permane... |
18 | 16 Jun 2009 @ 12:42 PDT | Tools | Reply | Create,drop macros using JDBC | The basic answer is no - you cannot speed it up.Setting up the macros is expensive because of the dictionary updating - you can get some very slow responses when you set up lots of database objects... |
17 | 14 Jun 2009 @ 12:48 PDT | Tools | Reply | Data loading via fastload | In the Define statement, set the field to as it is on the input record. eg:Define BigNum (Char(32) ...... (Assuming it is character input) orDefine BigNum (Decimal 30,20) it is comes in raw form)DB... |
16 | 14 Jun 2009 @ 12:36 PDT | Tools | Reply | ET & UV | It is down to where the error is spotted.1. ET table contains data errors where Teradata cannot translate the field - invalid date, alpha in a numeric field.2. UV entries are generated when there i... |
15 | 05 Jun 2009 @ 11:46 PDT | Tools | Reply | Bteq IF ELSE STATEMENT | Your requirement is not too clear, and you do not give your environment, but the following should help:You do not say what type of variable a is; I assume below it is a shell variable and is set in... |
14 | 12 May 2009 @ 01:00 PDT | Database | Reply | Convert hex string to numeric | Not really! It is really down to poor definition if you are holding numbers in hex strings.You do not say how long the strings are. The example below show how to convert a 4 character string to a n... |
13 | 11 May 2009 @ 11:01 PDT | Database | Reply | What's the quickest way to find out all the values under an attributes | Slight change to Joe's answer:SELECT '; SELECT ' || TRIM(COLUMNNAME) || ' FROM ' || TRIM(DATABASENAME) || '.' || TRIM(TABLENAME) || ' (TITLE '')GROUP BY 1 ORDER BY 1;'FROM(SELECT DATABASENAME, TABL... |
12 | 11 May 2009 @ 05:56 PDT | Database | Reply | mod() in view | Mod is an ODBC extension - it will work in Queryman if you have the "Allow ODBC Extensions" option set, but does not work in bteq or any other "direct" SQL.Use:Create View A asSelect Hours mod 15 a... |
11 | 07 May 2009 @ 11:09 PDT | Tools | Reply | what is the difference between Partitioned primary index and secondary index | Partitioned primary index is basically physically splitting the table into a series of subtables, one for every partitioning value. Data for the partitioning values is held together on the DBC.When... |
10 | 07 May 2009 @ 06:55 PDT | Tools | Reply | How to skip data errors during fastload? | Use the NOSTOP option on the SET RECORD command. |
9 | 04 May 2009 @ 08:35 PDT | UDA | Reply | Transform data set | The following two scripts assume that your lines are all in the correct sequence - an Access Number followed by 5 Attribute values.It first changes the "Access Number" header to a newline, removes ... |
8 | 22 Apr 2009 @ 02:25 PDT | Database | Reply | What is the best way to calculate the tablespace manually. | The following will calculate the average rowsize on the existing table. It will take EVERYTHING into account - row header, secondary indices, compression, varchar and unused space in the blocks.Sel... |
7 | 22 Apr 2009 @ 02:02 PDT | Analytics | Reply | Need to load a column from a header field. | If the header record is always the first record on the file, do a BTEQ import of the first record only.Otherwise, move to Multiload. |
6 | 22 Apr 2009 @ 01:52 PDT | UDA | Reply | FORMAT m/d/yy column as DD/MM/YYYY | The following will reformat your date column to a standard dd/mm/yy.If you are loading via Multiload or TPump, you can use it in the load. With Fastload, you have to take it in as character and use... |
5 | 27 Mar 2008 @ 11:23 PDT | Tools | Reply | Batch queryman (windows) - how to pass dynamic parameter | For DOS/ Windows, use %variable% |
4 | 27 Mar 2008 @ 11:06 PDT | Tools | Reply | Mload - error 6706 | Use Translate_Chk(field,UNICODE_TO_ASCII).This gives you the character number in the field which causes the 6706 error, or zero if it is OK.If there is only one bad character, you can use substring... |
3 | 12 Mar 2008 @ 06:16 PDT | Analytics | Reply | Fast Export | If you want to do it in batch, you can:Select Trim(Prdid)||','||Trim(Prdcd) (Char(40))From ....;That produces a 40 character line with the comma delimited Prdid and Prdcd and spaces at the ... |
2 | 07 Mar 2008 @ 05:52 PST | UDA | Reply | Query Performance Optimization Help | Try this. A Minus often works faster than a "Not In/ Not Exists"LOCK TABLE pre_load_image FOR access LOCK TABLE post_load_image FOR access SELECT 'sap_clnt_id=' || COALESCE( A.sap_clnt_id , '' )... |
1 | 26 Sep 2007 @ 05:02 PDT | Database | Reply | need help with this process | You are doing left join from z to a, but the NUPI set up by this query is on the Incident id from a.So you are potentially getting lots of nulls in the PI field.Check the answer set bySelect incide... |