#DateForumTypeThreadPost
74617 Oct 2015 @ 11:50 PDTToolsReplyFastLoad UTF8 charset issue - for special charactersIn several common fonts, that symbol is used for x'1A' error replacement character. This is an indication that an earlier translation failed (prior to the load to Teradata). Are you certain...
74517 Oct 2015 @ 11:47 PDTDatabaseReplyRegular Expression On Teradata 14.0Please start a new topic for a new question. What hex values do you see for those special characters? Teradata's default EBCDIC mapping is not the same as the frequently used Code Pa...
74415 Oct 2015 @ 02:48 PDTDatabaseReplyChanging passwords always failing with 3685NullPassword means the Teradata database does no password validation itself. The external authentication mechanism (e.g. LDAP) may still require a password. When authentication is supposed to be h...
74312 Oct 2015 @ 04:25 PDTDatabaseReplyAccess logging v/s dbql object tableAccess logging is intended for auditing purposes; the access log row must be written before the request can actually be executed. You can choose to log DDL and DCL as well as DML access, and access...
74212 Oct 2015 @ 03:54 PDTDatabaseReply[Teradata Database] [5464] Error in Join Index DDL, Outer table field is not in the SELECT list.You would have to include fl.JoinKey (join column from the outer table) in the SELECT list, along with a "NOT NULL" column from fn (the inner table).
74109 Oct 2015 @ 03:56 PDTDatabaseReplyHow to create a table in CTE in TeradataYou have a secondary problem, in that UNION demands a FROM clause. But that would not give the same error. What version of TD?   WITH CATERGORYLIST AS ( SELECT * FROM (SELECT '...
74008 Oct 2015 @ 02:41 PDTDatabaseReplyHow to create a table in CTE in TeradataYou can't execute a CTE by itself, it can only be prefixed to a SELECT statement.  
73907 Oct 2015 @ 09:11 PDTGeneralReplyWhat is wrong with this syntax?Sometimes embedded formatting codes, e. g. in Rich Text Format can cause issues. Paste the SQL as plain text (e.g. into NotePad) and then copy the plain text version and paste that ...
73807 Oct 2015 @ 08:57 PDTToolsReplyOMD API errorYou can ignore this warning, unless you have Unity EcoSystems Manager. The Operational MetaData API is the integration between ESM and Teradata Utilities.
73702 Oct 2015 @ 04:55 PDTToolsReplyPlease Help -Error: (UPDATE_OPERATOR: TPT10322: Error -1 while trying to initialize CLI)That's a very generic error. Did everything install correctly? Do you have environment variable THREADONOFF=1 set? (Required for CLIv2 on Unix/Linux for multithreaded applications such as...
73630 Sep 2015 @ 08:01 PDTGeneralReplyHow to calculate the space of a database that data will be copied using arcmainThe user running the COPY needs enough spool space to rebuild secondary indexes after base rows have been copied.
73529 Sep 2015 @ 06:35 PDTConnectivityReplyConnecting to TD15 from Visual BasicI don't know what you mean by "additional information that TD15 is looking for". Try it using the connection string keywords documented in the manual:  strConn = "PRO...
73429 Sep 2015 @ 06:14 PDTDatabaseReplyDBQL SQLTextInfo 3577: row size or sort key size overflowTeradata currently does not support surrogate code points (4-byte UTF16) defined in Unicode 3.1 or above. See the "Unicode Server Character Set" topic in the "International Characte...
73328 Sep 2015 @ 09:36 PDTDatabaseReplySELECT Failed. 3706: Syntax error: expected something between ')' and the 'as' keyworEverything above seems to be the FROM clause of the (missing) main SELECT, e.g.   select table1.area_code, table1.merchandise_department_desc, table1.sales_channel_identifier, table1.fiscal_...
73228 Sep 2015 @ 12:53 PDTDatabaseReplySyntax Not Working: "ALTER TABLE <TableName> DROP <ColumnName> CHECK;"Note that that ALTER added a table-level constraint. For a column-level constraint:     ALTER TAB...
73127 Sep 2015 @ 02:49 PDTDatabaseReplyIssue while converting float to time and inserting to tableThe potential DateTimeFormat issue applies only to ODBC, not CLIv2 (which BTEQ uses) or Teradata.Net or JDBC.
73023 Sep 2015 @ 11:58 PDTToolsReplyLogon Error (BTEQ)Does the script contain only the lines you want BTEQ to process, or is the first line of the script file a bteq command?  
72923 Sep 2015 @ 11:35 PDTToolsReplyImporting with BTEQPlease start a new topic for new questions. Does your SQL start with a USING clause to define the parameter names?
72823 Sep 2015 @ 11:32 PDTDatabaseReplyTimestamp conversion failingIf using ODBC, be sure DateTimeFormat option is IAA or AAA.
72723 Sep 2015 @ 11:21 PDTToolsReplyReading UTF-16 Data File - MultiLoad (Windows)When you specify -c UTF16, by default MLOAD assumes the input script is also UTF16. Try mload -c UTF16 -i UTF8 <XXX.mload > XXX.log
72623 Sep 2015 @ 10:56 PDTViewpointReplyData collectors fail with the following error -- Unable to retrieve Teradata database version or retrieved unknHave you granted permissions to the data collection user as in the Installation & Configuration guide? Or is your Viewpoint version perhaps back-level compared to the database version?
72523 Sep 2015 @ 08:07 PDTDatabaseReplyIssue while converting float to time and inserting to tableAre you using ODBC driver to submit the query? If so, is the middle letter of DateTimeFormat set to backward-compatible "I"? Generally you should set DateTimeFormat to either IA...
72419 Sep 2015 @ 10:09 PDTGeneralReplyWhich DBS Control Settings Should be changed for changing TIMEZONE?See comments in the Database thread for this same question.
72319 Sep 2015 @ 10:09 PDTDatabaseReplySettings (DBS Control ) Should be changed for changing TIMEZONE?Ideally you should be providing the source time zone information to the database as you load the data (and optionally storing the time zone offset). Then when you run a query you can specify (in th...
72219 Sep 2015 @ 09:29 PDTToolsReplyFastExport Remove Binary/Indicator Values in Outmod The OUTMOD coding for this is pretty trivial. Start with the example in the manual. For the "process response record" case, instead of setting input and output lengths both to zero (...

Pages