All forum activity

#DateUserForumTypeThreadPost
46707 Mar 2006 @ 10:23 PSTayesDatabaseTopicteradata database service is not startinghi,I installed teradata from the demo cd on win xp. When I tried to access the database from sql assistant or bteq I am getting the following message-10065 WSA E HostUnreach: The teradata server ca...
46607 Mar 2006 @ 09:56 PSTPajinkODatabaseTopictimestamp to timestamp(0)I want to insert data from source table to destination table.In source table some column is timestamp (2006-01-25 00:00:00.000000) and destination table is timestamp(0) (2006-01-25 00:00:00) insert...
46507 Mar 2006 @ 06:16 PSTtstover-109DatabaseReplySecondary Index They say the only thing worse than no statistics is stale statistics. The technical consensus is that if you can't collect stats then there's no point in having a nusi. If you're not able to coll...
46407 Mar 2006 @ 05:57 PSTVik2006ToolsReplyMLOAD acquisition phase countYou are right. Thanks. I have one more problem while implementing the alert mechanism.Basically when these is any error table generated during the MLOAD, I want to send an email. As per the manual...
46307 Mar 2006 @ 05:45 PSTtstover-109ToolsReplyAutonumber as Composed key Identity columns cannot be used as part of a composite primary or secondary index. It doesn't make sense as part of a PI since the identity is inherently unique. Take a look at the create table ...
46207 Mar 2006 @ 05:26 PSTCoghanDatabaseTopicHow to Use Input ParametersI am not new to SQL, but I don't know all the ins and outs of coding using Teradata's version of SQL. I have been able to read just enough to know that there is a way to set up input parameters us...
46107 Mar 2006 @ 10:53 PSTdnoethToolsReplyMLOAD acquisition phase countHi Vikas,you are wrong ;-)But you can access those variables only after the END MLOAD.If you need that info *during* the load you'll have to program a NOTIFY exit.Dieter
46007 Mar 2006 @ 10:24 PSTVik2006ToolsReplyMLOAD acquisition phase countDieter,Please correct me if I am wrong. These variables are used in the application phase of MLOAD. I am looking for count variables in the acquisition phase.Regds.
45907 Mar 2006 @ 10:17 PSTBrianOttJobsTopicTeradata Systems Engineer - Minneapolis/St Paul areaI have a contract position in the Minneapolis/St Paul area (Zip Code: 55479) for a Teradata Systems Engineer for six month to one year with an option to hire by my client. I will consider both W2 ...
45807 Mar 2006 @ 08:29 PSTsharma.anuragThird Party SoftwareTopicCalling sp through ODBCHi All,I am facing a problem while call an stored procedure from odbc driver.I m working with asp.net and my database is teradata. The page gets hanged while i call stored procedure.If anyone have ...
45707 Mar 2006 @ 07:40 PSTdnoethToolsReplyMLOAD acquisition phase countHi Vikas,what version of MLoad are you using?MLoad supports that since several years:SYSAPLYCNTSYSNOAPLYCNTSYSRCDCNTSYSRJCTCNTCheck the manuals for details...Dieter
45607 Mar 2006 @ 07:22 PSTJoe LaMattinaToolsReplyMVS Load Utilities accessing Unix File Path SystemResponse per NCRTPT ( Teradata Parallel Transporter ) can allow users to access files on USS and MVS, which means we also support the access to HFS. Other utilities don't have that capability. TP...
45507 Mar 2006 @ 06:52 PSTdnoethDatabaseReplyTimestamp format on teradata retrievalHi Jas,select '03/07/2006 12:49:29' as ts, ts (timestamp(0), format 'MM/DD/YYYYBHH:MI:SS')Dieter
45407 Mar 2006 @ 04:14 PSTjasDatabaseTopicTimestamp format on teradata retrievalI have a parameter string coming into an ETL application which is in the format MM/DD/YYYY HH:MI:SS.On the teradata database the rows I need to retrieve contain a timestamp in standard teradata for...
45306 Mar 2006 @ 11:31 PSTA EarlJobsTopicHighly experienced Lead Architect needed with Teradata knowledge in AustraliaI am on the look out for solid Lead Architect with Teradata knowledge. It is to work for one of the largest technology solutions companies in world. He/She will be heading up a division for the Sou...
45206 Mar 2006 @ 05:53 PSTVik2006ToolsTopicMLOAD acquisition phase countIs there any way that I would get the mload acquisition phase count in the mload script? MLOAD support environment provides different variables (total ins, upd, del etc.) at the application phase, ...
45106 Mar 2006 @ 05:09 PSTKevin LiuToolsReplyLoading from a .txt file using OLE loadHow to load a Teradata table from a custom delimited text file usingthe OleLoad program that is included in the Teradata OLE DB AccessModule (just the interesting steps):- Create a new file. This ...
45006 Mar 2006 @ 04:47 PSTJoe LaMattinaToolsTopicMVS Load Utilities accessing Unix File Path SystemWe have a Unix file system sitting under MVS/ZOS. Has anyone been able to do a load from the MVS side replacing the INFILE ddname with an INFILE filename? We have to run from the MVS side (channel ...
44906 Mar 2006 @ 01:16 PSTdklasnerAnalyticsTopicOracle Function percentile_discI am looking for a way to perform the same functionality in Teradata as the Oracle Function percentile_disc performs. If anyone has logic or a udf that performs the logic in Teradata I would truly...
44806 Mar 2006 @ 12:28 PSTshaik.feroz@aaa-calif.comDatabaseTopicfastexport to fastloadGurus and all,I am using fastexport to write data to a file and the default MODE = INDICATORS and the default FORMAT = FASTLOAD.now I am not sure how to use this output file in the fastload script ...
44706 Mar 2006 @ 09:45 PSTRenato DbaDatabaseReplyQuery exceeding spool spaceHi,Some ideas:1. Run an EXPLAIN. Put the word EXPLAIN as the first line of your query. Check the resulting explanation of what teradata will do to run your query and the timings of each s...
44606 Mar 2006 @ 09:16 PSTTheTeradataKidDatabaseReplyDelete OperationIt will rollback all of the deleted rows.
44506 Mar 2006 @ 08:22 PSTraomanoharDatabaseTopicDelete OperationIf a delete query is runing for last 2 hours, I aborted it ...What is the impact ?
44406 Mar 2006 @ 08:21 PSTraomanoharDatabaseTopicQuery exceeding spool spaceA query is running for last 4 hours & it has exceeded Spool space ... What happens ? What all things can I do ?
44306 Mar 2006 @ 06:48 PSTTSToolsReplyFast ExportThanks a lot!It worked.Regards,TS.

Pages