All forum activity

#DateUserForumTypeThreadPost
51715 Mar 2006 @ 04:45 PSTmackTrainingReplyPreparation for the Teradata SQL examI am too looking for TERADATA certification. I am working where i am using TERADATA SQL ASSISTANT & tools like multi-load. Anyone who has given the TERADATA certification please help us.Be in touch...
51615 Mar 2006 @ 02:41 PSTchithuramTrainingTopicTeradata Certification Questions HelpI want to go for teradata basic certification can u tell me where can i get the "Material"if u have this PDF can u share with me with regardsChidam
51515 Mar 2006 @ 01:09 PSTBuddyToolsTopicBTEQ logon problemHi,I am using the following syntax to logon to Teradata Demo thru BTEQ/BTEQWin:.logon demotdat/dbc,dbc;and having the following error:*** Error: Invalid logon!*** Total elapsed time was 1 second.T...
51415 Mar 2006 @ 12:58 PSTjinanJobsReplylooking for job: advanced teradata certified professionalWE ARE LOOKING FOR TERADATA SQL POGRAMMERS FOR USA. SEND RESUMES IMMEDIATELY TO goldenpearl@rediffmail.com
51314 Mar 2006 @ 01:47 PSTJerryJobsTopicTeradata Developer needed - Memphis, TN areaLooking for a Teradata developer for contract job for a term of 7+ months in Memphis, TN area. If you are interested in the job please give me a call @ 847-874-7153 or email me at Jerry@noblesystem...
51214 Mar 2006 @ 12:54 PSTsethiyaguToolsReplyAlert by Email during mload errorMr.Swamy,Could you please elaborate the steps, explain how to configure OS to get alert by email & also include any scripts that you have executed.Stration
51114 Mar 2006 @ 11:59 PSTssripadaToolsTopicHardware Level Compression when backing up dataWe use NetVault to backup Teradata and we use software level compression. Are there any advantages of hardware compression over software compression and if so I think we have to use tcm command. Ca...
51014 Mar 2006 @ 10:24 PSTApukadToolsReplyFastload from batch fileHi, the problem was the batcf file, because I had to correct it as following:Path C:\Program Files\Common Files\NCR\AXSMOD;C:\Program Files\NCR\Teradata Client\Bin;%PATH%;Echo Setting Rundate...fas...
50914 Mar 2006 @ 05:03 PSTApukadToolsReplyFastload from batch file =================================================================== = = = FASTLOAD UTILITY VERSION 07.06.00...
50814 Mar 2006 @ 05:01 PSTApukadToolsTopicFastload from batch fileHello Everyone,I have to create a fastload what imports data from an Oracle (8)database every day. I've created the amj file and the .fld file. (see the 00_cfm_data.fld and cfm.amj)If I use the ter...
50713 Mar 2006 @ 12:55 PSTJim ChapmanDatabaseReplyTable sizing in bytesFor an existing, populated table, you can query DBC.TableSize.Example:Select sum(currentperm) from dbc.tablesize where databasename = 'mydbname' and tablename = 'mytablename';
50613 Mar 2006 @ 12:51 PSTshaik.feroz@aaa-calif.comToolsReplyimport data from text filecould you please write the complete sql that you are using.plus are you using a BTEQ to do this or using fastexport and fastload to do this.try to cast the fields in you select while writing to a f...
50513 Mar 2006 @ 12:20 PSTTDUser-781UDAReplyconfidence showned in explain planHi dixon,if I were you I would collect stats on the joined columns of both right and left table.I think index join confidence is bettere than no confidence; I've heard that it is worst than low con...
50413 Mar 2006 @ 11:50 PSTdixonUDAReplyconfidence showned in explain planHi TDuserthanks for the reply especially last tip helped me lot, can u tell me something on Index Join Confidence, how the optimizer shows this kind of confidence.i checked the explain plan step wh...
50313 Mar 2006 @ 08:35 PSTdnoethDatabaseReplywhere does TD store transient journal?In perm space -> dbc.transientjournalBut that special table can grow over dbc's perm limit until the whole system runs out of perm space.Dieter
50213 Mar 2006 @ 08:09 PSTpoonamToolsTopicimport data from text fileHi, i tried exporting data and then importing it back as part of a where clause in a select query.but it does not give the desired result.it somehow always adds some characters to the output while ...
50113 Mar 2006 @ 04:22 PSTmatty.jiangDatabaseTopicwhere does TD store transient journal?in spool or perm space, or in memory?
50012 Mar 2006 @ 11:23 PSTGreatSushantDatabaseReplyTable sizing in bytesFormula(BlockSize -38_/RowSize = RowsPerBloclRowCount /RowsPerBlock = BolcksNumAmps *1024 = Header(Blocks * BlockSize )+ Header = Nofallback(Blocks * BlockSize )*2 + Header = fallbackParameters38 =...
49911 Mar 2006 @ 03:36 PSTycaiToolsReplyfastexport and fastload forutf8 tableYes.This script is wonderful help when need sync with differenct database not base on same box.the issue maby utf8 interrupt the data file on some way,what fastload can not read and understand even...
49811 Mar 2006 @ 05:59 PSTKoentjeConnectivityTopicHow to use Decimal(15,2)Can someone give me an example for a very simple UDF. I just want to have the C-code and the definition of the function.Name: UDF_Multiplyby2()Input: Decimal(15,2)Output: Decimal(15,2)To do: Multip...
49710 Mar 2006 @ 07:45 PSTrakujeDatabaseTopicTable sizing in bytesHello Experts,Could someone tell me how I could calculate the table size of a teradata table in bytes?Appreciate your help!Regards,jerk
49610 Mar 2006 @ 11:31 PSTrajeevmovvaDatabaseTopic.NET Data Provider for TeradataI installed .NET Data Provider for Teradata. I followed all instructions and even installed the prerequisites. However, I could not reference the dll in my .NET code. I used the code: IMPORTS TERAD...
49510 Mar 2006 @ 11:20 PSTrlaskarDatabaseTopicNeed syntax on Dynamic SQLI am trying to write a SQL which would generate SQL based on table name and column provided. The SQL should ask for tname and colname and after that it would generate a SQL. Sample of the SQL would...
49410 Mar 2006 @ 10:21 PSTshaik.feroz@aaa-calif.comDatabaseReplySpool Space Errorcould you send the query that you are using.There could be a lot of reasons why you get spool error.and check the explain too to see how the rows are getting distributed
49310 Mar 2006 @ 08:43 PSTSathishDatabaseReplyTimestamp format on teradata retrievalHi , Default timestamp format : yyyy-mm-dd hh:mm:sssel current_timestamp 2006-03-10 07:17:58.37So specify the desired format: as ex1:select '03/07/2006 12:49:29' as ts,cast(cast(ts as timestamp(0...

Pages