#DateForumTypeThreadPost
59612 Dec 2014 @ 04:08 PSTConnectivityReplyCommand line installation for ODBC Driver for Windows 15.00.00.00Open an incident with Teradata Customer Services through the Teradata @ Your Service web portal.  
59511 Dec 2014 @ 08:27 PSTConnectivityReplyVerizon FIOS hangs with Excel via ODBCThis is likely due to "DNS hijacking" where the ISP's DNS server responds with a substitute IP address rather than a proper NXDOMAIN response when the name cannot be resolved. Po...
59410 Dec 2014 @ 08:34 PSTToolsReplyHow to skip BOM (Byte Order Mark )in BTeq scriptsEither -c UTF16 or -c UTF8, as appropriate.
59303 Dec 2014 @ 05:27 PSTConnectivityReplyConnecting to Teradata using PerlDBD::Teradata doesn't use ODBC. Have you installed CLIv2 driver?
59203 Dec 2014 @ 05:14 PSTToolsReplyHow to skip BOM (Byte Order Mark )in BTeq scriptsDid you tell BTEQ the input script was Unicode, e.g. with -c UTF16 option on the command line?
59103 Dec 2014 @ 05:13 PSTToolsReplyMload utility is loading unexpected data into table .LAYOUT describes the input data, not the table into which you are loading. Your input file is text, not binary. Looks like in your case EmpNo may be CHAR(4), DeptNo may be CHAR(2), and Salary may...
59019 Nov 2014 @ 01:38 PSTDatabaseReplyTime Zone String Instead of OffsetThe problem is that one time zone offset can be valid for multiple time zone names, so there is no universal way to do this. Even if you are dealing strictly with US time zones, not all locales obs...
58919 Nov 2014 @ 01:05 PSTCloud ComputingReplyViewpoint URL ? IP address in TD Express 15 / 14.10 ???It's standard http port 80 on the same IP as the database instance. Be sure the service is running. From the linux command line: /etc/init.d/viewpoint status See the Viewpoint Configuration G...
58814 Nov 2014 @ 04:21 PSTDatabaseReplySQLServer - Teradata Timestamp IssueSounds like a mismatch in the implicit / assumed time zone. In addition to OS time zone settings on the servers: Check dbscontrol settings SystemTimeZoneHour, SystemTimeZoneMinute, TimeDateWZContr...
58714 Nov 2014 @ 03:44 PSTDatabaseReplyAD-ENT based role access in Teradata 14Users which are authenticated via AD can also have roles mapped via AD. See the Security Administration manual. http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/Database_Management/B035_1100_111...
58606 Nov 2014 @ 09:40 PSTGeneralReplyAccessright for "GRANT LOGON ON ALL TO <username> WITH NULL PASSWORD;"Use DBC.LogonRulesV to see this information. Note that you can also GRANT LOGON "AS DEFAULT", which will apply to any user for which there is no user-specific rule, rather than having to...
58503 Nov 2014 @ 01:59 PSTToolsReplyTERADATA 13.10 - DATASTAGE 8.5 Issues with FastLoad functionalityYes, the DataStage 8.5 Teradata connector uses TPTAPI. A TPT job with LOAD STANDALONE operator can be used to release the lock.
58403 Nov 2014 @ 12:38 PSTGeneralReplyConverting varchar to timestampTIMESTAMP contains both DATE and TIME portions. Your example appears to be a TIME. Teradata will accept format HHMISS with no separator characters, but wants some separator between whole and fract...
58325 Sep 2014 @ 09:23 PDTDatabaseReplyMoving Data between different DBC'sYou could certainly SHOW the DDL on C and create an empty table on D, then use any number of tools or methods to export the data from one system and load it onto the other. The Teradata Parall...
58225 Sep 2014 @ 09:01 PDTGeneralReplyQUERY INVALID ERRORThere is no visible problem with what you posted. What tool are you using, and what exactly is the error?
58102 Sep 2014 @ 02:30 PDTDatabaseReplyString contains an untranslatable characterYou get the error because the function name is translate_chk not translate_check. But this will check the name of the column itself and not the table contents - so won't do what you want. You ...
58002 Sep 2014 @ 02:18 PDTDatabaseReplydoes Teradata support UTF-16 surrogate pair?Teradata does not currently support surrogate code points.
57917 Jul 2014 @ 04:27 PDTDatabaseReplyUDFs and Granting of Access RightsYes, if the function is overloaded then you need to either grant access via the SPECIFIC FUNCTION name or indicate the relevant parameter datatypes after the generic FUNCTION name so the datab...
57815 Jul 2014 @ 03:13 PDTToolsReplyTrying to import data into my tableI see two things. .IMPORT is specifying DATA (i.e. FastLoad format without indicators). I doubt that's actually the format of your input file. More likely you need something like VARTEXT '...
57726 Jun 2014 @ 07:58 PDTGeneralReplyGetting the warnjng- *** Warning: Out of data-while importing csv file using bteqThere is no issue to resolve. The message is simply notifying you that BTEQ import reached the end of file, as expected.
57626 Jun 2014 @ 07:41 PDTAnalyticsReplyRegarding Space Management In TeradataPlease start a new topic for new questions. Rows with Tablename "All" are track database space. Consider using views DBC.TableSizeV and DBC.DiskSpaceV.
57524 Jun 2014 @ 04:07 PDTDatabaseReplyAdding Values across multiple columnsYou can't have two columns named Operator in the same SQL table. But it looks like what you mean by "sum across" would be the following: SELECT Team, Operator, SUM(The_Count) as...
57424 Jun 2014 @ 03:43 PDTGeneralReplyMy file is a delimited file, can i specify INT or CHAR in multiload layoutThe .LAYOUT describes the input record. If you .IMPORT VARTEXT (delimited) then all .FIELD should be VARCHAR. The corresponding columns in the target table could be INTEGER.
57324 Jun 2014 @ 03:31 PDTGeneralReplyAccepting variables from .profile in bteq and fexpThe TD utilities don't provide this functionality. Typical solution is make the bteq/fexp script a "here document" and let the shell do the substitution.
57219 Jun 2014 @ 02:37 PDTDatabaseReplyUpdate SyntaxAs you note, there is no functional difference; it's just different syntax. The first one is preferred, the second is older style, though both are Teradata extensions to ANSI standar...

Pages