#DateForumTypeThreadPost
48005 Jan 2009 @ 09:03 PSTDatabaseReplyCount on number of cursors openedA session can have a max of 16 open result sets (Aka responses). it doesn't matter whether you are doing it in a procedure or in another proc called from that. The tally goes at session level not a...
47903 Jan 2009 @ 03:58 PSTDatabaseReplyNon equi join conditionit's difficult to suggest something without knowing the actual joins / cardinailty /PIs and the explains.Most of the time when you have a non-equi join in the condition, the optimizer will chose to...
47803 Jan 2009 @ 03:44 PSTDatabaseReplyExporting RequesttestYou can generate the "show" statements itself at run time and use it to extract the view definitions ...i.e. something like this.** Generate all the show statements..export file = showstmts.sql;SEL...
47702 Jan 2009 @ 04:15 PSTDatabaseReplyNon equi join conditionif your PI consists of only the first column, then you (might) still get the benefit of getting an AMP local join.
47602 Jan 2009 @ 04:09 PSTDatabaseReplyExporting RequesttestWhy don't you export the output of SHOW SELECT * FROM MYDB.MYVIEW;that way all the views/tables/JIs will be pulled out as well.
47530 Dec 2008 @ 11:02 PSTToolsReplyFind and replaceIf your data can have '.' only at the end, then you might want to use a simple TRIM function..ieTRIM(TRAILING '.' FROM col1)
47430 Dec 2008 @ 10:59 PSTToolsReplyControl characters in output filetry this ....export file = mydata;SELECT ......export reset;
47330 Dec 2008 @ 10:56 PSTUDAReplyUnicode to LatinI would say it kind of depends, and yes it's generally bad idea to keep to different character sets.For example, since the latin columns are going to be converted to unicode, this means the optimiz...
47230 Dec 2008 @ 02:24 PSTToolsReplyMload Hangs in acquisition phaseIs multiload reading data from file or fifo ? what does the logs say ?
47128 Dec 2008 @ 01:42 PSTDatabaseReplyPPI errorIt needs to check only in one partition, the partition that corresponds to col3='2008-12-11'That's because it's perfectly valid to have another (409, 33,col3) as long as that col3 is not '2008-12-1...
47024 Dec 2008 @ 12:37 PSTDatabaseReplyPPI errorThere was a long discussion on this already.http://www.teradata.com/teradataforum/Topic6553-9-1.aspx
46912 Nov 2008 @ 09:37 PSTAnalyticsReplyBad character in format or datacan you post the DDLs ? probably the data types are diff ?
46811 Nov 2008 @ 11:49 PSTAnalyticsReplyDynamic Cursor ForDepending on the details of what you are trying to accomplish, you might be able to do a insert/select into an interim table or so and then run your queries against it. (will work if the columns yo...
46711 Nov 2008 @ 11:16 PSTToolsReplyerror using importYou are having problem with date's format in the input data file. Try explicitly formating the input variable.
46609 Nov 2008 @ 05:22 PSTDatabaseReplytaraData substring functionyou shouldn't be having any trouble executing that SQL in 6.1Are you executing the entire contents in a single go ? it looks like there's something in your SQL assistant before the recursive statem...
46509 Nov 2008 @ 03:00 PSTDatabaseReplytaraData substring functionIt's the exact steps I executed.What version of TD are your running ?
46409 Nov 2008 @ 01:16 PSTDatabaseReplytaraData substring functionYou can try recursive queries , or a plain UDF which picks the last word in the text.the recursive solution is like this ...CREATE TABLE MYADD(ID INTEGER,ADDRESS VARCHAR(100))UNIQUE PRIMARY INDEX(I...
46309 Nov 2008 @ 01:02 PSTToolsReplyHandling timestamp column during fast exportIt doesn't help in giving a solution if we don't know what you are doing with that time stamp column in the fast export script.Does this same SQL run in queryman ?Are you doing some conversion / ad...
46209 Nov 2008 @ 12:56 PSTDatabaseReplyReset identity column counterA note of caution on doing soft RI on staging tables. This will mean that if you try to validate referential integrity on staging tables by executing an SQL or so, you might end up getting wrong r...
46109 Nov 2008 @ 12:43 PSTDatabaseReplyIDLE SESSION BLOCKING!!!!!!!!!!!!!!Could also happen if those "idle" session had explicit TD begin transaction (BT statements) and was not committed (ET).
46004 Nov 2008 @ 10:09 PSTUDAReplyADDING HOURS IN TERSDATA SQLyou can add the ( interval '18' hour ) to your timestamp
45903 Nov 2008 @ 09:23 PSTDatabaseReplyT7658 errorThe error for scenario (1) is valid, you need to pass a host variable to bind the o/p value (in the case of SQL assistant, it was automatically taking care of it).I am not sure why (2) errors while...
45803 Nov 2008 @ 08:43 PSTDatabaseReplyCollect statistics using variableyou can't refer to attribute or object names using a variable.try this instead.(echo ".logon $env/$user,$pwd;database $tdbase;"cat $scriptdir/tablelist | sed -e 's/^/COLLECT STATISTICS ON /'echo "....
45703 Nov 2008 @ 08:32 PSTAnalyticsReplyImproving query performanceAre these 4 columns part of an index ? (Covered queries are generally faster since they are read directly from the index subtable).The other questions is how wide these 80 columns are, it can be to...
45627 Oct 2008 @ 10:38 PDTDatabaseReplyAdding a interval to datetimestamp from another column(BEGIN_DATE (TIMESTAMP(0))) + ( ADD_HOURS(INTERVAL HOUR) )

Pages