All forum activity

#DateUserForumTypeThreadPost
5766610 Jun 2016 @ 12:56 PDTJustMeDatabaseReplyNo spool space error,when running SP in BTEQ.And how much spool is currently allocated to that User ID?
5766510 Jun 2016 @ 12:48 PDTJustMeDatabaseReplyNo spool space error,when running SP in BTEQ.What does your stored procedure do?  Does it perform aggregation?  Are you joining tables?  have you run explains on the underlying code?
5766410 Jun 2016 @ 10:16 PDTtsaloniaTeradata StudioReplyIs there a way to modify Connection Properties of DB Connections through some external Windows config file?ok, for option 1 above, each user may have a different name for a given connection to a particular server, since these names are customizable.  how would we address this with a generic .xml fi...
5766310 Jun 2016 @ 09:59 PDTfgrimmerTeradata StudioReplyIs there a way to modify Connection Properties of DB Connections through some external Windows config file?Yes, but it is encrypted.
5766210 Jun 2016 @ 09:01 PDTfeinholzToolsReplyTPT attributes SkipRows and SkipRowsEveryFileNo. You either skip the 'n' rows in one file or all.
5766110 Jun 2016 @ 07:52 PDTGnomeDatabaseReplyCalling Dnoeth your expert opinion is requried and a easy question. Please respond.Next question from the user is it possible to set up customizable setting for spool per amp at the run time?   I suspect I know what the answer is.   Again Thanks in advance The Gno...
5766010 Jun 2016 @ 07:44 PDTGnomeDatabaseReplyCalling Dnoeth your expert opinion is requried and a easy question. Please respond.Thank you sir
5765910 Jun 2016 @ 07:36 PDTdnoethDatabaseReplyGetting YYYYMMDDHH FORMATThe simple way: to_char(Start_Time, 'YYYYMMDDHH24')    
5765810 Jun 2016 @ 07:33 PDTdnoethDatabaseReplyCalling Dnoeth your expert opinion is requried and a easy question. Please respond.You hopefully got the same answer three times: Spool/Temp/Perm space is always divided by the number of AMPs in the system. That's why you might need to assign a huge spool due to skewed proc...
5765710 Jun 2016 @ 07:04 PDTGnomeDatabaseTopicCalling Dnoeth your expert opinion is requried and a easy question. Please respond.Dieter We have a simple question that but our user will only accept your reponse as being correct.  The question is, is an profile's spool divided accross the total number of AMPS on a sy...
5765610 Jun 2016 @ 06:28 PDTBRIANHDatabaseReplyDATE - 'SELECT DATE' RETURNS AN INCORRECT DATEthank Johannes... resetting the linux date and time completed my fix.  Thanks again for your advice.
5765510 Jun 2016 @ 05:44 PDTSurendhar ReddyTrainingReplyTeradata 14 basics certification informationThanks a lot Rakesh, the link you provided is very usefull and that PDF is very informative.
5765410 Jun 2016 @ 05:44 PDTtsaloniaTeradata StudioReplyIs there a way to modify Connection Properties of DB Connections through some external Windows config file?Are these connection profiles stored in a file somewhere on the OS?
5765310 Jun 2016 @ 04:58 PDTomerfDatabaseTopicGetting YYYYMMDDHH FORMATHi, I have column which name is Start_Time and it includes '4/26/2016 18:14:57.000000' .  i want to take 2016042618 output (YYYYMMDDHH). How can i get it ?    Thank you. ...
5765210 Jun 2016 @ 04:52 PDTJustMeDatabaseReplyUnable to release locksThanks Fred... We will perform our quarterly refresh later this month, so I know that will take care of it.  Was just wondering if there was any other way.     Thanks agai...
5765110 Jun 2016 @ 04:35 PDTeric_tdDatabaseReplyTERADATA on Windows 10Hi, Will Teradata Vmware edition work on Windows 10. It works fine on Win7. I would be having intel i3/8GB RAM/ Win 10 64bit OS. Would it work fine? Or would I need i5 processor
5765010 Jun 2016 @ 04:15 PDTkeerthi1987DatabaseReplyNo spool space error,when running SP in BTEQ.Hi ashok_paswan, We have checked the skew factor for single customer table, we are getting below results,   T001_Test_Invoice_Raw 2482.03369140625 0.10...
5764910 Jun 2016 @ 03:46 PDTRajudeepakDatabaseReplyCopying trillions of data to new tableHello, Help me with a query to purge data from the below table. This table has 670,235,825,680 rows. I'm trying to delete around 164,154,526,390 rows using cal_dt column. del from pr_us_inv.s...
5764810 Jun 2016 @ 12:01 PDTJohannes VinkDatabaseReplySeeing Junk character when inserting hyphen (-)The utf-8 session recommendation I knew, but the detailed explanation why in this case it is going wrong... wow. Beside that: don't query DBC.TABLES, but query DBC.TABLESV if available on your...
5764709 Jun 2016 @ 11:58 PDTJohannes VinkDatabaseReplyDATE - 'SELECT DATE' RETURNS AN INCORRECT DATESELECT DATE returns the current date from the database/OS. I guess your VM date/time is not up-to-date...
5764609 Jun 2016 @ 11:57 PDTJohannes VinkDatabaseReplyCurrent date as column name in select querySet the alias between double quotes: AS "CURRENT_DATE"
5764509 Jun 2016 @ 10:42 PDTAVOTViewpointTopicData Labs Installation QuestionHi all I'm currently using Viewpoint 15.00.01.008 and TD DB: 15.00.03.01 and I am installing the tddatalabsportlets version v15.00.00.04-1. 1. I get the rpm file for tddat...
5764409 Jun 2016 @ 10:34 PDTsneha.gToolsReplyTPT attributes SkipRows and SkipRowsEveryFileThanks for clarifying Steve. I have another question. Let's say, there are 5 files and the files are loaded in serial order (i.e. it doesn't get loaded parallely). Out of 5 files, 2 files...
5764309 Jun 2016 @ 07:02 PDTVishnujpDatabaseTopicCurrent date as column name in select queryHi All, I need to set alias to a column name as current_date in the format (DDMMMYYYY) in a select query (Teradata version 14). Eg: Select case when ... then       ...
5764209 Jun 2016 @ 03:10 PDTBRIANHDatabaseTopicDATE - 'SELECT DATE' RETURNS AN INCORRECT DATEI'm running an old version -Teradata 13.0  under VMWare - Linux.  I've had the issue of SELECT DATE; returning an incorrect date. I'm now attempting to correct this problem. ...

Pages