419 | 09 Feb 2015 @ 12:18 PST | Database | Reply | Identifying the Target of an IUD (insert/update/delete) Operation | Have 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... |
418 | 02 Feb 2015 @ 06:51 PST | Connectivity | Reply | JDBC auto refresh | I 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... |
417 | 30 Jan 2015 @ 11:46 PST | Tools | Reply | Fastload Skips Header when using from Java | By 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... |
416 | 30 Jan 2015 @ 09:29 PST | Tools | Reply | Fastload Skips Header when using from Java | I 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... |
415 | 22 Jan 2015 @ 06:57 PST | Extensibility | Reply | JAVA UDF in TD 13.10 With SQL Query - not able to establish connection with TD | Regarding: "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... |
414 | 21 Jan 2015 @ 09:50 PST | Extensibility | Reply | JAVA UDF in TD 13.10 With SQL Query - not able to establish connection with TD | Speaking 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... |
413 | 20 Jan 2015 @ 06:41 PST | Extensibility | Reply | JAVA UDF in TD 13.10 With SQL Query - not able to establish connection with TD | Java 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... |
412 | 13 Jan 2015 @ 06:47 PST | General | Reply | Question Regarding Insert Data from CSV-File | The 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... |
411 | 09 Jan 2015 @ 12:03 PST | Database | Reply | Feature Request - It would be nice if we could join on null without having to do extra work | All 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... |
410 | 09 Jan 2015 @ 11:49 PST | Analytics | Reply | Passing a string into a macro for use in a IN statement | As 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... |
409 | 09 Jan 2015 @ 11:11 PST | Analytics | Reply | Passing a string into a macro for use in a IN statement | Unfortunately, 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... |
408 | 09 Jan 2015 @ 10:48 PST | Connectivity | Reply | "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... |
407 | 07 Jan 2015 @ 12:38 PST | Connectivity | Reply | connection using JDBC giving java.lang.IllegalArgumentException | The 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... |
406 | 06 Jan 2015 @ 09:52 PST | Connectivity | Reply | JDBC Connection for Web SQL Assistant | We 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... |
405 | 06 Jan 2015 @ 09:44 PST | Connectivity | Reply | connection using JDBC giving java.lang.IllegalArgumentException | Are 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... |
404 | 06 Jan 2015 @ 09:33 PST | Connectivity | Reply | Using 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.
|
403 | 06 Jan 2015 @ 06:56 PST | Connectivity | Reply | JDBC connection via VPN vs non-VPN | This 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... |
402 | 18 Dec 2014 @ 09:32 PST | Database | Reply | CREATE TABLE AS STATEMENT ERROR | It's probably a Teradata Database bug. If you're a customer, you can open an incident with Teradata Customer Service to report the problem.
|
401 | 10 Dec 2014 @ 12:54 PST | Database | Reply | write 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... |
400 | 05 Dec 2014 @ 12:30 PST | Connectivity | Reply | Is it possible to connect to Teradata from Excel without installing Teradata drivers? | Software to access a database is neither "simple" or "basic".
|
399 | 21 Nov 2014 @ 06:46 PST | Database | Reply | REGEXP_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.
|
398 | 20 Nov 2014 @ 09:48 PST | Database | Reply | REGEXP_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... |
397 | 19 Nov 2014 @ 01:15 PST | Database | Reply | REGEXP_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... |
396 | 19 Nov 2014 @ 12:05 PST | Database | Reply | REGEXP_SPLIT_TO_TABLE Error - Unexpected failure while attempting to convert UTF8 to UTF16. | Please provide the CREATE TABLE command for the TEST table.
|
395 | 14 Nov 2014 @ 12:28 PST | General | Reply | Teradata to Vertica Migration | First, 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... |