#DateForumTypeThreadPost
62111 Mar 2015 @ 10:02 PDTDatabaseReplySQL Function regarding CHAR vs VARCHARLiterals are typed as VARCHAR; to pass a literal value to this function you must explicitly CAST('B' AS CHAR(1)). As documented in SQL DDL: Detailed Topics manual, Function Name Overloadin...
62010 Mar 2015 @ 12:40 PDTDatabaseReplyCASE statment inside where clause and corelated subquery ERROR:3707WHERE expects a logical expression, but CASE returns either numeric or character. Use AND/OR to combine the predicates instead. Also put parentheses around your scalar subqueries.   SELECT ...
61904 Mar 2015 @ 12:47 PSTConnectivityReplycentos 6.4 + tdodbc 15 getting error: 110 Unable to get catalog string.It looks like you are getting a LoginTimeout at 2 seconds (though the default should be 20). Try specifying a much larger value, e.g. LoginTimeout=120 See if it succeeds or if it just takes longer...
61804 Mar 2015 @ 08:36 PSTToolsReplyTPT LoadingTPT can't do this type of conversion, but the database will implicitly convert if you define the FORMAT of the target column as 'DDMMMYYYY'.
61704 Mar 2015 @ 07:56 PSTConnectivityReplycentos 6.4 + tdodbc 15 getting error: 110 Unable to get catalog string.What does the DBCName parameter for your DSN entry look like? If it's a single name "X" can you ping XCOP1 (with the added suffix)? Can you ping X (with no suffix)?
61603 Mar 2015 @ 03:40 PSTGeneralReplyChild user can't select view of parent in teradataUSER2 does not need rights on the referenced tables to use views in USER1.   USER2 must have SELECT access on USER1 (or on the views individually); this could be granted via a role AND USE...
61502 Mar 2015 @ 04:05 PSTDatabaseReply'at time zone' not working in UPDATE/INSERTstatementAT time zone offset '+3:00' only appears to work in the SELECT because your session time zone offset is +00:00 and you are ignoring the time zone of the result. Internally, timestamps...
61402 Mar 2015 @ 03:08 PSTDatabaseReplyCollecting Statistics on Global Temporary TablesThe second form (with TEMPORARY keyword) collects statistics on your session's materialized instance of the GTT. For a GTT, the first form only defines (dummy) statistics on the base...
61327 Feb 2015 @ 12:00 PSTToolsReplyBTEQ field separator.If you are exporting in REPORT format, be sure you have set the maximum WIDTH large enough to contain the data.
61227 Feb 2015 @ 11:58 PSTGeneralReplyJSXP FileOutputStream working in VM not working in ProductionA Stored Procedure invocation can potentially execute on any one of the database server nodes, each of which has its own independent OS filesystem. You say it does nothing, but perhaps you are simp...
61125 Feb 2015 @ 12:01 PSTDatabaseReplyTeradata error 2513 A data row is too longWhen you GROUP BY or ORDER BY, the grouping / ordering keys are appended to the spool row - with any variable length fields padded to max length.
61025 Feb 2015 @ 11:59 PSTGeneralReplyHow to get unique ID for the concurrent jobsYes, it would be interesting to compare the EXPLAINs. It seems that in one case the optimizer is certain that at most one row will be inserted and opts to use a RowHash Write lock (which ...
60925 Feb 2015 @ 10:21 PSTAnalyticsReplyConcat and case when statementThe extra "C.P_NBR" in front of the CASE looks like a function reference to the parser. Just remove that. C.GRP_NBR||C.SUBGRP_NBR||(CASE WHEN C.P_NBR = 'NA' THEN ' ' ELSE...
60819 Feb 2015 @ 01:29 PSTDatabaseReplyHow to pass special characters as parameter in Stored ProcedureTo include a single quote within a string, enter two single quotes in a row, e.g. DEFAULT ''N'',
60707 Feb 2015 @ 08:14 PSTCloud ComputingReplyError while running tpt on vmware TD13.10You don't want the Source prefix, just fix the typo in UserName.
60605 Feb 2015 @ 01:23 PSTCloud ComputingReplyError while running tpt on vmware TD13.10On the tdload command line.
60505 Feb 2015 @ 08:45 PSTToolsReplyFAST LOAD Failing in mainframe jobUse apostrophes (') not quotation marks (") around the delimiter.
60405 Feb 2015 @ 08:40 PSTCloud ComputingReplyError while running tpt on vmware TD13.10Specify the TDPID using the -h option, e.g. append -h localhost
60327 Jan 2015 @ 08:39 PSTDatabaseReplyDrop Error: Falied 3932Teradata requires that a DDL statement be the last/only statement in a unit of work - it must be committed before any additional statement can be submitted. And a multi-statement request is implic...
60227 Jan 2015 @ 08:35 PSTDatabaseReplyExtend Partition BehaviorIn the first example, the CREATE TABLE defines one partition of a single day and the rest full months. Since there is no uniform pattern for the original range, adding new months is treated as...
60123 Jan 2015 @ 04:32 PSTToolsReplyNumber of Utility Load SlotsNote that if you activate TASM utility throttles, the MaxLoadTasks and MaxLoadAWT from dbscontrol are no longer used. But the AWT usage rules still apply.
60023 Jan 2015 @ 04:23 PSTDatabaseReplyTPT Table LoadThe CREATE TABLE in your TPT job defines #TIMESTAMP as VARCHAR(20). Casting that string to DATE directly fails. The INSERT/SELECT converts the string to a TIMESTAMP(0), which can be cast...
59919 Dec 2014 @ 03:07 PSTToolsReplyMLOAD and loading of: Empty Strings and Null StringsThis behavior is documented in the MultiLoad manual. Supplying NULL rather than a zero-length string was a conscious choice. As the original poster noted, you can use CASE/COALESCE in the INS...
59818 Dec 2014 @ 10:39 PSTDatabaseReplyJoin Index and Value OrderingRows are still distributed to an AMP based on the high order portion of the RowHash, but within an AMP the ordering value is substituted in place of the RowHash (in the MI/...
59718 Dec 2014 @ 09:44 PSTDatabaseReplySystem Views DBC.COLUMNSTATS & DBC.MULTICOLUMNSTATS not existig in TD 14With the TD14 views, rows will be only returned when stats are present, so there is no need for the NOT NULL filter in the above queries. (Alternatively, if you were interested in findin...

Pages