All forum activity

#DateUserForumTypeThreadPost
111712 Jun 2006 @ 09:04 PDTwilliamdieterDatabaseReplyODBC Driver changing submitted SQLWe got it to work, that's no biggie. I'm just trying to figure out why we were getting these results in case there was a bug. It looks like it's not Teradata that's doing it. If I execute the query...
111612 Jun 2006 @ 09:04 PDTwilliamdieterDatabaseReplyODBC Driver changing submitted SQLWe got it to work, that's no biggie. I'm just trying to figure out why we were getting these results in case there was a bug. It looks like it's not Teradata that's doing it. If I execute the query...
111511 Jun 2006 @ 08:48 PDTVesoniDatabaseReplyPaging in Teradata for Web applicationHi Daniel,Thank you for info.Regards
111411 Jun 2006 @ 08:03 PDTDGiabbaiToolsReplytranspose dataLook at how to pivot a table (in your case, rows to columns) in the answer from Dieter at:http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=10&messageid=1285
111311 Jun 2006 @ 07:55 PDTDGiabbaiDatabaseReplyPaging in Teradata for Web applicationPaging requires the answer set to be cached somewhere on a server. Teradata does not have this kind of facility, so you have to build your own or use one from an existing Application Servers.
111211 Jun 2006 @ 07:51 PDTDGiabbaiDatabaseReplyODBC Driver changing submitted SQLBefore going further on investigating, you'd try to enclose the case expression between parenthesis:cast( (case....end) as ...)Also, try executing the query via CLI (using BTEQ, for example). And l...
111111 Jun 2006 @ 07:40 PDTDGiabbaiDatabaseReplySecondary Index usageThe "explain" feature gives the execution path of a query, telling you which indexes are used and when they are used.E.G.: explain select * from dbc.tables;
111011 Jun 2006 @ 07:33 PDTDGiabbaiAnalyticsReplywhy does not aField like '[0-9][0-9]%' work?The only patterns available in like-expressions are % and _% matches same as .* (a sequence of chars)_ matches same as . (a single char)
110911 Jun 2006 @ 07:07 PDTDGiabbaiAnalyticsReplyHOW DO I ? ? ? ?Look at how to pivot a table (in your case, rows to columns) in the answer from Dieter at:http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=10&messageid=1285
110810 Jun 2006 @ 10:20 PDTVesoniDatabaseTopicPaging in Teradata for Web applicationHi,I try to create fast paging in web application?Is any SQL syntax in Teradata which is similairto LIMIT and OFFSET in MySQL?(Example: http://www.cgi-interactive-uk.com/mysql_paging_results.html)T...
110709 Jun 2006 @ 01:25 PDTwilliamdieterDatabaseTopicODBC Driver changing submitted SQLHey everyone, we're experiencing some strange behavior between an application and Teradata. Essentially, we are submitting a query, but the query is being rewritten. We have run some checks to see ...
110609 Jun 2006 @ 01:25 PDTTlovegaDatabaseReplynumber of CPUs per nodeat the command prompt type, pinfo -v. this willshow how many CPU's & speed.
110509 Jun 2006 @ 05:39 PDTak_tdataDatabaseTopicSecondary Index usageIs there a way to see how many times or at what times a secondary index was used?
110408 Jun 2006 @ 01:50 PDTTrishaJobsTopicINTERVIEW SESSION in DALLAS - June 20 & 21 Teradata PS Consultants - DBAs, Architects, Data Modelers, Project Managers, Tech LeadsTRANSFORMING TRANSACTIONS INTO RELATIONSHIPS NCR Corporation (NYSE: NCR) is a leading global technology company helping businesses build stronger relationships with their customers. NCR’s ATMs, r...
110308 Jun 2006 @ 01:48 PDTTrishaJobsTopicTeradata PS Consultants - DBAs, Architects, Data Modelers, Project Managers, Tech Leads -INTERVIEW SESSION in DALLAS - June 20 & 21TRANSFORMING TRANSACTIONS INTO RELATIONSHIPS NCR Corporation (NYSE: NCR) is a leading global technology company helping businesses build stronger relationships with their customers. NCR’s ATMs, r...
110208 Jun 2006 @ 11:15 PDTVincent GabrielliToolsTopictranspose dataIs it possible in teradata sql to transpose a row of data into a single field?i.e.row value1 A2 B3 C4 D5 ...
110108 Jun 2006 @ 07:34 PDTstami27-2406DatabaseReplyUDFHi the above from me was for unix.In TD the User Rights create alter and exec functions are nessesary.Here is the description for W2K found in UDF-Orange book:Full path specified to W2K server sour...
110008 Jun 2006 @ 07:24 PDTragavTrainingTopicHELP on Teradata Application Developer examHi,i recently completed my Teradata SQL certification and want to attend Applicaion Developer exam in short span.can anyone guide me for the same like what books& materials to prepare.ThanksRagav
109908 Jun 2006 @ 05:29 PDTNidhiDatabaseReplyUDFIs there any setting that I have to enable in Teradata to call the UDFs?Nidhi
109808 Jun 2006 @ 05:28 PDTNidhiDatabaseReplyUDFHello Stami,Thanks for the reply.EXTERNAL NAME 'SI!to_number!/my/home/udf/to_number.h!SS!to_number!/my/home/udf/to_number.c'Is this a Windows or Unix Server?I am using a Windows Server currently, b...
109708 Jun 2006 @ 05:16 PDTstami27-2406DatabaseReplyUDFHi, about the syntax above of the EXTERNAL: here is a exampel for header file and src file for an installation on the server: EXTERNAL NAME 'SI!to_number!/my/home/udf/to_number.h!SS!to_number!/my/...
109608 Jun 2006 @ 04:10 PDTstami27-2406DatabaseReplyUDFHi,In http://www.teradataforum.com/is huge amount of Tips and examples.eg.http://www.teradataforum.com/is_integer.htmgreetingsstami
109508 Jun 2006 @ 01:39 PDTNidhiDatabaseTopicUDFHello,Please give me an example. How to write a UDF.I have the C language function written. I also have the teradata database and the C compiler on the same machine.What is the default path on the ...
109407 Jun 2006 @ 10:56 PDTscwatsonJobsTopicTeradata CRM Opportunity - OhioWe are looking for an experienced CRM/Marketing analyst for a position with Verizon Wireless. Competitive pay and annual incentive. You can review job specifics below. To apply, please visit: http...
109307 Jun 2006 @ 08:22 PDTJim ChapmanConnectivityReplyExtended Stored Procedure to send mailIf all of your nodes have PEs, and the session that calls the SP can be hosted by any PE, then the answer is yes.

Pages