1467 | 24 Jul 2006 @ 08:51 PDT | Womper | Connectivity | Reply | Efficiency UDF scalar function vs.conventional SQL | nope... found my own issue. 1abcdefg1aany ideas on sql solutions? |
1466 | 24 Jul 2006 @ 08:21 PDT | Womper | Connectivity | Reply | Efficiency UDF scalar function vs.conventional SQL | How bout this one... select * from ( select '1abcdefgha' as test_value from dbc.tables where tablename = 'tables' and databasename = 'dbc' union all select '0000000000' as tes... |
1465 | 24 Jul 2006 @ 11:41 PDT | carmen | UDA | Topic | How to run a stored procedure please? | How to run a stored procedure please?nameofprocedure() |
1464 | 24 Jul 2006 @ 10:59 PDT | jporell | Database | Topic | Convert Varbyte to Character | I would like to convert the Hostdata column from a TPUMP error table from varbyte to character. I found a UDF (VarbyteToVarchar.c) which said it would do it but I haven't had any luck calling it. |
1463 | 24 Jul 2006 @ 10:19 PDT | alvinying | Database | Reply | Problem with Recursive View | Below is the recursive view. It's created and running fine. The problem is with the outer view encapsulating this recursive view. Teradata simply won't let me create it (the outer view). Keep getti... |
1462 | 22 Jul 2006 @ 06:06 PDT | j355ga | Database | Reply | Problem with Recursive View | Could you include the DDL for the recursive view? |
1461 | 22 Jul 2006 @ 02:08 PDT | ragav | Database | Topic | Codd Rules | Hi All,I was having a chat with my friend who is a oracle specialist.he was telling that oracle supports 8 E.F.Codd rules and inturn asked me how much teradata Rdbms supports.can anyone answer this... |
1460 | 21 Jul 2006 @ 04:40 PDT | Aquent | Marketing IT | LA | Jobs | Topic | Director, Statistical Analysis & Forecasting (Los Angeles, CA w/ relo) | Aquent Marketing IT helps Marketing, Creative and IT organizations maximize the return on their data. We partner with our clients to understand their Marketing, Data Management, Business Intelligen... |
1459 | 21 Jul 2006 @ 03:42 PDT | alvinying | Database | Reply | Problem with Recursive View | As a workaround I've created a volatile tableCreate volatile Table B_Temp As (Select *From B) With dataON COMMIT PRESERVE ROWS;And then created the View A based on the B_Temp table.This workaround ... |
1458 | 21 Jul 2006 @ 12:53 PDT | ljschwab | Jobs | Topic | Data Warehouse Architect position at Charles Schwab | Charles SchwabData Warehouse ArchitectSan Francisco, CAGroup Objective: It is our objective within the Data Warehouse and Business Information Group to deliver high quality decision support applic... |
1457 | 21 Jul 2006 @ 07:33 PDT | ANGEL | Database | Reply | NUSI Bitmapping? | Hi,If you do collect statistics on all NUSI ,then PE gains the ability to utilize Bit mapping. When multiple NUSI values are compared with AND operator, PE may choose a plan to create NUSI Bit map.... |
1456 | 21 Jul 2006 @ 05:31 PDT | giri | Tools | Reply | MLOAD VARTEXT FORMAT | Thank u.Now I have have got a better idea. |
1455 | 21 Jul 2006 @ 03:22 PDT | Uwe Posselt | Connectivity | Reply | Trying to set up ODBC connection | Ok, thank you for the information.The package contains TeraGSS 06.01.00.00, TDICU 01.01.01.00 and TDODBC 03.05.00.05Meanwhile I've got a newer TeraGSS 06.01.00.14 by a NCR supporter. I don't know, ... |
1454 | 21 Jul 2006 @ 01:25 PDT | Manoj_Kumar_Parmar | Database | Topic | NUSI Bitmapping? | Hi All, What is NUSI Bitmapping, is it similar to Oracle Bitmap index or something else...can any body explain it.Thanks in Advance... |
1453 | 21 Jul 2006 @ 12:40 PDT | Fred | Analytics | Reply | Using Statistics Wizard | Prior to V2R6.1, you can't run Index Analysis or Statistics Analysis while Access Logging is enabled (for the user and/or objects in question). |
1452 | 20 Jul 2006 @ 11:53 PDT | John Mac | Analytics | Topic | Using Statistics Wizard | When attempting to analyse a workload, I get the following message...[NCR][ODBC Teradata Driver][Teradata RDBMS] Statistics Analysis is not allowed when access logging is enabled. [15102]Is this an... |
1451 | 20 Jul 2006 @ 11:02 PDT | rgans_99 | Database | Topic | Identifying a Node in MPP | Hi all,How do the request from the client send to appropriate Node in the MPP system?The AMP within a Node is identified by Mapping The hash value generated by PE's generator in the Hashmap.(But th... |
1450 | 20 Jul 2006 @ 11:01 PDT | rgans_99 | Database | Topic | Identifying a Node in MPP | Hi all,How do the request from the client send to appropriate Node in the MPP system?The AMP within a Node is identified by Mapping The hash value generated by PE's generator in the Hashmap.(But th... |
1449 | 20 Jul 2006 @ 07:08 PDT | Meredith at eBay | Jobs | Topic | Sr. Manager of DataWarehouse Architecture Opportunity at eBay! | Are you looking for an opportunity to work with one of the largest Data Warehouse installations in the world? If Dual Active, Multi Temperature Active Data Warehousing is your specialty and you liv... |
1448 | 20 Jul 2006 @ 04:50 PDT | fox | Analytics | Reply | standard deviation function with parition by | I found this post -- Although you can't use STDDEV as a window function, the calculations for each of these involve functions that can be done with window aggregates. So, another alternative can be... |
1447 | 20 Jul 2006 @ 04:12 PDT | jklee | Database | Reply | "Teradata Unable to Perform Join" | I found the problem. I can't have an aggregation on a column that I am joining on. |
1446 | 20 Jul 2006 @ 02:47 PDT | jklee | Database | Topic | "Teradata Unable to Perform Join" | I have the following join indexed defined:create join index session_base_ji asselect wh.visid_high , wh.visid_low , wh.visit_num , wh.prop49 as user_id , wh.hit_dt , wh.omniture_dtm , pco.client_or... |
1445 | 20 Jul 2006 @ 02:24 PDT | Fred | Database | Reply | risk associated with dynamic sql | To use SysExecSQL, the user that is the creator of the stored procedure must also be the immediate owner. Statements run via SysExecSQL use the access rights of that user, not the caller.There is t... |
1444 | 20 Jul 2006 @ 02:16 PDT | fox | Analytics | Topic | standard deviation function with parition by | I want to use the STDDEV_SAMP() with the OVER (Partition by) clause.Teradata's standard deviation functions do not allow this. I want to calculate the standard deviation for each subset of data.Any... |
1443 | 20 Jul 2006 @ 02:01 PDT | Alfredo | UDA | Reply | Could I stop an abort session? | It's correct, we try to use the sentence but we can do it. Are there some diferent way to do that? |