#DateForumTypeThreadPost
49608 Jul 2013 @ 10:02 PDTDatabaseReplySkew NessMost of the tools and published queries calculate a "relative" skew value rather than some sort of absolute measure. If most AMPs have only table headers but a few AMPs also have a data ...
49508 Jul 2013 @ 09:48 PDTDatabaseReplyWhen does Dropping Stats helpThis is a difficult question to answer, but here goes: a. 1 - The optimizer in effect is biased to assume that if you bothered to collect the stats, they must be relevant. a. 2 - If you have deno...
49408 Jul 2013 @ 09:21 PDTToolsReplyChange TPT handling of zero-length strings Check the TPT Reference for 14.00. It is clearly stated in the documentation for the Data Connector operator: NullColumns='N' is the optional attribute setting you are looking for.
49306 Jul 2013 @ 10:38 PDTDatabaseReplyAccess Right AbbreviationsSee the Data Dictionary manual for the appropriate release for a complete list.   SH = Show GC = Create GLOP GD = Drop GLOP GM = GLOP Member OP = Create Owner Procedure
49206 Jul 2013 @ 10:32 PDTDatabaseReplyDesign change / Perf Optimization Suggestion requiredFor TD13.10 or later, you could use a scalar subquery:   SEL count(1) FROM  (    SELECT RTL_ID RetailID,        CATG_ID CATGID,       &n...
49126 Jun 2013 @ 03:21 PDTDatabaseReplyCursors in stored proceduresYou will have to provide more detail if you want assistance. Simply using a cursor will not double the number of rows.
49026 Jun 2013 @ 03:14 PDTDatabaseReplyCPPI questionMaking this change via ALTER is not supported for character PPI. Create a new table and copy the data.
48926 Jun 2013 @ 03:13 PDTGeneralReplyIf a user X is created with Spool Space say 50 GB and later on this user is explicitly assigned with 10 GB of spool space indiviNot sure of the question. If the user is assigned a profile with non-NULL spool space limit, then the profile limit applies. If the user has no profile or if spool space in the profile is NULL, the...
48826 Jun 2013 @ 03:11 PDTToolsReplyUsing templates for operators provided in TPTNormally each data connector producer instance reads a separate file, e.g. when you are using FileList or DirectoryPath options.   There is a MultipleReaders='Y' option if you r...
48722 Jun 2013 @ 07:47 PDTToolsReplyTPT multiple instances using mainframe host (Syntax error).I am not aware of one that is publicly available.
48621 Jun 2013 @ 04:48 PDTDatabaseReplyGLobal Temporary Table (GTT)Each session can materialize its own local instance of a GTT. Those instances have different internal Table IDs in the file system, even though they are accessed using the same name in SQL.  
48521 Jun 2013 @ 04:37 PDTToolsReplyTPT multiple instances using mainframe host (Syntax error).Multiple instances are normally used to read from different files in parallel, e.g. with FileList='Y' or DirectoryPath.   MultipleReaders='Y' allows multiple instances t...
48420 Jun 2013 @ 02:49 PDTToolsReplyWhere can I download .NET Data Provider 12.00.01.00Note that 12.00.01 is the version and the trailing .00 or .01 is the patch level. As a rule, even if you are using an old version of the driver (for compatibility) you should use the "current&...
48320 Jun 2013 @ 02:32 PDTAnalyticsReplyError Code 3807 not working even if .Label You set MAXERROR to 2, and the default severity for 3807 is 8; since 8>2, BTEQ exits. Since 3807 <> 0, with this sequence of statements you would go to FINISH if you didn...
48215 Jun 2013 @ 03:02 PDTToolsReplyFast loadYour input data has leading and trailing delimiters. Either remove them or add dummy fields to the DEFINE. Be sure your last input record has a newline at the end.
48115 Jun 2013 @ 03:00 PDTToolsReplyfastload errors with define delimiters.Don't include the delimiter characters or newline in the DEFINE. UNFORMATTED is used for "fixed format" records with positional fields and binary data. FORMATTED (also known as Fast...
48015 Jun 2013 @ 02:52 PDTToolsReplyfastload errors with checkpoint and indicator.These options are part of BEGIN LOADING statement:   BEGIN LOADING TDUSER.M1 ERRORFILES TDUSER.ERR1, TDUSER.ERR2 CHECKPOINT 1000 INDICATORS;
47915 Jun 2013 @ 02:29 PDTUDAReplywhy should we use SET table ?Not exactly. Duplicate row check is being done in both cases, but in your example the entire rows (1,1) and (1,2) are not duplicate so neither is eliminated. Therefore the uniqueness violation on t...
47812 Jun 2013 @ 05:05 PDTCloud ComputingReplyErroring out while unzipping td-express-14.00.00.01-vm-4gb Are you using 7-Zip (http://www.7-zip.org/download.html) to unzip, as recommended in the user guide?
47704 Jun 2013 @ 03:21 PDTGeneralReplymore than one value was returned by subqueryIt seems that the same EMP_NBR may have multiple EMP_PI_JOIN_KEY values. Why not GROUP BY C.EMP_PI_JOIN_KEY in the scalar subquery?
47617 May 2013 @ 03:55 PDTDatabaseReplycalling a SP inside a SP.See the explanation and chart in the DDL manual under CREATE PROCEDURE regarding which user's and/or database's rights are checked with different SQL SECURITY options. For this case sp...
47515 May 2013 @ 10:40 PDTConnectivityReplyRunnig multiple queries through MS Excel uusing ODBC DSNIn VBA code you can issue multiple requests on the same connection, but the wizard expects only a single data-returning SQL statement. It is submitting all the entered SQL above as one multi-s...
47415 May 2013 @ 09:59 PDTGeneralReplyComparing row count of two tables called by cursorYou need to use "dynamic SQL that returns a result set", something like this:   DECLARE SqlStr VARCHAR(1000); DECLARE C1 CURSOR FOR S1; SET SqlStr = 'SELECT COUNT(*) FROM ...
47315 May 2013 @ 09:45 PDTDatabaseReplyCan someone guide me in calculating the sum in the caseLooks like you want DENSE_RANK, which is not implemented natively in Teradata. See Dieter's blog http://developer.teradata.com/blog/dnoeth/2011/05/missing-functions-dense-rank
47215 May 2013 @ 09:39 PDTDatabaseReplycalling a SP inside a SP.The "owner" (database or user in which TEMP is defined) does not have EXECUTE PROCEDURE right for TEMP1. Rights of the user are checked when invoking TEMP, but because TEMP does not spec...

Pages