#DateForumTypeThreadPost
1723 Feb 2006 @ 05:36 PSTDatabaseReplyinfluance record length on the performanceHi Just for your information, when looking at PERM and Spool space think of the following:Perm is like a the fuel in your cars tank when you reach it you job fails. Spool on the other hand is like ...
1623 Feb 2006 @ 05:30 PSTToolsReplyDate Format In Teradata SQL AssistantHi The above reply is correct, and you could also use the CAST function.select CAST((date1 (format 'yy/mm/dd')) as char(8)) from testuser.test3;
1523 Feb 2006 @ 05:18 PSTTrainingReplyHow many Certified Teradata MastersHiI am not sure but I think it is around 800 worldwide. I know there are five TD Masters in South Africa, I am one of them and TD Master number 3 in South Africa.
1423 Feb 2006 @ 05:16 PSTDatabaseReplyBTEQ ConnectionHiYour BTEQ must start with.logon TDEMO/USERID,password;It think for the TeraData demo it is.logon TDmon/dbc,dbc;Also BTEQ will not work unless your etc host file does not contain the following ent...
1323 Feb 2006 @ 05:08 PSTToolsReplyBteq in Report formatHII suggest you set your export titles correctly for this to work. If you gave me more information, like table layout and sample data I could recreate it on my computer and send you the results.Her...
1223 Feb 2006 @ 04:56 PSTTrainingReplyPreparation for the Teradata SQL examHi AGAIN!Before anyone asks me for the link for the TeraData Demo CD it is http://www.teradata.com/t/page/129759.This demo will work on your PC or Laptop and is a "full" version of TeraData but onl...
1123 Feb 2006 @ 04:54 PSTTrainingReplyPreparation for the Teradata SQL examHi Sorry my tying fingers are not working today.Lick should be LUCK... No Such LUCK....
1023 Feb 2006 @ 04:53 PSTTrainingReplyPreparation for the Teradata SQL examHiNo such lick guys. I suggest reading the SQL manual as supplied on the TeraData demo CD and practice every comaand till you understand it.
923 Feb 2006 @ 04:51 PSTJobsReplylooking for job: advanced teradata certified professionalthat was for the record....
823 Feb 2006 @ 04:50 PSTJobsReplylooking for job: advanced teradata certified professionalHi For the record a TD Advance Professional has completed the following certification courses:Certified ProfessionalCertified Implemetation SpecialistCertified SQL Specialist
723 Feb 2006 @ 04:48 PSTToolsReplyMultiload vs TpumpHiJust a short list:MultiLoad=========* Loads data to TeraData from aMainframe or Lan flat file* Multiple tables can be loaded in the same MultiLoad.* Up to 20 INSERTS, UPDATES, or DELETES on upt o...
618 Jan 2006 @ 02:48 PSTDatabaseReplySession modes in TeradataHiHere are the main differences: TERADATA MODE / ANSI MODE=========================================================================================== Comparison are ...
518 Jan 2006 @ 02:25 PSTUDAReplyOpportunityHi SteveDo these posts include foreigners. I am a South Africa (Teradata Master).Divvy
403 Jan 2006 @ 01:27 PSTToolsReplyFastLoad 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...
303 Jan 2006 @ 01:22 PSTToolsReplySQL 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 ...
203 Jan 2006 @ 01:09 PSTDatabaseReplytable size without indexesHiI generally use the following query to determine table sizes.select databasename, tablename, sum(currentperm)from dbc.tablesize where databasename = 'DBA' and tablename = 'testing' group by...
103 Jan 2006 @ 01:02 PSTDatabaseReplyString ReplacementHiI agree, I have tried using a normal Update "update dba.testing set linea = 'or' where linea like '%and%' ;"But one gets a duplicate error. You can do this with a program or a UDF.Divvy

Pages