All forum activity

#DateUserForumTypeThreadPost
24401 Feb 2006 @ 07:16 PSTTarunaJobsTopicOpening for MicroStrategy/BO Developer, MicroStrategy Admin, Teradata ETL Developers for Bangalore Location Hi , We have urgent permanent positions directly with our top notch Client at Bangalore.MicroStrategy/BO Developer: Should be an engineering candidate with 6+ yrs of software development experience...
24331 Jan 2006 @ 10:49 PSTrkeith01AnalyticsReplyTeradata function equivalent to 'LIKE %..%' in TeradataDDIn Teradata your example would be:SEL * FROM emp WHERE empnm LIKE 'dd%';
24231 Jan 2006 @ 04:16 PSTddppAnalyticsTopicTeradata function equivalent to 'LIKE %..%' in TeradataHi all,Can anyone please let me know A teradata function which is equivalent to LIKE in Oracle.Eg. Select * from EMP where empnm=like'dd%' in oracle databasePlease write in TeradataPlease respond A...
24131 Jan 2006 @ 03:22 PSTjkurzyConnectivityTopicOracle Gateway - Teradata ODBC - unable to insert datesHello,I am using the Oracle Gateway for Teradata, Teradata ODBC version 3.5. I have created a table in Oracle and loaded it with 5000 rows. I created the same table in Teradata and attempted to loa...
24031 Jan 2006 @ 03:19 PSTAdiToolsTopicMload giving error UTY0800 CLI error: DBCHWAT returned 231Hi,I am trying to run mload (VERSION: 07.08.00.00) on Solaris 9 to load Teradata V2R6 table. I have CLIV2 (VERSION: 04.08.01.00) installed on the machine. When i execute mload, I get this error:1...
23930 Jan 2006 @ 03:43 PSTjchenConnectivityTopicTeradata ODBC Trouble in MS/AccessHi, I have installed the Teradata ODBC/SQL Assistant software thru "Ttu71_tup_utilities Nov 25 2003 BCD0-0652-0000’ - Teradata ODBC version 5.1.2600.2180. My purpose is to access our Data Warehou...
23828 Jan 2006 @ 11:49 PSTjaiConnectivityReplyNullPointerException in TdgssConfigApiThis exception appears to occur on Windows 2003 server machine regularly. Is Teradata driver compatibile with Windows 2003 Server?
23727 Jan 2006 @ 05:47 PSTmeet_asToolsTopicCan we call bteq script in mload script.Hi,Can we call bteq script in mload script.Please advice. Thanks
23627 Jan 2006 @ 12:34 PSTjaiConnectivityReplyNullPointerException in TdgssConfigApiWe are seeing this exception quite frequently, if not always. Can someone point me to developers of Teradata driver or may be some place where this issue can be taken up.
23527 Jan 2006 @ 11:23 PSTbanda27ToolsTopicWarehouse BuilderI am getting an error when loading a Delimited text file using Warehouse Builder. Has any one encounter this...*************************************************************************************F...
23427 Jan 2006 @ 09:38 PSTmeet_asToolsTopiccan we force mload to check the Application error tableHi,I have requirement - signal a pager if there is any "Aplication Error Table"(mload "Aplication Error Table" say E2 table) created by mload script. Can we force mload to check the E2 table that i...
23327 Jan 2006 @ 02:58 PSTdnoethDatabaseReplyGrant References...Hi TD_Arch,did you try that before? *** Failure 3706 Syntax error: Attempt to grant/revoke REFERENCES on database object.Hi dsearl,sorry, but you can't grant references on a database level.Why do y...
23227 Jan 2006 @ 02:37 PSTTD_ArchDatabaseReplyGrant References...The following statement will grant on the entire db at once:grant references on DB to user;You may consider appending "WITH GRANT OPTION" too.
23126 Jan 2006 @ 12:37 PSTSunil AgrawalTrainingTopicHow many Certified Teradata MastersHi,Can anyone tell me, approx how many Certified Teradata Masters are there in total.Regards,Sunil
23026 Jan 2006 @ 11:30 PSTJim ChapmanDatabaseReplyDelete / truncate commandIn general, the unqualified delete statement uses a "superfast" method similar to what you described for the truncate command (and essentially the same as for drop table) whenever it can do so with...
22926 Jan 2006 @ 10:26 PSTTeraTintinToolsReplyQuryman ErrorThank You HH.I was having issues with ODBC, surprisingly I was able to use BTEQ and Datastage.
22826 Jan 2006 @ 08:58 PSTBBR2ToolsReplyBatch locking issueLuke,Only way to see blocked process is by turning on Locking Logger.I believe you cannot query the sessions which may have acquired locks w/t Locking logger. You may see if there are any blocked p...
22725 Jan 2006 @ 08:22 PSTKrishan.RDatabaseTopicPopulating QCD from DBQLHi,I need your help on this one. How you populate your QCD database from DBQL database? What I am looking for is to populate the QCD databases with data from DBQL(Demographics/Statistics/Plan etc)....
22625 Jan 2006 @ 05:26 PSTpraveen76JobsTopicTeradata Application Designer in Atlanta, GAThere is a immeidate requirement for a Application Designer-IIIJob Description :Designs the application, solicits refinement of user requirements, obtains consensus about the project with users and...
22525 Jan 2006 @ 04:35 PSTdsearlDatabaseTopicGrant References...I need to grant 'references' to user/roles, but I can't figure out how to do the whole database at once. The only way I can find it is the following:grant references on db.table to userIs there a ...
22425 Jan 2006 @ 01:13 PSTPhaniThird Party SoftwareReplyTeradata and Ascential Data StageMy suggestion is to check the query submitted to the database. We may not see the exact query that is submitted via BTEQ. Some times these tools generate data mismatch conditions. Due to this optim...
22325 Jan 2006 @ 12:20 PSTSafeway Technology RecruiterJobsTopicSafeway (Fortune 50) immediate need for Senior Teradata DBA (full-time)Please respond directly with interest to: steve.taylor2@safeway.com or contact me directly at 925-951-4751 to discuss the opportunity. This is one of multiple Teradata-related opportunities curren...
22225 Jan 2006 @ 08:52 PSTLuke SmithToolsReplyBatch locking issueHi hh,Its actually a query fired from our microstrategy reporting facility given to the users. This is all valid, as I have checked that and the query should be locking at table level in order to u...
22124 Jan 2006 @ 04:52 PSThhAnalyticsReplyRead data from txt file using Procedure/function in Teradata ??If you are try to use a command line tool to output results, then use BTEQ.
22024 Jan 2006 @ 04:49 PSThhAnalyticsReplyinteroperability with email and smsdepending on what your program does with Teradata. If it just going through odbc and grab data from the database, then no problem. I am not familiar with sqlmail but I think if this is what it sup...

Pages