#DateForumTypeThreadPost
92102 Mar 2016 @ 09:48 PSTToolsReplyTransfering data from one server to anotherYou need something in the middle unless you implement QueryGrid, but you don't have to convert to/from CSV or write the file to disk. See the TPT Users Guide for some examples combining the EX...
92002 Mar 2016 @ 09:23 PSTDatabaseReplyoreplace of ->The character arguments to the functions must all be LATIN to avoid the implicit translation of all character values to Unicode (which will fail with 6706); note that liter...
91902 Mar 2016 @ 09:14 PSTToolsReplyMload failing when trying to load file with þ (thorn) as delimiterI must admit I don't understand the "invalid character" message either. It is true that 'DE'xc is not a valid UTF8 character, but I would have expected that message only if th...
91801 Mar 2016 @ 08:56 PSTDatabaseReplyoreplace of ->Use CHAR2HEXINT function to determine the actual character value.
91728 Feb 2016 @ 02:58 PSTToolsReplyMload failing when trying to load file with þ (thorn) as delimiterYou're halfway there. The '00FE'xc is the UTF16BE representation of lower-case thorn, but by default the script encoding is assumed to be ASCII / TD LATIN. So either Speci...
91628 Feb 2016 @ 09:02 PSTToolsReplyMload failing when trying to load file with þ (thorn) as delimiterIt appears your input is UTF8, so you need to tell MultiLoad that, e.g. via "-c UTF8" option on the mload command line.
91528 Feb 2016 @ 08:53 PSTDatabaseReplyPerformance DataDBQL (urequest level) and ResUsage (system level) views provide such capabilities after the fact, and the Open API table functions are used to obtain snapshots in real time, all via SQL. Ther...
91427 Feb 2016 @ 05:07 PSTDatabaseReplyadding hours in timestamp returns wrong results in Teradata 15 but works fine in Terdata 14Your session time zone offset is different (look at HELP SESSION), likely due to differences in how dbscontrol and/or tdlocaledef were configured.
91327 Feb 2016 @ 05:04 PSTTeradata ApplicationsReplyHow to see Information In Data Dictionary in teradata after stats collectionsWhat database version? Always use the "V" suffix version of DBC views (since TD12). When you say it's "not working", do you mean that the query runs but returns no row...
91227 Feb 2016 @ 05:01 PSTDatabaseReplyAdd minutes(another column) to time columnSELECT TIME_COLUMN + TIM_MIN * INTERVAL '1' MINUTE
91126 Feb 2016 @ 03:34 PSTDatabaseReplyTactical QueriesIf you are looking at ResUsageSpma, did you check ProcBlks*/ProcWait* columns? Flow control is possible even if you have CPU available. Did you check ResUsageSawt? Do you throttle the concurrency ...
91026 Feb 2016 @ 02:41 PSTTeradata ApplicationsReplyImport Tab delimited file through Teradata fast load utility is not working.Your target table has a Unique Primary Index and your input has multiple records with the same PI value. For each PI value, one row is loaded and the others go to Error Table 2.
90926 Feb 2016 @ 02:16 PSTDatabaseReplyPerformance DataSimilar information is available. See the "Introduction to Teradata" manual for an overview and some links, and ask here if there is something specific you are looking for and can't f...
90822 Feb 2016 @ 03:07 PSTToolsReplyDate value nullAdd another WHEN clause: CASE WHEN a = b THEN 'Pass' WHEN a IS NULL AND b IS NULL then 'Pass' ELSE 'Fail' END   Or use a compound condition: CASE WHEN (a=...
90721 Feb 2016 @ 03:46 PSTToolsReplyTPT Stream OperatorThe Stream operator just sends data to TD; in a TPT job the Data Connector Producer operator reads from files. Stream does not read from tables. See the manuals for examples.   I would ...
90621 Feb 2016 @ 03:27 PSTDatabaseReplyHot Standby NodeIf a node fails, it will trigger a database restart. This will normally result in the AMPs from the failed node either migrating to the HSN or being distributed among the remaining n...
90521 Feb 2016 @ 03:22 PSTDatabaseReplyRemoving single occurance of rows from the set of duplicate rowsselect PKG_ID, P_ID, P_CD from MY_PKG where (PKG_ID, P_CD) in (SELECT PKG_ID, P_CD FROM MY_PKG WHERE COUNT(DISTINCT P_ID) > 1 GROUP BY 1, 2) ORDER BY 3, 1;
90421 Feb 2016 @ 03:10 PSTTeradata ApplicationsReplySame ROW-Hash Value for all the recordThe Teradata hash function is deterministic - same input values always give the same result. It's possible (but unusual) for different input values to give the same result, referred t...
90319 Feb 2016 @ 12:22 PSTToolsReplyTPT Instances - How this works?You can specify multiple instances for a LOAD_OPERATOR. Sessions will be divided among the instances as evenly as possible.
90219 Feb 2016 @ 12:14 PSTDatabaseReplysubtract time zone from timestampThe obvious response would be: So, do that! Note that subtracting -5 means adding 5, though, so 02/24/2015 16:30:00 US Eastern is 02/24/2015 21:30:00 UTC.   But what is the real requir...
90118 Feb 2016 @ 03:10 PSTDatabaseReplysubtract time zone from timestampSimply TS_column AT '00:00' will shift the time zone. But if you insist on using EXTRACT, you can compute the time zone offset as an interval this way: EXTRACT(TIMEZONE_HOUR FROM TS_colum...
90018 Feb 2016 @ 11:06 PSTConnectivityReplyExcel 2013 (32 bit) - Teradata ODBC Connectivity issueMultiple issues are listed above. What versions of ODBC, Excel, etc. are you having an issue with, and specifically what error indication do you receive?
89918 Feb 2016 @ 07:58 PSTDatabaseReplyHow to recover from error 3916: Requested information not in dictionarySeems you will need to open an incident with Teradata support. They can do some analysis, and then will require an outage to allow them to repair the dictionary tables.
89818 Feb 2016 @ 07:36 PSTGeneralReplyTeradata Roles Based Privileges And User Based Privileges Yes. Any privileges provided via role(s) are in addition to any privileges granted specifically to the user.
89718 Feb 2016 @ 07:29 PSTToolsReplyUpload files .dat in Teradata Teradata Parallel Transporter, BTEQ, FastLoad, MultiLoad are part of the TTU base bundle that also includes SQL Assistant.

Pages