#DateForumTypeThreadPost
3608 Jan 2011 @ 01:05 PSTGeneralReplyAcceptable Duplicate Row CountAgree with Dieter, however in some cases (I have seen them in Telco industry) dups are functionally required, the number of acceptable dups in such case depends to the number of hash collision you ...
3508 Jan 2011 @ 12:58 PSTGeneralReplyNo more spool error- sel * from table sqlKeep in mind that the total spool affected to a user is hold by AMPS, each one has 1/#AMP of the total spool, if there is a spike on your data distribution, one AMP may raise its local spool limit...
3406 Apr 2010 @ 04:53 PDTGeneralReplyFDL4822 DEFINE statement rejected.There is unauthorized enclosing parenthesis on your define clause. Datataypes must be enclosed but not the whole definition
3306 Apr 2010 @ 03:39 PDTGeneralReplyError in BETQyour logonstring is not valid a logon stinrg in batch mode consiste of : TPDID/username,password where TDPID appearse in your Hosts file as "TDPIDcop1" where cop1 means "first gateway address" O...
3218 Feb 2010 @ 02:31 PSTDatabaseReplyGlobal Tempoary Table ErrorIf you don't specify the DATABASE in which you are creating the global temp, it will be created in your username space. Then you need to have the propper rights and the TEMPORARY space allocated to...
3118 Feb 2010 @ 02:28 PSTDatabaseReplyOptimizer expert, please correct my under standing hereIs it possible to post the TSET of your query ?
3008 Feb 2010 @ 05:41 PSTDatabaseReplybteq script and password policyThere is a possibility to make CLI to call an external routine by using CliUsrLgnExt exit routine. This routine can modify the teradata connectstring. Look to the CLI documentation
2908 Feb 2010 @ 05:41 PSTDatabaseReplybteq script and password policyThere is a possibility to make CLI to call an external routine by using CliUsrLgnExt exit routine. This routine can modify the teradata connectstring. Look to the CLI documentation
2822 Jan 2010 @ 08:55 PSTDatabaseReplyTD 12 Timestamp Partitioning... what about MLPPI?As far as I know by doing an internal converision to DATE , its working: CREATE SET TABLE sysdba.FOO ( C1 DATE FORMAT 'yyyy-mm-dd', C2 DECIMAL(15,0), C3 TIMESTAMP(2), C4 CHAR(1) ) PRIMAR...
2721 Jan 2010 @ 01:06 PSTToolsReplyNotePad++, a GPL replacement to UltraEdit and TextPaddid you consider GVim ? It has a very good integration with win32 OLE, has a lot af helpers and extenders and extend the old vi capacity. By using perl DBI and a SQL extention, I even succeed to ...
2621 Jan 2010 @ 12:59 PSTDatabaseReplyInsert in CLOBBy using the import feature of SQL-Assistant, you are able to load clobs or blobs, SQLA has parameter markers for blobs and clobs: Insert Into Foo Values ( 'bar', ?B, ?C) The ?B is a placehol...
2521 Dec 2009 @ 08:48 PSTDatabaseReplyPerformance comparsion MERGE INTO vs classic UPSERTYes generally speaking. However, the third solution may be very time consuming if you have too much or big indexes on your base table.
2421 Dec 2009 @ 08:46 PSTDatabaseReplyTASM issuesIn which version of TD are you ? how many period have you defined ? If you have serveral regulation periods, you must specify degradation rules of workloads for each period. I observe the same be...
2318 Dec 2009 @ 01:27 PSTDatabaseReplySpecifying a sort order while creating a tableTeradata does not maintain rows in the recieved order. Each AMP maintain its rows by the rowhash ascending order. If you want to maintain any specific order for display, you must create an addition...
2218 Dec 2009 @ 10:06 PSTDatabaseReplyUse of BTQ Insert Using with a PACK factordid you tried to make it with 2 phases : use bteq import with pack option to load your data to a table with a NUPI, and then populate the target by an insert/select.
2118 Dec 2009 @ 10:02 PSTDatabaseReplyPerformance comparsion MERGE INTO vs classic UPSERTYes, Insert/Select to a Target table with join indexes is usually the fastest option,however the update operation may cause trouble in two cases: if the updated column is part of the join indexes...
2018 Dec 2009 @ 09:46 PSTToolsReplyFailure 2673 The source parcel length does not match data that was defined.try .SET REPEATSTOP ON
1918 Dec 2009 @ 09:39 PSTToolsReplyFASTEXPORT output file column name you must write 2 select clause in the .BEGIN EXPORT/.END EXPORT grou^p the first clause will be a simple select with the name of the columns as litteral string and the second select will be your ...
1818 Dec 2009 @ 09:31 PSTToolsReplyProblem in Creating Delimited Data file using FastExport.By th way there is another way to produce such files, did you consider TPT export operator in conjuction of a dataconnector consumer operator? TPT export will produce fields, and the dataconnector...
1718 Dec 2009 @ 09:28 PSTToolsReplyProblem in Creating Delimited Data file using FastExport.If you don't cast then entire concatenation expression, Teradata will consider it as a VARCHAR, then when Fastexport produce the export file, it add a 2 byte length field at the begining of each r...
1611 Dec 2009 @ 08:04 PSTToolsReplyTPT Stream Operator Bug?take care about deadlocks, the table maintenance is done by SQL, and locks are at the rowhash level, if you'r inserting and unpdating the same row through two different streams, you may be in troub...
1511 Dec 2009 @ 07:43 PSTUDAReplyRaise Error and Return value with in a stored procedureThere is a workaround for that, you must use an XSP named raisesqlstate for doing this:here are examples :REPLACE PROCEDURE p_test1()BEGIN DECLARE v_sqlstate CHAR(5); DECLARE v_errmsg VARCHAR(256) ...
1420 Sep 2009 @ 12:22 PDTDatabaseReplyERROR IN AMP2 weeks ago, Another member had this error, I've posted the usual way to recover AMP's ( if recoverable!!). The post title was: "2642: Amp Down. The Request against nonfallback CONTRACT cannot be...
1318 Sep 2009 @ 04:38 PDTDatabaseReplyTeradata substitute to TRUNCATE commandAre you using row-level trigger or a Teradata Triggered Statement ?
1214 Sep 2009 @ 01:55 PDTToolsReplyCan We use filler concept in FastLoadYes,Just declare the unwanted fields as DUMMYnnn with the correct datatype, and don't use it whithin the insert caommand,In this case, you must use INSERT Into )

Pages