All forum activity

#DateUserForumTypeThreadPost
9405 Jan 2006 @ 04:29 PSTJay GurjarAnalyticsTopicExporting Clementine models as Teradata SQLHiNew to the forum. We are trying out Clementine 9.0 s/w with our Teradata DW for some customer analytic applications.I have not been able to find a way to deploy the Clementine stream or just the ...
9305 Jan 2006 @ 01:11 PSTsingleampDatabaseTopicNeed to make SMP to MMPHello,Can you please share your expriences with Teradata SMP systems(single node)? 1. What are the NCR machines (WorldMark 4800?) supporting SMP?2. Whats the next compatile Hardware to make it MPP?...
9205 Jan 2006 @ 10:47 PSTPadmini-2242DatabaseTopicLogin to Teradat SQL assistantI am new to Teradata and I am trying to connect to sql assistant. I got the ODBC set up but when I try to login it gives an error message "160 specified driver could not be loaded system error 126...
9105 Jan 2006 @ 06:20 PSTtfaderDatabaseReplyCancel online transaction recovery after break big delete operationThank You so much for Your answer, butunfortunatenly, my version is 2 release 4 (FOUR) ! It's any posibility to break transaction recovery in this one. What about DB startup parameters, TPA boot mo...
9005 Jan 2006 @ 05:50 PSTgajulaToolsTopicAbout ETL process using Teradata utilitieshi, I am working on Informatica. I would like to know about the ETL process in Teradata using BTEQ,FastLoad,MultiLoad and FastExport. which one is used more in the process and how.And how to connec...
8904 Jan 2006 @ 09:41 PSTesexton@ebay.comConnectivityTopictdodbc.03.03.00.13: core dump Solari 5.8Hello-I upgraded tdodbc from 03.03.00.00 to 03.03.00.13, and when running an odbc connection (samples/C/adhoc), I receive a core dump.When I rollback to 03.03.00.00, everything works fine.Could you...
8804 Jan 2006 @ 03:42 PSTJim ChapmanDatabaseReplyCancel online transaction recovery after break big delete operationYou can use the CANCEL ROLLBACK ON TABLE command of the Recovery Manager utility. I believe this is available in 5.1 and later releases. If you use this command, the table is marked unusable, and...
8704 Jan 2006 @ 02:46 PSTtfaderDatabaseTopicCancel online transaction recovery after break big delete operationI'm looking for any issues for canceling online transaction recovery when TPA starts.I cannot drop, truncate or restore table because is locked by transaction recovery. The table is with no fallbac...
8604 Jan 2006 @ 11:49 PSTDGiabbaiDatabaseReplyString ReplacementThe following stored procedure performs the task of a Replace function for character data.In this form it can be used only from within another stored procedure.REPLACE PROCEDURE SysDBA.StringReplac...
8504 Jan 2006 @ 08:51 PSTBBR2DatabaseReplyString ReplacementAkhil,Crude as "Can be improved further"Vinay
8404 Jan 2006 @ 08:15 PSTTDUser-781TrainingReplyIs Teradata Certified Professional V2R6 (NR0-011) available to be taken?Hi, from the website you can find that it's TCPP v2r5.Bye,TDUser
8304 Jan 2006 @ 06:57 PSTMeenakshiTrainingTopicIs Teradata Certified Professional V2R6 (NR0-011) available to be taken?Hi,Can anyone please tell me what's the latest version in NR0-011? Is it TCPP V2R5 or V2R6?Regards,Meena
8204 Jan 2006 @ 04:49 PSTakhil.bansal@gmail.comDatabaseReplyString ReplacementHi Vinay, It works fine. thanks.But what do you mean by crude form ?
8103 Jan 2006 @ 06:09 PSTpattitJobsTopic3+ month contract in San Francisco for C# & Teradata DeveloperOur financial client has an immediate opening for a C#, .net with Teradata Developer.NO H-1Bs or 3rd parties for this position!!!!Preference to candidates local to the SF Bay Area!!!Job Description...
8003 Jan 2006 @ 03:48 PSTJim ChapmanDatabaseReplyGateway portsAll Teradata clients connect to TCP port 1025. That is the only port that you should need to forward through your firewall.
7903 Jan 2006 @ 02:43 PSTBBR2DatabaseReplyString ReplacementI came up w/t a Macro that can accomplish this.You may want to use the same logic in your procedure or SQL.REPLACE MACRO SYSDBA.REPLACE_STR ( SEARCH_STR VARCHAR(400), CHNG_STR VARCHAR(400)) AS (SEL...
7803 Jan 2006 @ 01:32 PSTGlotelIncJobsTopicNeeded: Teradata Data Warehouse DBA in New JerseyHello,One of my Clients in Central/North Jersey needs a Teradata Data Warehouse DBA. This is a PERMANENT position with a great salary! Required:Sr. Level Teradata DBA, proficient in Teradata tool...
7703 Jan 2006 @ 11:53 PSTDennis CalkinsDatabaseReplytable size without indexesYou can run ferret from Teradata Manager.
7603 Jan 2006 @ 09:35 PSTsurmikToolsTopicFastLoad vs NL CharacterI have a text file with records I want to import into Teradata with FastLoad. Columns are separated with a "|" character. There is a problem with a 'Comments' column containing rows with a new line...
7503 Jan 2006 @ 09:23 PSTNytewyndDatabaseReplyPassing the value for an IN clause to a stored procedure.Very helpful. Tagging for later.
7403 Jan 2006 @ 04:43 PSTANGELToolsTopic.DISPLAY in MLOADHi,I have a file which contain date fields. There is a possibility in which one of the fields can be blank so i am using .DISPLAY command to output the message to MVS. But it gives the error "End o...
7303 Jan 2006 @ 04:28 PSTsurmikDatabaseReplyString ReplacementOr you can:create table your_table2 as your_table with no data;insert into your_table2 select substring(your_field FROM 1 FOR INDEX(your_field,' and') -1) || ' or ' || substring(your_field FROM IN...
7203 Jan 2006 @ 03:27 PSTphil1212DatabaseReplytable size without indexesOk thanks.I need just an sql query, only dba have the tools gives in the first answer.For the second, are you sure this doesn't include indexes size ?
7103 Jan 2006 @ 01:27 PSTXTUPIEToolsReplyFastLoad CheckpointHiJust a quick tip, if your Checkpoint is set to below 60 it defaults to minutes not records!So you might not want a checkpoint every 2 minutes, would you?Rememebr Checkpoint has got to do with fal...
7003 Jan 2006 @ 01:22 PSTXTUPIEToolsReplySQL Query - DBQL tableHiJust remember to occasionally clean out those DBQL tables in DBC, it is possible to fill your DBC and run out of space if you are not careful. I suggest that you create a copy of them in another ...

Pages