#DateForumTypeThreadPost
104627 Jul 2016 @ 08:57 PDTToolsReplynot Sign Delimiter issue in FastloadAdd -c UTF-8 option on the fastload command.
104526 Jul 2016 @ 04:09 PDTDatabaseReplyTPT ODBCSee http://knowledgebase.progress.com/articles/Article/3556 for information regarding this error.    
104426 Jul 2016 @ 11:41 PDTDatabaseReplyhow to handle Null values in FASTloadFastLoad NULLIF supports a maximum of 80 characters.
104326 Jul 2016 @ 11:17 PDTDatabaseReplyDifferent Column Orders for Stats Recommended by DIAGNOSTIC HELPSTATS? Starting with TD14.0, the order given for COLUMN stats is respected. If columns that are being used in single-table filter predicates are listed first, followed by columns that are used for join cr...
104225 Jul 2016 @ 10:27 PDTToolsReplyUpload files .dat in Teradata They are separate batch-oriented client utilities, unrelated to SQL Assistant.
104122 Jul 2016 @ 12:59 PDTToolsReplyFloat data type export using Fast ExportFLOAT values are NOT "rounded off to 15 digits", nor is this specifically a Teradata issue. While some numbers (such as whole numbers with fewer digits) can be represented exactly, float...
104022 Jul 2016 @ 12:08 PDTDatabaseReplyReal/DoublePrecision/FLoat type in TeradataYou can use the keyword REAL or DOUBLE PRECISION in the CREATE TABLE; the resulting column data type will be FLOAT.
103922 Jul 2016 @ 12:07 PDTDatabaseReplyDefaulting during Teradata table loading through fast load FastLoad supports changing default values from the source to NULL, but not the other way around.   MultiLoad / TPT UPDATE would allow you to specify a COALESCE or CASE expression as part of ...
103822 Jul 2016 @ 09:34 PDTViewpointReplyLimit a role to only one Teradata system of several activeThe "Enable Systems" checkbox controls the list of systems for which you will be able to configure individual portlet permissions for the role. The Admin portlets currently do not h...
103721 Jul 2016 @ 12:57 PDTToolsReplyDetermine #sessions to set for load / exp jobsSteve's comment related to LOAD sessions. For EXPORT, the defaults (4, 4, 2) are generally fine. I would not change them.   Not sure what you mean by "not auto calculating". Th...
103621 Jul 2016 @ 11:29 PDTToolsReplyHow read consistency is maintained during Teradata Fast ExportAs with a normal SQL SELECT, by default a READ lock would be applied at the beginning of the process. A locking modifier can be used, e.g. to downgrade to ACCESS lock (which does not maintain ...
103521 Jul 2016 @ 11:00 PDTDatabaseReplyReal/DoublePrecision/FLoat type in TeradataREAL and DOUBLE PRECISION are ANSI standard syntax, interpreted as identical to Teradata FLOAT.
103418 Jul 2016 @ 04:03 PDTToolsReplyZero records are fetching when using where statement in TPTIf you are using the $EXPORT template and providing the SELECT at the job level, use the ExportSelectStmt variable.
103318 Jul 2016 @ 03:27 PDTDatabaseReplyConvert the data in the Table into XML formatDon't use a quoted identifier for the XML Element Name.
103218 Jul 2016 @ 03:20 PDTDatabaseReplyFunction quantile throws a numeric overflow error in a large tableQUANTILE is deprecated; Teradata recommends you use  standard SQL instead: (RANK() OVER (ORDER BY ACCT_ID) -1)*10/COUNT(*) OVER() as decile But that doesn't solve your issue. Like QUANTI...
103115 Jul 2016 @ 03:43 PDTThird Party SoftwareReply'enabled' columnSpecify the column name as a quoted identifier, i.e. "enabled"
103015 Jul 2016 @ 03:38 PDTDatabaseReplyMedian function - Fails on view when trying to cast as decimalNot sure what you are asking. You say myCol1 / myCol2 are INT but a CAST from INT to DECIMAL would not require string translation.   If you are trying to exclude some rows from the MEDIAN ca...
102914 Jul 2016 @ 10:10 PDTToolsReplyTeradata Tool and Utilities package for LinuxThe drivers and Teradata Studio downloads for Linux are on that site. But the full TPT suite for Linux would need to be obtained via Teradata @ Your Service or from your Teradata representativ...
102814 Jul 2016 @ 09:36 PDTToolsReplyTeradata tptWhat is data type / format for ROW_EFF_DT (for implicit data type conversion)? If it is a DATE column, better to explicitly use DATE constant - keyword DATE in front of opening (double) single quot...
102713 Jul 2016 @ 01:46 PDTConnectivityReplyOLEDB Driver of TD15.10TDOLEDB has been discontinued. The final release was 15.0.
102611 Jul 2016 @ 03:56 PDTDatabaseReplyFaster way to delete and rebuild a tableSo both step 2 and step 5 insert ALL the data (no WHERE clause)? And table A is dropped before applying the new data to B? (which would mean it's not really a "safety copy") Why...
102511 Jul 2016 @ 09:19 PDTDatabaseReplyTD 14 - Data Storage Questions1) See answer # 3 2) That's the preferred option - if the data is supposed to be a character string, use a string constant (even if the characters happen to be digits). 3) If you SELECT 12345...
102408 Jul 2016 @ 09:45 PDTToolsReplyteradata TPT , all rows in error tableYou apparently have non-LATIN data in your UNICODE columns, but are defaulting to ASCII session character set. Specify USING CHARACTER SET UTF16 at the start of your script. Note that in SCHEMA de...
102306 Jul 2016 @ 03:59 PDTDatabaseReplyHashing AlgorithmCould be either AMP or PE. In particular, FastLoad sends data blocks to AMPs round-robin and the AMPs hash the rows and send to the correct target AMP. But for a single-row fetch or insert, the PE ...
102205 Jul 2016 @ 10:00 PDTDatabaseReplyNeed help on writing teradata stored procedurePut the entire SQL statement in a variable, and dynamically execute it: SET MYQUERY='CREATE TABLE ...'||CASE WHEN LOAD_TYPE='HISTORY' THEN ' WHERE...' ELSE '' END||...

Pages