29 | 15 Aug 2008 @ 10:52 PDT | Database | Reply | TRIM/DROP non-printable trailing CHARACTERS | Try using CHAR2HEXINT function in the where clause.More information can be obtained in |
28 | 01 Aug 2008 @ 09:44 PDT | Tools | Reply | FastExport script and output delimiters | select CAST(first_col AS CHAR(N)) || ';' || CAST (second_col AS CHAR(N)) || etc... from my_tableWe can also do like thisselect CAST(first_col AS CHAR(N)) ,cast(';' as char(1)) ,CA... |
27 | 01 Aug 2008 @ 09:39 PDT | Database | Reply | FastExport to Text | .BEGIN EXPORT TENACITY 4SESSIONS 10SLEEP 6;.EXPORT OUTFILE 'e:\datafile\agr_farm.out' mode record FORMAT text;Select COVERAGE_CD,STATE_CD,COUNTY_CD,CROP_CD,INS_PLAN_ID,CROP_YR_ID FROM CAESTG1.AGR_F... |
26 | 16 Apr 2008 @ 04:33 PDT | Database | Reply | ARCHIVE - COPY STATEMENT | Thanks Joe,I was expecting your reply on this. Well i had taken the PPI archive using the PARTITION WHERE criteria. And i want to copy the subset of the data in new table. If not wrong ,Table shoul... |
25 | 15 Apr 2008 @ 11:07 PDT | Database | Topic | ARCHIVE - COPY STATEMENT | I am trying to restore the table using the COPY command . The table is not present in the target database. I am creating the new table using the ARCHIVE done using the PPI condition. The ARCH file ... |
24 | 02 Apr 2008 @ 07:10 PDT | Database | Reply | Select statment using multi table | The IInd format is the one which i generally adopt while writting the query. |
23 | 24 Aug 2007 @ 02:51 PDT | Analytics | Reply | Changing Database Name | In Teradata We can not alter the database name once created.To change the name of database either drop and recreate the database with new name. |
22 | 25 Jun 2007 @ 07:55 PDT | Database | Reply | not able to release MLOAD | From remote console try to see the staus of this MLOADTeradataManage > Administer > Database Console > Utilities > QurySessCheck the status of the working table and seee if it is still running and ... |
21 | 25 Jun 2007 @ 06:50 PDT | Database | Reply | not able to release MLOAD | TryRelease mload DBNAME.Tablename in apply; |
20 | 25 Jun 2007 @ 02:53 PDT | Database | Topic | Diagnostic Help stats for session | When we run diagnostic help stats on for session and see the explain of the query it give the recommandation for COLLECTING the stats on the combinations of the COLUMNsBut we are collecting stats o... |
19 | 19 Jun 2007 @ 09:27 PDT | Database | Topic | What should we do in case of following error | 234 days : A reboot of the system in the next 8 days should be performed to continue sane operation of the systemThis has been checked in SW_EVENT_LOG table in DBCDo we need to reboot the TD system... |
18 | 29 May 2007 @ 07:39 PDT | Database | Topic | Required the book TERADATA ORANGE BOOK : Partition Primary Index Usage | Does any body have the above book ?Requesting you all to share if any one has the sameMy id sushantp_2000@yahoo.comsushant.paricharak@gmail.com |
17 | 24 May 2007 @ 04:31 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | Dieter, stats has been collected on all the columns including the PI columns In Production system our stats as collected every week.So the conclusion is not to go with new DDL structure as shown IN... |
16 | 24 May 2007 @ 02:53 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | Dieter Ok Agreee what you are saying But if u see the docs it has mentioned they had given such a example for sale history dataPARTITION BY RANGE_N( SALE_DATE BETWEEN DATE '2000-01-01' AND DATE '20... |
15 | 24 May 2007 @ 05:36 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | Thanks joe Thanks a lot for putting your efforts on this and explained lot of thingHi DieterAny suggestion on the DDL sent to you ? |
14 | 24 May 2007 @ 04:56 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | Joe one small questionIs it good to use interval 1 day instead of 1 month if we have one partition range of 10 yrs |
13 | 24 May 2007 @ 02:22 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | HI Joe In the given ddl these partitions has been created so planning to to do the following1. I am now reducing it upto 15yrs2. Planning to collect the stats on PARTITION levelAlso along with this... |
12 | 23 May 2007 @ 04:34 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | Hi Dieter,I am attaching the new and old DDL . Please help me in finding out the best possible solution. I tried certain test for accessing the data . I am getting the good performance in the Newly... |
11 | 23 May 2007 @ 09:49 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | But then why there is tremendous increase in the performance of the query in the NEW PPI structure and why the queries are taking time in the earlier structure? |
10 | 23 May 2007 @ 08:08 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | Sorry Joe , I forgot to explan about the last question along with the earlier threadDoes the PPI column can be null?Also can you please put more insight on collection of statistics at partition level |
9 | 23 May 2007 @ 08:04 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | In te old scenario i was having only 1 partition having the all the rows and in the new ddl i am having different partitions holding dateso in the earlier DDl where i was having the single partitio... |
8 | 23 May 2007 @ 07:02 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | Thanks for reply ,I have check even though statistics collect on this column which has single partition it was taking tremendous time. But in the multiple partitioning i havenot yet collected any s... |
7 | 22 May 2007 @ 07:23 PDT | Database | Reply | Database info in one query | SELECT 'SELECT COUNT(*) FROM '||trim(tablename)|| ';' from dbc.tableswhere databaseName=name_of_database andPlease use thisThe run all the counts for the table using the sql assistant |
6 | 22 May 2007 @ 07:10 PDT | Database | Topic | Physical Implemetation of the Tables - PPI | Earlier our database were having the follwing table with the partition expressionPARTITION BY RANGE_N(PI_COLUMN between DATE '2000-01-01' AND '2100-01-01' EACH INTERVAL '1' MONTH )The queries runni... |
5 | 26 Apr 2007 @ 03:33 PDT | Database | Reply | Required help | Barry I am using the PI (Primary INDEX and not the UPI)But my explain shown me that estimated time for the same is 1hr and 30 sec but when we execute the INSERT it takes longer time and it is not i... |