#DateForumTypeThreadPost
10308 Oct 2006 @ 11:27 PDTToolsReplyMultiload issues.IMPORT .... FORMAT VARTEXT ';' ...;.FIELD xxx * VARCHAR(xx) NULLIF xxx = '\N';Easy to find if you'd checked the MLOAD manual...Dieter
10206 Oct 2006 @ 03:55 PDTUDAReplycreate index order by value questionFrom the Data Dictionary manualIndexType I (ordering column of a composite secondary index)A value ordered composite secondary index uses *two* consecutive index numbers, e.g. if the NUSI is #x the...
10106 Oct 2006 @ 02:10 PDTDatabaseReplyPREPARE Sql in Stored ProcedureHi Pete,> I was going to use a volatile table,> but my understanding was that if multiple users hit the SP,> only one instance of the volatile table can exist with the same name> in the db. So one ...
10003 Oct 2006 @ 09:24 PDTToolsReplyEquivalent Teradata function for FIX() visual basic functionHi Uma,FIX returns the integer part of a numeric value?CAST(val AS INT) as long as it fits into an integerDieter
9903 Oct 2006 @ 04:37 PDTDatabaseReplyPREPARE Sql in Stored Procedure> I'm trying to port an existing app that generates dynamic sql on the> server and currently calls a SP in MySql that loads the results> of the query that's passed into a temp table in memory. In T...
9803 Oct 2006 @ 04:21 PDTToolsReplyMultiLoad Acquisition Phase HangsWhat do you mean by "hang"? Any error messages?Any locks on the table which prevent the upgrade of the MLoad lock for Application phase?Could you show us the output of the script?Btw, MLoad uses CL...
9703 Oct 2006 @ 04:17 PDTDatabaseReplySQL Error on 'Create Table'You're probably running the create on an older version of Teradata, CHECKSUM was implemented in V2R5.1 (?)Just remove it and try it again...Dieter
9603 Oct 2006 @ 04:11 PDTDatabaseReplyInstr equivalent in Teradata....It's one of the Oracle UDF's, have a second look :-)Dieter
9503 Oct 2006 @ 04:06 PDTAnalyticsReplyTeradata SQL assistant: limiting the number of rows returned in "Export results"Hi Mat,no, AFAIK you can't do that with Queryman, only with BTEQ :-(But maybe you should post that question at www.teradataforum.com, because Mike Dempsey (who progammed Queryman) is monitoring it ...
9402 Oct 2006 @ 02:19 PDTAnalyticsReplyTeradata SQL assistant: limiting the number of rows returned in "Export results"Hi Mat,it would be easy with BTEQ, e.g..set width 65000.set retlimit 50.set retcancel on.export report file = xxx;your queries here.export resetDieter
9302 Oct 2006 @ 02:55 PDTToolsReplyERROR : 3789 - Multiple 'FORMAT' options with TIME data typeHi Anand,do a "SHOW TABLE Temp" and check if col1 is really a TIME. If you created it using ODBC and the ODBC Option "DateTime Format" is set to "I" for the time portion and/or "Allowing Use of ODB...
9201 Oct 2006 @ 07:50 PDTDatabaseReplyPREPARE Sql in Stored Procedure"According to the docs" you can do that only in Embedded SQL.What are you trying to achieve by passing a string to a cursor?Kind of dynamic SQL? A "one size fits all" SP?How are you going to access...
9129 Sep 2006 @ 02:52 PDTDatabaseReplyorder of column in primary indexNo.It's a hash index, so you always need all PI-columns to calculate the hash value. That calculation is the same regardless of column order:select hashrow(1,'a'),hashrow('a',1);HASHROW(1,'a') HAS...
9025 Sep 2006 @ 05:57 PDTDatabaseReplyPermanent Journals"I thank you for posting these questions. This made me refer few manuals and gather more information on permanent journals."Hey, i like that. Sounds so much nicer than "RTFM" ;-)Dieter
8921 Sep 2006 @ 03:03 PDTUDAReplyLoad data via SQL Server DTSHi Black Bird,DTS probably sends one record after the other, that's slowing down...If you're on V2R6+ there's an array feature available, but i don't know if DTS/OLE DB supports that. If not you st...
8821 Sep 2006 @ 02:54 PDTDatabaseReplyHow to drop a join index?Hi Mr. Big :-)the drop is probably blocked, try to drop with NOWAIT:lock my_join_index exclusive nowaitdrop join index my_join_index;There might also be a left backup lock on the base table, which ...
8721 Sep 2006 @ 02:48 PDTDatabaseReplyIs it normal ?- There are two session modes within Teradata RDBMS: ANSI session and Teradata session- There are lots of minor differences between those session modes (e.g. autocommit/case sensitivity,...)- But r...
8615 Sep 2006 @ 10:19 PDTDatabaseReplyRepresenting dates earlier to 1900???Hi SarathyG,of course it's possible, the valid date range is from 0001-01-01 to 9999-12-31010101 -> 01-Jan-1901 0101 -> 01-Jan-1900 -9899 -> 01-Jan-1899 :-)Teradata stores dates using following fo...
8505 Sep 2006 @ 02:34 PDTToolsReplyFastload-ing the FastExported Data.???You export indicator bits, but forgot INDICATORS within the FastLoad:BEGIN LOADING sarathy_db.empERRORFILES sarathy_db.fld_err_tb1,sarathy_db.fld_err_tb2INDICATORSCHECKPOINT 50;Dieter
8431 Aug 2006 @ 12:39 PDTDatabaseReplyFastload Varchar to TimestampHi tty,a cast using a format string will only work, if it's always 2 digits for day/month/hour likeselect '05/16/2005 09:44:44 PM' (timestamp, format 'mm/dd/yyyyBhh:mi:ssBT')If you can't reformat t...
8331 Aug 2006 @ 12:31 PDTUDAReplyPivoting rows to ColumnsHi Sam,http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=10&messageid=1285Dieter
8231 Aug 2006 @ 12:28 PDTDatabaseReplyHow to remove characters?Hi myk,trim(both '"' from col)
8131 Aug 2006 @ 10:48 PDTUDAReplySupressing Titles on .EXPORT commandAnother way without specifying (title '') for each column:.export DATA file=.....set recordmode offExports in REPORT mode without any header...But don't ask my WHY it's working this way :-)Dieter
8030 Aug 2006 @ 11:08 PDTDatabaseReply[SQL] values in the FROMHi robirob44,it's DB2/ANSI SQL syntax, but not implemented in Teradata. Would be nice to have...You have to rewrite it with UNIONs, but a SELECT in a UNION needs a FROM:select a.COSGPA, a.LIBGPAfro...
7930 Aug 2006 @ 11:01 PDTDatabaseReplyInstr equivalent in Teradata....Hi Alem,instr('abc', 'a') -> position('a' in 'abc')instr('abc', 'a', start) -> position('a' in substring('abc' from start))instr('abc', 'a', start, occurence) -> ugly SQL using nested substring/pos...

Pages