#DateForumTypeThreadPost
72116 Sep 2015 @ 03:11 PDTDatabaseReplyDrop or Delete Which one is better for this scenario?You can still get fast path delete with the SI. USI will impact your loading, though.
72010 Sep 2015 @ 02:30 PDTDatabaseReplyInserting Unicode Characters into a Unicode FieldU+0245 is not supported in TD13.0, it was added in TD14.0. There is a UNCDUNCD.txt file that documents the supported Unicode characters. It's on the documentation CD (index entry is "Unic...
71927 Aug 2015 @ 02:26 PDTDatabaseReplyInvalid session mode for procedure executionIf you are using .NET Provider (recommended) then in the connection dialog just click the "Advanced" tab and select ANSI from the Session Mode drop-down.  If you are using ODBC,...
71826 Aug 2015 @ 12:33 PDTDatabaseReplyReconciling AMPUsage and ResUsageAre you using Account String Expansion (ASE) for all work, to provide adequate resolution for meaningful AMPUsage data comparisons?  
71726 Aug 2015 @ 08:07 PDTDatabaseReplytrademark sign ™ not properly inserted.Data is being inserted / stored correctly and is displayed correctly when you use a client character set translation that includes the necessary symbol. If you say the client character set is...
71626 Aug 2015 @ 07:58 PDTDatabaseReplyTIMESTAMP values gets updated with UTC values via Stored procedure.DML requests (including macro execution) submitted directly will default to the current session time zone. But within a SQL Stored Procedure, DML defaults to the time zone of the se...
71525 Aug 2015 @ 02:10 PDTDatabaseReplyDB2 Packed DecimalAll Teradata numeric data types including DECIMAL support signed values.
71424 Aug 2015 @ 09:35 PDTToolsReplyfastload error "not enough fields in vartext data record number".Is there a new line at the end of the second record? There needs to be...
71319 Aug 2015 @ 11:37 PDTToolsReplyTPUMP ERRORMissing the leading "." for ".end load;" command
71219 Aug 2015 @ 09:07 PDTDatabaseReplyPRIMARY INDEX ON VOLATILE Tables cause SPOOL SPACE ERRORSVery likely your system is configured to default not to first column alone as  PI, as in earlier releases, but rather to NO PRIMARY INDEX. Do a SHOW TABLE after creating your volatile table to...
71118 Aug 2015 @ 12:19 PDTTeradata ApplicationsReplyerrorThe DEFINE describes the input data, not the target table. All the input fields should be defined as VARCHAR when RECORD type is VARTEXT. For FastLoad, SET RECORD should not begin with a period. ...
71015 Aug 2015 @ 10:13 PDTDatabaseReplyAny effects of timezone on data If there is a need to see data not only relative to the client's time zone but also "AT SOURCE", then consider storing the input time zone information as well, e.g. TIMESTAMP WIT...
70915 Aug 2015 @ 10:11 PDTDatabaseReplyAny effects of timezone on data Teradata has no way to actually know the client's time zone, so one of the attributes of every session is a time zone offset. It can be modified within the session (using SET SESSION TIME ZONE)...
70815 Aug 2015 @ 09:35 PDTDatabaseReplyFacing issues while creating User Defined FunctionSyntax is CLOB AS LOCATOR
70714 Aug 2015 @ 04:46 PDTDatabaseReplyHow can I check if user is locked using query?No. Treat lockedCount as number of consecutive unsuccessful attempts. To determine if user is currently locked you start by checking Locked Date & Locked Time. If those have values, then ...
70614 Aug 2015 @ 04:25 PDTGeneralReplyAMP Count vs SkewFactorYes - the AVG per AMP decreases as you add more AMPs, but the skew stays on single/few AMPs. So ratio betwee MAX and AVG likely gets worse, i.e. the skew is more noticeable / more impactful.
70510 Aug 2015 @ 02:04 PDTDatabaseReplySelect failed 3810 Column / Parameter .....does not existYou already renamed paymt_mdia_proc_sys_cde as Settlement in the inner query (pft). So you need to use that name in the outer query.
70408 Aug 2015 @ 11:20 PDTGeneralReplyenable encryption in odbc.ini fileThe one being used to make the connection... More specifically, search order is Fully qualified filename value from ODBCINI environment variable (need not even be called odbc.ini) ...
70302 Aug 2015 @ 03:32 PDTToolsReplyBTEQ Merge failed- DDL changes on tableIf you do a positional INSERT tableName VALUES (...) into a table with N columns, the list must have exactly N entries (and N-1 commas). You can omit a value (leading, trailing, or two co...
70201 Aug 2015 @ 02:09 PDTDatabaseReplyViews and LocksIf your session is using ANSI mode, your understanding is correct. The READ lock for "Type 1" scenario will be held until you stop retrieving rows and COMMIT, so will block ETL ...
70130 Jul 2015 @ 03:24 PDTDatabaseReplyHow to convert column character set in Teradata table.No. You cannot ALTER an existing column in a manner that requires rewriting the data rows. For non-indexed columns, you can use ALTER to rename existing columns and/or add new columns (e.g. ALTER ...
70028 Jul 2015 @ 09:07 PDTTeradata ApplicationsReplyExplain PlanThat is true through TD14.0. In TD14.10 and later, there is IPE (Incremental Planning and Execution) feature which may result in the actual plan being different from the default (STATIC) EXPLAIN. ...
69927 Jul 2015 @ 08:04 PDTDatabaseReplyDB2 to Teradata MigrationTIMESTAMP(6) is directly equivalent to TIMESTAMP(6) WITHOUT TIME ZONE CHAR(x) FOR SBCS DATA might be CHAR(x) CASESPECIFIC CHARACTER SET LATIN and you may also need to set COLLATION for your sessio...
69822 Jul 2015 @ 02:28 PDTDatabaseReplyTERADATA SQL QUeryTeradata's implementation of CTE evaluates in reverse order. Switch so CTE1 is first, and CTE on which it depends comes second.
69719 Jul 2015 @ 03:38 PDTToolsReplyET stmt with no BT in BTEQ; failed with error In that case, the failing SQL and any other statements in the transaction (back to and including the BT) would be rolled back, precisely because they have NOT been committed.  And th...

Pages