#DateForumTypeThreadPost
89617 Feb 2016 @ 11:53 PSTDatabaseReplyDisable TD2 logon but allow LDAP for certain usersRequire some combination of upper/lower case letters, digits, special characters but restrict max length to 1 character.
89517 Feb 2016 @ 11:51 PSTDatabaseReplyDisable TD2 logon but allow LDAP for certain usersRequire some combination of upper/lower case letters, digits, special characters but restrict max length to 1.
89417 Feb 2016 @ 11:37 PSTToolsReplyUpload files .dat in Teradata SQL Assistant only imports delimited files. But the command-line utilities allow you to define fixed record layouts.
89317 Feb 2016 @ 11:35 PSTToolsReplyTPT - Delimited Data Parsing error: Invalid multi-byte characterThe C3 87 is UTF-8 encoding for U+00C7, so it would seem that your data is in fact UTF-8 encoded. Does your TPT script specify USING CHARACTER SET UTF8 for the job? How are you specifying the Tex...
89217 Feb 2016 @ 10:26 PSTTeradata ApplicationsReplyLinking/Joining Different Databases in TeradataYes, the Foreign Server grammar is built-in; but QueryGrid table operators are not. Contact your Teradata sales team for details.
89116 Feb 2016 @ 11:32 PSTTeradata ApplicationsReplyLinking/Joining Different Databases in TeradataThis would require TD15 plus QueryGrid Teradata-to-Teradata.
89016 Feb 2016 @ 08:57 PSTToolsReplyExporting Teradata results to Office ProductsI don't think this is a TD ODBC limitation. What sort of "export" are you doing, specifically, and what error do you get?
88916 Feb 2016 @ 08:35 PSTTeradata StudioReplyTeradata Studio Express: data editing from ViewsViews of a single table with 1:1 correspondence between view columns and table columns may be updatable. In other words, you can use views to limit update access to specific rows and colu...
88815 Feb 2016 @ 01:40 PSTViewpointReplyERROR: Unable to start viewpointIf the Viewpoint portal isn't starting, then of course Firefox won't connect.   Take a look at the end of /opt/teradata/viewpoint/portal/logs/viewpoint.log to see if more detailed er...
88714 Feb 2016 @ 01:42 PSTDatabaseReplyHow do I do the initial connection setup in Teradata and How to create a database?Teradata SQL Assistant is a database client application (part of the Teradata Tools & Utilities bundle for Windows). It does not require VMware. Similarly, Teradata Studio [Express] is a d...
88612 Feb 2016 @ 08:34 PSTGeneralReplyTeradata GroupsThere are no built-in Roles in Teradata, though there are some pre-defined adminstrative usernames.
88512 Feb 2016 @ 08:32 PSTDatabaseReplyOptimal Process to load data from SQLserver to TeradataWhere is the time being spent? If much of the time is writing / reading the file extract, then consider using Teradata Parallel Transporter, SSIS, or some third-party tool to "pipe" data ...
88410 Feb 2016 @ 05:49 PSTToolsReplyfast export and mload with unicode column type and valueDoes col2 really need to be defined as 31000 characters? That would require 93000 bytes of buffer space in UTF8 which clearly exceeds the ~64K limit. In UTF16, col2 itself would need...
88305 Feb 2016 @ 02:27 PSTConnectivityReplyMAC ODBC does not handle UnicodeHave you tried using the driver with your own ODBC application or a full-featured client? This is likely a limitation of the tdxodbc test program rather than the driver.
88205 Feb 2016 @ 02:09 PSTDatabaseReplyHow to recover from error 3916: Requested information not in dictionaryTo remove the "orphan" foreign key constraint: ALTER TABLE xxx DROP INCONSISTENT REFERENCES;
88105 Feb 2016 @ 07:30 PSTDatabaseReplyRDBMS error 3813: The positional assignment list has too many valuesThat error specificallly indicates you have too many commas within the INSERT statement. Check that you don't have any lines with both leading and trailing commas, or extra comma befo...
88003 Feb 2016 @ 03:06 PSTDatabaseReplyincorrect use of subquery errorMove the calculation of REJ_CNT from the DERV2 subquery to the outer query. Also note that a CASE expression must return the same data type for all conditions (e.g. the numeric value will be impli...
87903 Feb 2016 @ 02:47 PSTDatabaseReplyAccess Right AbbreviationsSee the Appendix in the Data Dictionary Manual. OA = Override Dump OR= Override Restore
87803 Feb 2016 @ 02:15 PSTToolsReplyNo menu bar in SQL Assistant 14.01From a command prompt: del "%APPDATA%\Teradata\SQL Assistant\Toolbars.config"   Next time you run SQL Assistant, it will re-create the file with default settings.
87703 Feb 2016 @ 11:46 PSTDatabaseReplyDisable TD2 logon but allow LDAP for certain usersIf they don't know the password, they can't use TD2 authentication. The issue is that someone could potentially authenticate via LDAP, then change their TD2 password, and they subsequently ...
87627 Jan 2016 @ 08:13 PSTToolsReplyMultiload + LDAPHas your Teradata system been configured to support LDAP authentication? Does LDAP work for other tools / applications?   If so, check DBC.Software_Event_LogV for more detaile...
87527 Jan 2016 @ 03:26 PSTViewpointReplyViewpoint is not configured in TDExpress15.10.0.7_Sles11_40GB_vpUse dbc as the TDPID.
87427 Jan 2016 @ 03:24 PSTGeneralReplyvirtual machine performanceHow much physical memory do you have on the host machine, and how much have you dedicated to the VM? How many virtual "CPUs"?   And which version of TD Express?
87327 Jan 2016 @ 03:23 PSTDatabaseReplyBTEQ export FastLoad Import issueTo clarify the restriction: DEFINE must describe the input fields (not necessarily the same as the target table columns). And if the file format is specified as VARTEXT (delimited text), t...
87227 Jan 2016 @ 08:13 PSTConnectivityReplyODBC Socket Error in some Informatica SessionsPlease start a new topic for a new question.   This error generally indicates you are running Informatica 64-bit but trying to use the 32-bit drivers. Double-check your environment paths.

Pages