#DateForumTypeThreadPost
79614 Dec 2015 @ 02:56 PSTConnectivityReplyCannot connect from oracle database to teradata databaseThe current level of the JDBC driver (15.10) is supported for connections to TD 13.10 and later.
79514 Dec 2015 @ 02:41 PSTTeradata ApplicationsReplyactivate Nontemporal operations with DBS CONTROL or Teradata AdministratorAt Linux command prompt, enter tdatcmd to establish the environment for Teradata utilities and add them to the default search path. Then you can run dbscontrol.
79414 Dec 2015 @ 02:38 PSTDatabaseReplyCommon table expression - out of spool spaceSince TD12, the V views are the preferred / "native" ones, while those without V (where one with V also exists) were rewritten to provide backward compatibility. The X views ar...
79314 Dec 2015 @ 02:07 PSTDatabaseReplyUsing variable in Teradata SIGNALIt's difficult to solve the problem without seeing the actual code. Two things you probably already know: The handler is a single statement, so if you are performing an action and doing...
79210 Dec 2015 @ 03:23 PSTDatabaseReplyCommon table expression - out of spool spaceMain issue is that you need to include the column name in the join conditions. You should be using ColumnsV instead of legacy view Columns. And I think you really should supply the DB/Table for ea...
79110 Dec 2015 @ 01:53 PSTDatabaseReplyFOR cursor in teradata SPAdditional fixes applied below: Use a timestamp literal to set the initial value of NewTS instead of a character literal. Spell "field1" consistently.   REPLACE PROCEDURE SP_name...
79010 Dec 2015 @ 11:22 PSTConnectivityReplyCannot connect from oracle database to teradata databaseThe 8028 message from the Teradata gateway listener is essentially saying that the logon request has been corrupted. Check to make sure you don't have some sort of network issue. Also, I would...
78910 Dec 2015 @ 10:18 PSTToolsReplyRecord Rejected to Error Table if String contains untranslatable character while doing TPT extract/Load in BINARY modeYes. Record format BINARY only describes the output / input file to Data Connector. The Schema still describes the data as character for Load.
78810 Dec 2015 @ 10:08 PSTDatabaseReplyFOR cursor in teradata SPYour UPDATE statement needs a colon to indicate that NewTS is a variable rather than a column name.   UPDATE table_name SET cal_time = :NewTS
78710 Dec 2015 @ 09:59 PSTDatabaseReplyUsing variable in Teradata SIGNALCan you help me understand the issue? L2 calls MAIN. Logic within MAIN issues SIGNAL SQLSTATE 'U0100' SET MESSAGE_TEXT='Some custom message'; Does MAIN have a condition...
78609 Dec 2015 @ 04:35 PSTDatabaseReplyFOR cursor in teradata SPThere should not be a semicolon between the SELECT statement and the DO keyword. Also there is no rec.NewTS or rec.filed1 since you didn't SELECT those columns in your cursor.
78509 Dec 2015 @ 04:24 PSTGeneralReplyPMCPPMCP is an old offering from Teradata Professional Services. Do you mean PDCR? What database version?
78409 Dec 2015 @ 04:18 PSTDatabaseReplyCASTing Date and Time to Timestamp while CASTing Time from varchar to TIMEThe legacy built-in function TIME has type FLOAT so cast((Time) as TIME(0)) is invalid. Use CURRENT_TIME(0) or just CURRENT_TIME instead of TIME.
78308 Dec 2015 @ 08:24 PSTToolsReplyNew to BTEQ and Teradat Question on Export ReportPut the .EXPORT after all the .SET commands. And I should have said .SET SEPARATOR '<tab>' ALL (because I doubt you want a line with only blank titles and separator characte...
78207 Dec 2015 @ 02:17 PSTToolsReplyNew to BTEQ and Teradat Question on Export ReportThe default FORMAT (and default data type) will depend on what you are summing. In FIELD mode, the conversion is done as it is for old-style Teradata type conversions - the length of the ...
78107 Dec 2015 @ 11:11 PSTDatabaseReplyUsing variable in Teradata SIGNALSIGNAL requires a literal value or a (static) declared condition name. But you certainly have the option to RESIGNAL the original condition outward (by not specifying a condition on the R...
78007 Dec 2015 @ 11:03 PSTTeradata ApplicationsReplyHow to create BTEQ Script in LINUX environment??The COPERR environment variable needs to point to the CLIv2 errmsg.cat file. The install process normally sets the correct COPLIB and COPERR values in the default profile, which is why the mes...
77906 Dec 2015 @ 10:33 PSTDatabaseReplyWhy I do not see all the databases in Teradata StudioThe "X views" will show you only things for which you have some access rights (including things granted to "PUBLIC", etc.). If you want more restrictive filterin...
77806 Dec 2015 @ 10:27 PSTTeradata ApplicationsReplyHow to create BTEQ Script in LINUX environment??I don't understand your question. There's no difference between connecting from some flavor of Linux vs some flavor of Unix, as long as there is TTU support for the platform and the ap...
77706 Dec 2015 @ 10:19 PSTCloud ComputingReplyusing SQL Assistant with Studio Express VMYou can run Teradata Studio Express client (successor to SQL Assistant - Java Edition) within current versions of the Teradata Express VM. You should will see the icon on the virtual desk...
77604 Dec 2015 @ 03:56 PSTDatabaseReplyCase join using substring of dataYou can't use CASE in this way. You could potentially use OR: ... AA left join BB ON UPPER(SUBSTR(AA.aa, LENGTH(AA.aa),1)) = BB.bb OR UPPER(SUBSTR(AA.aa, LENGTH(AA.aa)-1,2)) = B...
77503 Dec 2015 @ 08:16 PSTDatabaseReplyDBQL_logging_and_maintenance TD15XYes and no. The script to create the PDCR objects (databases, users,  tables, views, and macros) is supplied "out of the box" within the DIP utility. But DIPPDCR is considered an&nbs...
77430 Nov 2015 @ 07:24 PSTDatabaseReplyUse RESET WHEN change occurs in text fieldYou must have an aggregate function before the window specification, e.g. MAX, even though you are limiting to a single row. Also, don't you want the same date ordering (DESC)?&n...
77330 Nov 2015 @ 07:12 PSTDatabaseReplyNodes TypesNo, they are entirely different. An SWS may or may not be a separate physical node. It is used as the service entry for the system.  
77227 Nov 2015 @ 04:21 PSTToolsReplyFast load IssueYou can use RECORD 2; command to skip the first record. FastLoad does not allow you to concatenate the fields or extract part of a field. You can ignore fields from the input record...

Pages