#DateForumTypeThreadPost
41909 Feb 2015 @ 12:18 PSTDatabaseReplyIdentifying the Target of an IUD (insert/update/delete) OperationHave you considered using the EXPLAIN command?   You could retrieve the SQL request text from DBQL, prepend an EXPLAIN keyword, and then execute the resulting SQL command.   For examp...
41802 Feb 2015 @ 06:51 PSTConnectivityReplyJDBC auto refreshI don't know what TMM does, but a typical way to do what you're asking is to add a trigger to the table, and have the trigger add a row to a queue table. Your application would need a separ...
41730 Jan 2015 @ 11:46 PSTToolsReplyFastload Skips Header when using from JavaBy the way, here is a code snippet to illustrate how to dynamically prepend a column header line to a CSV InputStream. The basic idea is to use a SequenceInputStream to combine the column header li...
41630 Jan 2015 @ 09:29 PSTToolsReplyFastload Skips Header when using from JavaI assume that you are using the JDBC FastLoad CSV feature of the Teradata JDBC Driver.   The JDBC FastLoad CSV feature always expects the first line of the CSV text file to contain the colum...
41522 Jan 2015 @ 06:57 PSTExtensibilityReplyJAVA UDF in TD 13.10 With SQL Query - not able to establish connection with TDRegarding: "I suggested that we do this in pre-calculated table form but the problem is that the parameter values can vary depending upon user and region."   That approach may be t...
41421 Jan 2015 @ 09:50 PSTExtensibilityReplyJAVA UDF in TD 13.10 With SQL Query - not able to establish connection with TDSpeaking generally, you may be able to use a table operator instead of a UDF. A table operator is a kind of UDF, so it is still subject to the same limitation of not being able to use the JDBC defa...
41320 Jan 2015 @ 06:41 PSTExtensibilityReplyJAVA UDF in TD 13.10 With SQL Query - not able to establish connection with TDJava UDFs do not have access to the JDBC default connection, so you cannot execute SQL statements using the JDBC default connection. (C/C++ UDFs have the same limitation.)   Y...
41213 Jan 2015 @ 06:47 PSTGeneralReplyQuestion Regarding Insert Data from CSV-FileThe problem lies with the csvReader. Your code example doesn't show how the csvReader object is constructed and initialized with the filename.   Your program would need to specify the ch...
41109 Jan 2015 @ 12:03 PSTDatabaseReplyFeature Request - It would be nice if we could join on null without having to do extra workAll occurrences of null in a column are identical to each other.   Please explain what the join criteria would be. How would certain null values in one table's column be related to other...
41009 Jan 2015 @ 11:49 PSTAnalyticsReplyPassing a string into a macro for use in a IN statementAs a workaround, you can use the STRTOK_SPLIT_TO_TABLE function to split a character literal containing comma-separated values into a derived table, and then use the derived table as the right...
40909 Jan 2015 @ 11:11 PSTAnalyticsReplyPassing a string into a macro for use in a IN statementUnfortunately, what you want to do is not possible.   You can use a single macro argument as a single value for the right side of the IN predicate, but you cannot use a single macro argument...
40809 Jan 2015 @ 10:48 PSTConnectivityReply"PE only" nodes - should they be included in the "COP" list?If your site uses cop hostnames, then each node that is running a Teradata Database Gateway (GTW) process should have a cop# hostname defined in DNS.   Keep in mind that cop hostnames are no...
40707 Jan 2015 @ 12:38 PSTConnectivityReplyconnection using JDBC giving java.lang.IllegalArgumentExceptionThe exception is occurring in low-level code in the Teradata JDBC Driver to deserialize the binary data received from the Teradata Database. An exception from that low-level code might be...
40606 Jan 2015 @ 09:52 PSTConnectivityReplyJDBC Connection for Web SQL AssistantWe provide an extensive collection of over 100 example Java programs that show how to use the Teradata JDBC Driver, available here on Developer Exchange: http://developer.teradata.com/doc/connecti...
40506 Jan 2015 @ 09:44 PSTConnectivityReplyconnection using JDBC giving java.lang.IllegalArgumentExceptionAre you attempting to use the Teradata JDBC Driver from a Java Stored Procedure running inside the Oracle Database? That is not an environment that we test with or support.   If you're a...
40406 Jan 2015 @ 09:33 PSTConnectivityReplyUsing RJDBC and connected successfully, I get errors when trying to write using "as.td.data.frame" or "dbWriteTable"...Please refer to Andreas Marek's blog http://developer.teradata.com/blog/amarek for examples of how to use the Teradata JDBC Driver with R.
40306 Jan 2015 @ 06:56 PSTConnectivityReplyJDBC connection via VPN vs non-VPNThis kind of problem hasn't been reported before, so we don't know the cause, and therefore can't recommend connection options to avoid the problem.   The first step is to t...
40218 Dec 2014 @ 09:32 PSTDatabaseReplyCREATE TABLE AS STATEMENT ERRORIt's probably a Teradata Database bug. If you're a customer, you can open an incident with Teradata Customer Service to report the problem.
40110 Dec 2014 @ 12:54 PSTDatabaseReplywrite SQL UDF in Teradata REPLACE FUNCTION ADD_DAYS(p1 DATE, p2 INTEGER) RETURNS DATE LANGUAGE SQL CONTAINS SQL DETERMINISTIC SQL SECURITY DEFINER COLLATION INVOKER INLINE TYPE 1 RETURN p1 + CAST(p2 AS INTERVAL DA...
40005 Dec 2014 @ 12:30 PSTConnectivityReplyIs it possible to connect to Teradata from Excel without installing Teradata drivers?Software to access a database is neither "simple" or "basic".
39921 Nov 2014 @ 06:46 PSTDatabaseReplyREGEXP_SPLIT_TO_TABLE Error - Unexpected failure while attempting to convert UTF8 to UTF16.I agree that the behavior is unexpected. If you're a customer, then I recommend opening Teradata Customer Service incident.
39820 Nov 2014 @ 09:48 PSTDatabaseReplyREGEXP_SPLIT_TO_TABLE Error - Unexpected failure while attempting to convert UTF8 to UTF16.I executed your SQL statements using Teradata Database 15.0 and I got the following result:   res     tokennum  token ------  --------  ------------ 76...
39719 Nov 2014 @ 01:15 PSTDatabaseReplyREGEXP_SPLIT_TO_TABLE Error - Unexpected failure while attempting to convert UTF8 to UTF16.If your CIRCUITID column is supposed to contain Unicode characters, then it would be challenging to determine which rows contain the problematic characters.   But if your CIRCUITID column is...
39619 Nov 2014 @ 12:05 PSTDatabaseReplyREGEXP_SPLIT_TO_TABLE Error - Unexpected failure while attempting to convert UTF8 to UTF16.Please provide the CREATE TABLE command for the TEST table.
39514 Nov 2014 @ 12:28 PSTGeneralReplyTeradata to Vertica MigrationFirst, your forum post is very close to being a troll post. I won't delete it, but another forum moderator might.   Second, it would be better to ask your question on a Vertica technical...

Pages