#DateForumTypeThreadPost
69618 Jul 2015 @ 05:39 PDTToolsReplyET stmt with no BT in BTEQ; failed with error Data already committed is not rolled back. Only the "extra" ET itself fails.
69515 Jul 2015 @ 03:18 PDTToolsReplyfast export and mload with unicode column type and valueA translation error occurred when loading the data. Teradata will allow you to export the data, but you cannot re-load the error substitution character. "0043004100520047004F00200050004F00520...
69411 Jul 2015 @ 02:19 PDTDatabaseReplyQuery to get most expensive query running/historical without/with using DBQL..? You can potentially call the same PM/API functions that Viewpoint does. See the manual titled "Application Programming Reference". Be aware that having many users issuing these...
69311 Jul 2015 @ 02:09 PDTToolsReplyfast export and mload with unicode column type and valueCan you determine the problem character in hex? Teradata won't allow loading translation error characters U+001A or U+FFFD, for example.   Search for invalid characters in...
69211 Jul 2015 @ 01:56 PDTDatabaseReplyHow can i Access to database on distant machineTD15.0 + QueryGrid feature
69111 Jul 2015 @ 01:53 PDTDatabaseReplyWhy does my percentage have no values after the decimal?Why? Because by definition when you divide one integer value by another integer value, the result is truncated to an integer.
69007 Jul 2015 @ 09:28 PDTDatabaseReplyDatabase BackupThis is well outside the scope of the intended use of Studio. What does "restoring it in SQL Server environment" mean? Just table definitions / contents? What about permissions, character...
68907 Jul 2015 @ 09:25 PDTDatabaseReplywhere does Volatile table Stats informtion storeVT stats are "in memory". What are you really trying to do with this information? Maybe there is a different solution.
68807 Jul 2015 @ 09:24 PDTToolsReplyBTEQ Import/Export character set problemYour export and import need to use the same client character set. The database deals with lengths in terms of characters and the client-side definitions with bytes, and worst case a ...
68707 Jul 2015 @ 09:13 PDTConnectivityReplyCannot find terasso libraryPlease create a new thread for a new question. In the new thread, please state which client platform and what you have already tried or researched.
68607 Jul 2015 @ 09:11 PDTViewpointReplyDefinition of 'Active Time' seconds in Session Alert 1800 seconds represents elapsed time during which all periodic samples reported the session was "Active". Note that this is not quite the same as saying that the session is actually...
68507 Jul 2015 @ 09:09 PDTGeneralReplyStored procedure - how to set default value for variable with data type?You set a starting date but never increment it. What is the purpose of "i"? You never change that variable's value either. (And best practice is to use a date constant for that start...
68405 Jul 2015 @ 07:14 PDTDatabaseReplyJoin indexes with Curent_date or Current_timestampCURRENT_DATE is initially resolved at CREATE time. Afterwards, you periodically would use new ALTER ... TO CURRENT functionality shift the date range.
68304 Jul 2015 @ 04:05 PDTDatabaseReplyIssue while casting BYEINT column to Timestamp Default format for BYTEINT -ZZ9 does not include leading zeros and the implicit truncation trims spaces, so instead of e.g. '07' for 7AM you get '7 '   ...
68203 Jul 2015 @ 03:19 PDTToolsReplyTPT For Informatica 9.0.1Your LD_LIBRARY_PATH contains the 64-bit library: /opt/teradata/client/13.10/lib64 BTEQ is 32-bit; make sure the scripts calling BTEQ use /opt/teradata/client/13.10/lib instead.
68103 Jul 2015 @ 03:10 PDTDatabaseReplyHow to bring un-utilized space for utilization in terdata1) Creating a new table with different PI does have performance tradeoffs but is normally what you must do to fix extreme skew. (In special cases, columnar storage or NoPI tables might be of some u...
68002 Jul 2015 @ 03:09 PDTDatabaseReplyHow to bring un-utilized space for utilization in terdataRegarding Stats: In TD14.0 and later you can query DBC.StatsV. You can also use the combination of DBC.ColumnStatsV, DBC.IndexStatsV, and DBC.MultiColumnStatsV which exist back to TD12.0 SET table...
67902 Jul 2015 @ 02:52 PDTDatabaseReplyVT table data getting deleted after "Multiple rows updated" errorAn error causes rollback of the entire transaction in Teradata mode, not just the failing request.
67802 Jul 2015 @ 08:51 PDTDatabaseReplyHow to bring un-utilized space for utilization in terdataIt's not possible for MAX(CurrentPerm)*(HASHAMP()+1) to be 1.25, nor is it possible for SUM to be 1.25GB if MAX*#AMPs is only 1084 bytes. So the amount of unutilized space is still unclear...
67701 Jul 2015 @ 06:32 PDTDatabaseReplyHow to bring un-utilized space for utilization in terdata1. Assuming both are scaled the same (/1024/1024/1024) then yes, this would indicate very high skew and lots of space you may be unable to utilize. You could look at DBC.TableSizeV to identify offe...
67601 Jul 2015 @ 06:18 PDTDatabaseReplyInserting Unicode Characters into a Unicode FieldU+00F4 has been supported for a very long time. Double-check your input file. In UTF-8, this character should be represented as the two-byte sequence C3 B4.
67501 Jul 2015 @ 05:57 PDTToolsReplyBTEQ Import/Export of decimals does not workWhat is MAXDECIMAL set to? Maybe your exported data is being limited to DECIMAL(15,8) or DECIMAL(18,8).
67401 Jul 2015 @ 05:52 PDTDatabaseReplyTeradata Stored Procedure GOTOUse structured programming constructs to control the program flow instead BEGIN ... END IF ... THEN ... ELSE ... ENDIF LOOP / WHILE / REPEAT with ITERATE / LEAVE
67301 Jul 2015 @ 05:47 PDTViewpointReplyFor Testing/learningSome of the Teradata Express VMWare images include Viewpoint as part of the same Linux image. Note that you will need to devote more resources to the VM to run Viewpoint in addition to the Teradata...
67219 Jun 2015 @ 03:40 PDTToolsReplyTwo minor issues concerning TDSQLA 14.10.0.02 FunctionalityIf you set the General option to "Allow multiple queries per connection (Tabs in a Query window)", when the text in the current tab has been modified but not executed, then clicking in th...

Pages