All forum activity

#DateUserForumTypeThreadPost
156709 Aug 2006 @ 04:40 PDTFredDatabaseReplyCancelling Rollback on a PPI tableYou incorrectly assumed that the request was abortable and was rolling back. ALTER is not a normal DML operation like DELETE. ALTER does not use Transient Journal, so once it begins processing you ...
156609 Aug 2006 @ 04:29 PDTilyasUDATopicOLE DB access modulein OLELoad (OLE DB access module) when ever i try to select source or destination a teradata database, i am getting this error."Please select a valid host or edit your c:\....\hosts" file.I edited ...
156509 Aug 2006 @ 04:06 PDTilyasUDATopicOLE DB Access ModuleHi Can any body help me to answer these two questions?1) I selected destination Microsoft.Jet.OLEDB.4.0 driver for my access database. After entering the datalink properties I am getting follwoing ...
156409 Aug 2006 @ 10:42 PDTeg1274DatabaseTopicEncryptionI am interested if anyone is applying encryption to data in the Teradata DBMS. If you are applying encryption what are you using?
156309 Aug 2006 @ 01:09 PDTManoj_Kumar_ParmarDatabaseReplyNUSI Bitmapping?HiAs we are constantly using the term weakly/strongly selected NUSI, then how the Optimizer assures that Indexes are weekly/strongly selected, or it depends on whether statistics colleted or not?th...
156208 Aug 2006 @ 10:40 PDTJohn MacDatabaseTopicCancelling Rollback on a PPI tableJust aborted an Drop Partition/Add Partition Alter statement on a table with about 100M rows and 15 populated partitions (27 partitions in all).It's taking ages to abort, and is easily re-created, ...
156108 Aug 2006 @ 03:11 PDTBarry-1604DatabaseReplyNUSI Bitmapping?Reading between the lines of the manuals, I believe that this is essentially what is happening. Assume that we have 3 weakly selective NUSI indexes that are all specified as "equal to" conditions ...
156008 Aug 2006 @ 02:46 PDTHostJobsReplyTeradata Discussion Form infested by Pesky Phone Salesmen.Action has been taken and posted removed.Forum Host
155908 Aug 2006 @ 12:44 PDTlrangerJobsTopicTeradata DBA needed in TorontoLooking for a Teradata DBA and DB Designer for short term contracts in downtown Toronto. Contracts start ASAP - must be ready to start. Contact - Lisa Ranger, Bartech, lranger@bartechinc.net
155808 Aug 2006 @ 11:57 PDTRaomJobsReplyTeradata Discussion Form infested by Pesky Phone Salesmen.Yes. This is really annoying to see these sales posts. Something needs to be done immediately to stop this. I request the forum administrator to pay attention to this growing problem.for sale...
155708 Aug 2006 @ 10:18 PDTRGlassJobsTopicTeradata Discussion Form infested by Pesky Phone Salesmen.Is there anyway these people can be blocked?
155608 Aug 2006 @ 09:41 PDTfpantaleo-3029ToolsReplyteradata architectureHi,I'm a died in the wool Oracle person as well. Just starting Teradata. I think the right tool here is performance monitor.Once in the tool you have to connect. Go to sessions and then you can cli...
155508 Aug 2006 @ 09:05 PDTManoj_Kumar_ParmarDatabaseReplyNUSI Bitmapping?Hi thanks for reply, but scenario is not getting clear that what actual bitmapping is? Can anybody explain with giving query as example....Thanks in Advance......
155408 Aug 2006 @ 09:04 PDTManoj_Kumar_ParmarDatabaseReplyNUSI Bitmapping?Hi thanks for reply, but scenario is not getting clear that what actual bitmapping is? Can anybody explain with giving query as example....Thanks in Advance......
155308 Aug 2006 @ 09:01 PDTabhijitvyasDatabaseReplyPurpose of NUSIA non-unique secondary index (NUSI) may have multiple rows per value. As a general rule, the NUSI should not be defined if the maximum number of rows per value exceeds the number of data blocks in ...
155208 Aug 2006 @ 02:40 PDTKRToolsTopicUsage of inmodI would like to know when inmod can be used when using utilities like Fastload and Mload. I have come across usage of inmod where data is unloaded from a DB2 table using a Cobol program and then lo...
155108 Aug 2006 @ 01:54 PDTSuhas JoshiToolsReplyIs there an equivalent of glogin.sql in TeradataThanks Ivo; That really helped;-Suhas
155008 Aug 2006 @ 12:15 PDTBoonpromToolsReplyExport a variable length record Sunopsis: Problem : (SnpsSqlUnload) : can not font ? such : (thai language) Who! : This Solution : ?
154908 Aug 2006 @ 12:10 PDTleo.issacDatabaseTopicPurpose of NUSII have a general question regarding NUSI.In a production environment, what is importance of NUSI?In what scenario's does the NUSI help the user?
154807 Aug 2006 @ 03:57 PDTtrying_to_learnUDAReplyNeed to fire 1000 different SQL statements and verify results automaticallyrlaskar: To my knowledge, there are two ways you can automate.1: Type in all your SQL statements in SQL Assistant. Got to Teradata SQL Assistant's Menu > File > Export Results option. After sele...
154707 Aug 2006 @ 03:37 PDTtrying_to_learnUDAReplye-mail NotificationsI do not know whether it will work if you put this statement in BTEQ script, but it works if you write a k shell and call your BTEQ script and at the end write this statement, it will send you an m...
154607 Aug 2006 @ 03:28 PDTtrying_to_learnToolsReplyLooking for BTEQ TemplatesThe following is the template I am using... but I do not have a statement that handles MaxErrorLevel. But I am having retention limit, page lenght and width setup etc.,#****************************...
154507 Aug 2006 @ 03:18 PDTtrying_to_learnToolsReplyIs there an equivalent of glogin.sql in TeradataIn addition to Ivo Spaleny help, type in the following in your BTEQ script and try... Good luck.. :-) .echoreq on;.pagelength 5000;.null '~';.set width 254;.set retlimit 10; .set retcancel on;
154407 Aug 2006 @ 10:48 PDTtrying_to_learnDatabaseReplySpool Space IssuesI often used to got spool space issues, I realized that I was not joining the columns that are of same data types (most of the cases are like joining a decimal data type to integer data type etc., ...
154307 Aug 2006 @ 07:04 PDTispalenyToolsReplyIs there an equivalent of glogin.sql in TeradataHi,You can do it for BTEQ by running: MODIFY USER my_user AS STARTUP = 'echo ''set foldline on;'';echo ''set sidetitles on;'';'I guess "Default" user is a master copy of every new user. So you mu...

Pages