#DateForumTypeThreadPost
2909 Feb 2010 @ 12:32 PSTJobsTopiclooking for Teradata work in Montreal, Quebec, canadain lite of the recent restructuring at Bell Canada, I have been placed on the side line. do any of you know any Montreal based companies that have Teradata as there data-warehousing platform... I...
2801 Oct 2009 @ 05:07 PDTToolsTopicDBC.DBQLogtbl Application id meaning/definitionsHello support team members, I need your help. in the DBC.DBQLogtbl there is a field named APPID (The application ID under which the query is submitted) does anyone know what UVSH stands for? Exa...
2718 Nov 2008 @ 10:38 PSTToolsTopicidentify all the views in a specific database that have been accessedHello follow Teradata users, need your helpI need to identify all the views in a specific database that have been accessed (there are 504 Views in this particular database BMMKTG). ExampleDatabase...
2624 Oct 2008 @ 02:16 PDTToolsTopicrequire a Stored procedureteam, I need your help... can someone out there in Teradata land send me a stored procedure that will pickup a file format (txt, csv) and load into a teradata table. I can do this with BTEQ, howe...
2509 Sep 2008 @ 11:21 PDTToolsTopicHow does Teradata handle Stored proc'sHello fellow Teradata clients, I need some clarification and understanding concerning stored procedures (SP). I will give you an actual example of what is going on…Database: My_ViewsTotal alloca...
2430 Oct 2007 @ 11:38 PDTToolsReplyCode = 2644 No more room in databaseThks Fred... much appreciated. I will start an investigation
2330 Oct 2007 @ 10:17 PDTToolsReplyCode = 2644 No more room in databaseHi Fred, I ran you suggested script... however how do I interpret the results (see below) are they good, bad, should be investigated ???select TableName, sum(CurrentPerm) as ActualSpace,count(*)*(...
2211 Oct 2007 @ 06:22 PDTToolsTopicTDManagerevening folks, having some TDManager problems. was working the other day and all of a sudden we have been getting this error message...Cannot load profiles from Database. error 207(MTDP:EM_NETCON...
2130 Jul 2007 @ 11:47 PDTToolsReplyUpgrade to V2R6thanks, we have PPI and will be keeping the before and after explains
2026 Jul 2007 @ 10:58 PDTToolsTopicUpgrade to V2R6Hello fellow forum members, we at Bell Canada will be getting an upgrade from V2R5 to V2R6 in August of this year. Does anyone out there have any test plans available of what we should verify befo...
1923 Jul 2007 @ 12:49 PDTToolsTopichelp... on passing parms into scriptneed to change the file date in BTEQ script every month (example 200706). what is the method that I can pass the Year and Month either in a file or any other methods. this date will be passed to ...
1816 Apr 2007 @ 02:47 PDTToolsReplySystem performance scriptI found the system Macro's and works great.. I have all the numbers that I need and more... thks Barry
1713 Apr 2007 @ 05:16 PDTToolsTopicSystem performance scriptHello folks, does anyone have an SQL script that will display the system busy during different hours of the day. I have been asked to provide an analysis on system performance because of recent pr...
1612 Apr 2007 @ 04:11 PDTToolsTopicAccessRight definitionsAnyone know the AccessRight definitions for IX and RFWriting a program that will list the complete list of access rights for a Teradata idSEL 'GRANT '||CASEWHEN ACCESSRIGHT = 'CD' THEN 'CREATE DATA...
1527 Mar 2007 @ 09:34 PDTToolsReplyBTEQ examplesThank you for all your assistance.. I have used some of the suggestions and works very well... great team approach :-)
1427 Feb 2007 @ 01:52 PSTToolsReplyRemove leading Zeros in fieldFolks I found the answer thank you for your viewing.the Trim function did the trick...Select src_appl_acct_no, trim (LEADING '0' FROM src_appl_acct_no)From symmktg.vsym_cust_acct sample 10
1326 Feb 2007 @ 12:46 PSTToolsTopicRemove leading Zeros in fieldHello everyone,I need to remove leading Zeros from a client file… what is the quickest method?00073652 should read 73652
1202 Feb 2007 @ 12:20 PSTToolsTopicremove French chars from fileHi Folks, I have received a client file which contains French characters I need to replace them with English characters. how can I do this using SQL.example: extérieur Côté should be translat...
1115 Sep 2006 @ 07:32 PDTToolsReplyBTEQ examplesThank you for the examples... much appreciated
1014 Sep 2006 @ 02:53 PDTToolsTopicBTEQ examplesFellow forum members, I need to build/write some BTEQ scripts to pickup data from laptop folders example e:\my_data\my_excel_file.txt and upload/create a file on our Teradata data mart.Are there an...
907 Sep 2006 @ 04:27 PDTToolsTopicSame query different results why?I ran the query @ 10 am and received 386 records...I ran the same query (no changes) @ 10:23 and received 8,691 records...What could cause this phenomenon??? Here is the queryIf the table/view is ...
810 Aug 2006 @ 02:48 PDTToolsTopicSelect Top 10 recordshello folks, trying to perform the following SELECT TOP 10 call_session_idFROM etlbase.vivr_call_dtlto get the top 10 records of the table. However, I get the following error: 3706: Syntax error: e...
714 Jun 2006 @ 02:39 PDTToolsTopicTeradata Query SchedulerScheduling Queries for Later Execution Requests issued by Teradata SQL Assistant where can I get a copy of Teradata Query Scheduler ? is it free?can someone provide a copy or link
608 Jun 2006 @ 11:15 PDTToolsTopictranspose dataIs it possible in teradata sql to transpose a row of data into a single field?i.e.row value1 A2 B3 C4 D5 ...
505 May 2006 @ 04:51 PDTToolsReplydelete primary indexThanks to all the replies, I have corrected the SQL script accordingly

Pages