#DateForumTypeThreadPost
3824 Apr 2012 @ 03:29 PDTToolsReplyCopy tables between two different systems @Praneeth: Check the below link for more info.... http://forums.teradata.com/forum/database/copybackup-teradata-tables#comment-19310
3713 Mar 2012 @ 11:47 PDTDatabaseReplyAlter Table column defined as foreign key Also,the column type that you are trying to change to NOT NULL if it is indexed then the attributes can not be altered.For non-indexed column defined as NULL can be altered to NOT NULL provided ...
3613 Mar 2012 @ 11:05 PDTToolsReplyRegarding Temporary Space Can you post the script for us to share our thoughts?
3513 Mar 2012 @ 11:01 PDTDatabaseReplyError Code 2652. Operation Not allowed. @Heer: Check the SYSADMIN.FASTLOG table...
3413 Mar 2012 @ 10:57 PDTGeneralReplyError "Table is being loaded' >>"2652:operation not allowed:t10 is being loaded" - means the fast load is in paused state.. What is the highest error encountered? Check whether the end loading st...
3313 Mar 2012 @ 05:26 PDTDatabaseReplyAlter Table column defined as foreign key Just a thought.. Drop the foreign key reference and then try to alter the table.....
3212 Mar 2012 @ 02:25 PDTAnalyticsReplyTo find record counts for all tables in a particular database @Ulrich: Sel 1 will not check for all the fields in a row,rather place a '1' against each row and produce the row count.I do agree with you that the count(*) or count(1) had been improve...
3112 Mar 2012 @ 12:46 PDTToolsReplyFastload error :when trying to load data using fastload from BTEQ exported data file It would be good if you can share the whole log of the run and also the DDL of the table.. I could see a blank for N_NAME in the second row of the i/p file - Try removing this record and run...
3012 Mar 2012 @ 12:13 PDTAnalyticsReplyTo find record counts for all tables in a particular database I dont think that its feasible to fetch the entire record count of all the tables in a particular database in a single shot as it consumes lots of CPU Instead of sel count(*) can use sel 1 w...
2909 Mar 2012 @ 03:10 PSTToolsReplyFastload error :when trying to load data using fastload from BTEQ exported data file What is the highest return code encountered?
2809 Mar 2012 @ 01:49 PSTToolsReplyFastload error :when trying to load data using fastload from BTEQ exported data file Can you post your input file.......
2708 Mar 2012 @ 11:13 PSTAnalyticsReplyNeed help with adding an integer column to a date column in teradata Below Info from TD sql manual...Hope it helps! DATE and Integer Arithmetic The following arithmetic functions can be performed with date and an integer (INTEGER is interpreted as a numbe...
2607 Mar 2012 @ 10:32 PSTDatabaseReplyOrder of joins in the SQL Ulrich - I accept...Its same result and not similar...
2507 Mar 2012 @ 01:18 PSTDatabaseReplyOrder of joins in the SQL Both the queries will produce similar results..
2406 Mar 2012 @ 12:33 PSTAnalyticsReplyCombining 4 tables and prioritize the data in them? Terankit - How do you differentiate the priority by looking at the table-4?
2305 Mar 2012 @ 11:42 PSTToolsReplyCheckpoint in FastLoad Checkpoints slow FastLoad processing.Set the CHECKPOINT large enough that checkpoints are taken every 10 to 15 minutes.  Usually, this requires a CHECKPOINT value much larger than 100,000. ...
2205 Mar 2012 @ 10:59 PSTDatabaseReplySkew Factor Kishore, Do check the below link for more info..... http://forums.teradata.com/forum/database/data-distribution-skew
2105 Mar 2012 @ 10:19 PSTToolsReplyBTEQ : Missing columns and special characters in flat file export Virendra - Can you share the script plz.......
2001 Mar 2012 @ 11:19 PSTDatabaseReplyperformance issue with update query Can you share the DDL script of the temp table?
1901 Mar 2012 @ 10:35 PSTDatabaseReplyCounts and total count in one query ? Check the below link for more info.... http://forums.teradata.com/forum/database/countsub-count
1801 Mar 2012 @ 10:31 PSTDatabaseReplyperformance issue with update query >>set datediff= Web_Registration_Start_Dt - Xref_Create_Dt; where Web_Registration_Start_Dt between '2011-12-25' and '2012-01-28'   Can you check the synt...
1701 Mar 2012 @ 09:34 PSTDatabaseReplyUNION Vs MSR Thanks for the correction Carlos:)
1601 Mar 2012 @ 02:03 PSTDatabaseReplyUNION Vs MSR In general, inserting into a populated target table will be slower as INSERT SELECT operates on a row-by-row/block-by-block basis. The performance is optimised when the target table is empt...
1529 Feb 2012 @ 11:31 PSTToolsReplyRemove column headings from Fexport output Fast export doesn't export column headers. Do visit the below link for more info.... http://forums.teradata.com/forum/tools/export-data-with-column-name-using-fast-export
1429 Feb 2012 @ 10:59 PSTDatabaseReplyconvert varchar to date The format is 'MM/DD/YYYYBHH:MI:SSBT'.Hence '0' is needed.

Pages