#DateForumTypeThreadPost
2915 Aug 2008 @ 10:52 PDTDatabaseReplyTRIM/DROP non-printable trailing CHARACTERSTry using CHAR2HEXINT function in the where clause.More information can be obtained in
2801 Aug 2008 @ 09:44 PDTToolsReplyFastExport script and output delimitersselect 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...
2701 Aug 2008 @ 09:39 PDTDatabaseReplyFastExport 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...
2616 Apr 2008 @ 04:33 PDTDatabaseReplyARCHIVE - COPY STATEMENTThanks 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...
2515 Apr 2008 @ 11:07 PDTDatabaseTopicARCHIVE - COPY STATEMENTI 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 ...
2402 Apr 2008 @ 07:10 PDTDatabaseReplySelect statment using multi tableThe IInd format is the one which i generally adopt while writting the query.
2324 Aug 2007 @ 02:51 PDTAnalyticsReplyChanging Database NameIn 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.
2225 Jun 2007 @ 07:55 PDTDatabaseReplynot able to release MLOADFrom 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 ...
2125 Jun 2007 @ 06:50 PDTDatabaseReplynot able to release MLOADTryRelease mload DBNAME.Tablename in apply;
2025 Jun 2007 @ 02:53 PDTDatabaseTopicDiagnostic Help stats for sessionWhen 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...
1919 Jun 2007 @ 09:27 PDTDatabaseTopicWhat should we do in case of following error234 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...
1829 May 2007 @ 07:39 PDTDatabaseTopicRequired the book TERADATA ORANGE BOOK : Partition Primary Index UsageDoes 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
1724 May 2007 @ 04:31 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIDieter, 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...
1624 May 2007 @ 02:53 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIDieter 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...
1524 May 2007 @ 05:36 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIThanks joe Thanks a lot for putting your efforts on this and explained lot of thingHi DieterAny suggestion on the DDL sent to you ?
1424 May 2007 @ 04:56 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIJoe one small questionIs it good to use interval 1 day instead of 1 month if we have one partition range of 10 yrs
1324 May 2007 @ 02:22 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIHI 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...
1223 May 2007 @ 04:34 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIHi 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...
1123 May 2007 @ 09:49 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIBut 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?
1023 May 2007 @ 08:08 PDTDatabaseReplyPhysical Implemetation of the Tables - PPISorry 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
923 May 2007 @ 08:04 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIIn 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...
823 May 2007 @ 07:02 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIThanks 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...
722 May 2007 @ 07:23 PDTDatabaseReplyDatabase info in one querySELECT '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
622 May 2007 @ 07:10 PDTDatabaseTopicPhysical Implemetation of the Tables - PPIEarlier 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...
526 Apr 2007 @ 03:33 PDTDatabaseReplyRequired helpBarry 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...

Pages