#DateForumTypeThreadPost
3526 Oct 2009 @ 01:53 PDTUDATopicSQL Question.User would like a view built on table that would return a record for each date between eff_bgn_dt and eff_end_dt having invry_qty constant for each group of records.Table Structure:CREATE TABLE PRO...
3410 Jul 2009 @ 01:28 PDTDatabaseTopicCron SchedulingI'm setting up some arc scripts to refresh a few tables to our Dev Box weekly.Since I'm running these on a Dev node, I want to try using cron as my schedular.The first command works fine but my she...
3311 Nov 2008 @ 08:20 PSTUDATopicRestoring Database DBC to another Teradata RDBMSTo Restore DBC from Prodction System to DR system does Sysinit and Dip need to be run ?They both are 12.0 but Produciton has more nodes/amps.Thanks, RG
3211 Mar 2008 @ 09:09 PDTUDATopicExclusive LockAn existing ETL job at my site is coded with an exclusive lock applied to delete rows from a table.I presume this was coded this way to ensure no one accessed an empty table between the delete and ...
3105 Mar 2008 @ 08:19 PSTToolsTopicOptimal Fastload/Multiload sessions.When choosing how many sessions to use in a fastload or mutiload job,what should be considered to choose the optimal number?Thanks,TBob
3011 Dec 2007 @ 12:35 PSTDatabaseTopicIncorrect answerset.When selecting from table where col1 is = 0records where col1 is = ' ' are being returned. Column is Char(1)Is this normal?create table dsb.zero_null(col1 char(1),col2 smallint,col3 smallint)primar...
2923 Oct 2007 @ 11:06 PDTThird Party SoftwareTopicTeradata query not finishing when executed from DataStageHello all,I have a developer running a process using Datastage 8A query is executed on Teradata but does'nt finish.From Pmon the session is idle and pe state is response. It stayed in this state al...
2818 Oct 2007 @ 02:18 PDTAnalyticsTopic.Net Provider query timeout expired.All,I'm getting results on smaller queries however on large I get this error:ERROR [HYT00] [NCR][ODBC Teradata Driver] Query timeout expiredWhere can I change this setting?Thanks, TBob
2701 Oct 2007 @ 12:53 PDTDatabaseReplyDBQL log for Modify UserLeo,LastAlterName on DBC.Users should suffice.Tbob
2625 Sep 2007 @ 01:26 PDTDatabaseTopicSecondary Index causes query to peform poorly.Hi all,I have an instance where removing a secondary index from a column used in the where clause of a query is allowing it to run much faster - seconds vs. minutes.The index is on a large + 1TB ta...
2516 Aug 2007 @ 12:47 PDTAnalyticsReplyHow can we Reverse a String in Teradataselect substr('STAGINGAREA',(chars('STAGINGAREA')),1) ||substr('STAGINGAREA',(chars('STAGINGAREA')) -1,1) ||substr('STAGINGAREA',(chars('STAGINGAREA')) -2,1) ||substr('STAGINGAREA',(chars('STAGINGA...
2409 Apr 2007 @ 04:54 PDTToolsReplyGenerate DDLExecute the results from these two queries.SELECT 'SHOW TABLE ' || TRIM(DATABASENAME) || '.' ||TRIM(TABLENAME) || ';' FROM DBC.TABLESWHERE TABLEKIND = 'T'; SELECT 'SHOW VIEW ' || TRIM(DATABASENAME)...
2315 Mar 2007 @ 11:20 PDTUDAReplyApplication Error Table code 2797This is handy for a quick check on errors:select * from dbc.errormsgswhere errorcode = 2797ErrorCode ErrorText2797 MLoad MARK MISSING UPDATEof course the manuals have much more detail.Bob
2212 Mar 2007 @ 04:58 PDTUDAReplyOdd Error when attempting to create a macroPost your create ddl,may be able to help.
2108 Mar 2007 @ 04:42 PSTUDAReplyHow can I get stats recommendation from Explain?except spell it diagnostic
2008 Mar 2007 @ 04:41 PSTUDAReplyHow can I get stats recommendation from Explain?Try "Dianostic HelpStats"
1914 Feb 2007 @ 02:45 PSTDatabaseReplyNeed to convert a TimeStamp column value to Simple Date Format1. select cast(current_timestamp as date);2.select calendar_date from sys_calendar.calendarwhere week_of_month = 2and day_of_week = 7 TBob
1808 Feb 2007 @ 02:31 PSTAnalyticsReplyto Obtain the 5-character code (translated into upper-case) following the fourth commaChinna,Something like this could be used in this case: SELECT UPPER(PTL_STR) FROM(SELECT SUBSTR(PTL_STR,POSITION(',' IN PTL_STR) +1,5) FROM(SELECT SUBSTR(PTL_STR,POSITION(',' IN PTL_STR) +1, 50) FR...
1701 Feb 2007 @ 10:38 PSTUDAReplyNeed A Career Switch to Data WireHousingYes there is a training topic below this one.A good place to start is the Certification information on Teradata.com,also www.CoffingDW.com provides lots of materials.
1607 Dec 2006 @ 12:04 PSTDatabaseReplyStored Procedure ProblemThe alternative of casting to a char worked for me.Thanks,
1506 Dec 2006 @ 07:30 PSTDatabaseTopicStored Procedure ProblemHello all,I'm trying to create a stored procedure that will 1. Create a Table2. Populate the table from sys_calendar.calendar base on input parm.3. Move that to output parm.4. Drop the tableQuestio...
1430 Oct 2006 @ 02:23 PSTDatabaseReplyLooking for View Definition in DBC tableSorry, that's -> show view databasename.viewname;
1330 Oct 2006 @ 02:22 PSTDatabaseReplyLooking for View Definition in DBC tableJust use command -> show view
1216 Oct 2006 @ 10:05 PDTDatabaseReplyChanging date FormatKavya,You could alter table to add date_2 format 'YYYY-MM-DD', then update this with column date_1 data.If you really only need one date column in the end,just alter the existing columns format -- ...
1112 Oct 2006 @ 05:03 PDTDatabaseReplyselect a row previous from the Max value.Kayava,something like this should work: create volatile table VT acct_id char(10), maxdate date)on commit preserve rows.insert into VT select acct_id, max(end_date)from tablegroup by 1;select acct_...

Pages