1567 | 09 Aug 2006 @ 04:40 PDT | Fred | Database | Reply | Cancelling Rollback on a PPI table | You 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 ... |
1566 | 09 Aug 2006 @ 04:29 PDT | ilyas | UDA | Topic | OLE DB access module | in 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 ... |
1565 | 09 Aug 2006 @ 04:06 PDT | ilyas | UDA | Topic | OLE DB Access Module | Hi 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 ... |
1564 | 09 Aug 2006 @ 10:42 PDT | eg1274 | Database | Topic | Encryption | I am interested if anyone is applying encryption to data in the Teradata DBMS. If you are applying encryption what are you using? |
1563 | 09 Aug 2006 @ 01:09 PDT | Manoj_Kumar_Parmar | Database | Reply | NUSI 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... |
1562 | 08 Aug 2006 @ 10:40 PDT | John Mac | Database | Topic | Cancelling Rollback on a PPI table | Just 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, ... |
1561 | 08 Aug 2006 @ 03:11 PDT | Barry-1604 | Database | Reply | NUSI 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 ... |
1560 | 08 Aug 2006 @ 02:46 PDT | Host | Jobs | Reply | Teradata Discussion Form infested by Pesky Phone Salesmen. | Action has been taken and posted removed.Forum Host |
1559 | 08 Aug 2006 @ 12:44 PDT | lranger | Jobs | Topic | Teradata DBA needed in Toronto | Looking 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 |
1558 | 08 Aug 2006 @ 11:57 PDT | Raom | Jobs | Reply | Teradata 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... |
1557 | 08 Aug 2006 @ 10:18 PDT | RGlass | Jobs | Topic | Teradata Discussion Form infested by Pesky Phone Salesmen. | Is there anyway these people can be blocked? |
1556 | 08 Aug 2006 @ 09:41 PDT | fpantaleo-3029 | Tools | Reply | teradata architecture | Hi,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... |
1555 | 08 Aug 2006 @ 09:05 PDT | Manoj_Kumar_Parmar | Database | Reply | NUSI 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...... |
1554 | 08 Aug 2006 @ 09:04 PDT | Manoj_Kumar_Parmar | Database | Reply | NUSI 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...... |
1553 | 08 Aug 2006 @ 09:01 PDT | abhijitvyas | Database | Reply | Purpose of NUSI | A 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 ... |
1552 | 08 Aug 2006 @ 02:40 PDT | KR | Tools | Topic | Usage of inmod | I 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... |
1551 | 08 Aug 2006 @ 01:54 PDT | Suhas Joshi | Tools | Reply | Is there an equivalent of glogin.sql in Teradata | Thanks Ivo; That really helped;-Suhas |
1550 | 08 Aug 2006 @ 12:15 PDT | Boonprom | Tools | Reply | Export a variable length record | Sunopsis: Problem : (SnpsSqlUnload) : can not font ? such : (thai language) Who! : This Solution : ? |
1549 | 08 Aug 2006 @ 12:10 PDT | leo.issac | Database | Topic | Purpose of NUSI | I 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? |
1548 | 07 Aug 2006 @ 03:57 PDT | trying_to_learn | UDA | Reply | Need to fire 1000 different SQL statements and verify results automatically | rlaskar: 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... |
1547 | 07 Aug 2006 @ 03:37 PDT | trying_to_learn | UDA | Reply | e-mail Notifications | I 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... |
1546 | 07 Aug 2006 @ 03:28 PDT | trying_to_learn | Tools | Reply | Looking for BTEQ Templates | The 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.,#****************************... |
1545 | 07 Aug 2006 @ 03:18 PDT | trying_to_learn | Tools | Reply | Is there an equivalent of glogin.sql in Teradata | In 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; |
1544 | 07 Aug 2006 @ 10:48 PDT | trying_to_learn | Database | Reply | Spool Space Issues | I 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., ... |
1543 | 07 Aug 2006 @ 07:04 PDT | ispaleny | Tools | Reply | Is there an equivalent of glogin.sql in Teradata | Hi,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... |