58092 | 28 Jun 2016 @ 11:34 PDT | Ivyuan | Tools | Reply | FastExport : SET SESSION SEARCHUIFDBPATH | Hi,
You can send the SQL after the LOGON statement and before .BEGIN EXPORT statement. Here is an example:
.LOGTABLE fexplog;
.LOGON <the tdpid>/<the user id>, <the user password&... |
58091 | 28 Jun 2016 @ 10:56 PDT | TDScott | Database | Reply | Recommendations for dynamic phrase searching with tagging output. | and one more correction, cursor_name should be cursor_bob.
For completeness, here is a SQL Server implementation using Contains Full Text Indexing, this works. I would much rather do ... |
58090 | 28 Jun 2016 @ 10:15 PDT | TDScott | Database | Reply | Recommendations for dynamic phrase searching with tagging output. | correction, on the second group of insert examples, I meant Z_Text not Z_Tag.
|
58089 | 28 Jun 2016 @ 09:55 PDT | timlisa20 | Connectivity | Reply | ODBC Connection Error - Specified driver could not be loaded | above you said "UPDATE: I found the issue. The system PATH variable still had references to the Teradata/Client/14.00 ODBC driver, even after complete uninstallation. Perhaps the uninstallers ... |
58088 | 28 Jun 2016 @ 09:27 PDT | TDScott | Database | Topic | Recommendations for dynamic phrase searching with tagging output. |
Hi All,
Looking for recommendations on Full Text search Tagging via LIKE / LIKE ANY etc.
This has to be dynamic, from a table of terms and tags.
I have a billio... |
58087 | 28 Jun 2016 @ 09:20 PDT | sachin.sebastian | General | Reply | Store Backup of table strucutre into an table | If you have a process to maintain the tables without ALTER (Backup data, Drop & Recreate for changes), you could just directly use the 'RequestText' value from DBC.Tables
SEL Databas... |
58086 | 28 Jun 2016 @ 09:11 PDT | sachin.sebastian | General | Reply | transpose in teradata(columns to rows viseversa) | You can also try out the TD_UNPIVOT Function (available from Teradata 14.10)
|
58085 | 28 Jun 2016 @ 08:56 PDT | sachin.sebastian | General | Reply | table needs change | This can be done in multiple ways. Below is one way:
SEL ROLL
, CASE WHEN (EXECF =1 OR LARGEF = 1 OR MED = 1 OR SM = 1) THEN NULL ELSE AUTOF END AS AUTOF
, CASE WHEN (EXECF =1 OR LARGEF = 1 OR... |
58084 | 28 Jun 2016 @ 08:50 PDT | fgrimmer | Teradata Studio | Reply | Issue Downloading Studio even After Java installed | It looks like you have the 32-bit JRE installed. The 64-bit JRE would show something like:
java version "1.8.0_91"
Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
Java Ho... |
58083 | 28 Jun 2016 @ 08:19 PDT | sachin.sebastian | General | Reply | Join Index | If your sql is covering sql. ie all columns needed to process the query are present in the existing index.
If a query refers to only columns that are part of the index, Teradata would decide ... |
58082 | 28 Jun 2016 @ 08:00 PDT | sachin.sebastian | General | Reply | How to detect updates in a teradata table at runtime without using timestamp column or last acess time stamp, | You may want to explore 'Triggers'
|
58081 | 28 Jun 2016 @ 07:30 PDT | quest | Database | Topic | Transaction control in BTEQ script | Hi all,
I am coding for SCD (Slowly changing Dimension) 2 in BTEQ script. What should be ideal code to avoid mess up of data considering SCD-2?
As of now, if there is an error we quit but is ther... |
58080 | 28 Jun 2016 @ 06:04 PDT | AtardecerR0j0 | Database | Reply | leading zeroes |
select 7 (format '999')(char(3))
This is other way
|
58079 | 28 Jun 2016 @ 06:04 PDT | VandeBergB | Database | Reply | it seems teradata doesn't support != as not equal, right? | A left outer join will work as well.
|
58078 | 28 Jun 2016 @ 05:20 PDT | hagrdan | Database | Reply | Database per object type -- Best practice or over engineered? | OK, again thank you. The best solution we have so far is to wrap all our "CREATE VIEW" DDL in stored procedures, and to pass the various required database names in as arguments depe... |
58077 | 28 Jun 2016 @ 04:44 PDT | rahul1987 | Database | Reply | it seems teradata doesn't support != as not equal, right? | can we use Not IN if we want to see a row whci is not present in other table Ex;- Examine some of the rows in the trnsact table that are not in the skstinfo table?
Select a.sku,b.sku... |
58076 | 28 Jun 2016 @ 04:40 PDT | sri67 | Analytics | Reply | Help extracting select time period records ( rank / any other way) | Thanks for your quick response. It worked. As I am new to Teradata, your help keeps me going and have a attitude to learn new.
Appreciate your help
|
58075 | 28 Jun 2016 @ 03:53 PDT | dnoeth | Database | Reply | leading zeroes | + is a numeric operator, only SQL Server uses it for string concat.
But you don't need any fancy calculation, simply use LPAD(ID_FD, 3, '0')
|
58074 | 28 Jun 2016 @ 03:48 PDT | irtizaN | Connectivity | Reply | Teradata ODBC driver with Apache/PHP | Wrote the wrong error message in my post earlier: The error I'm getting is:
Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default dri... |
58073 | 28 Jun 2016 @ 03:20 PDT | YIAPIPI | Database | Topic | leading zeroes | Hi all,
i trying to get in a 3 digit "INT" field, the leading zeroes.
substantially i need to change "1" to "001" or "12" to "012" and... |
58072 | 28 Jun 2016 @ 02:45 PDT | irtizaN | Connectivity | Reply | Teradata ODBC driver with Apache/PHP | Hi,
Great post on setting up PHP with Teradata. My environment is almost ready, but I'm getting the following error and it doesn't seem anyone who's posted it above has been able to re... |
58071 | 28 Jun 2016 @ 02:44 PDT | Swapna1083 | Database | Reply | Revoke User | Hi,We have checked in DBC.LogonRules but we are unable to retrieve the information for all users,can you or anyone can help me how to get the information
|
58070 | 28 Jun 2016 @ 01:10 PDT | M.Saeed Khurram | Aster | Reply | using Teradata Stored Procedures to pull data into Aster | Hi,
load_from_Teradata is an MR function that can only be called inside a SELECT statement. But you can call this select query inside Procedure and use the resultset in your procedure.
Please let... |
58069 | 28 Jun 2016 @ 01:08 PDT | M.Saeed Khurram | General | Reply | steps to install td-ttu-15.10.05_for_Windows | Hi Michael,
Which CPU do you have? Teradata VM is supported on almost all of the CPUs.
If you are trying to learn Teradata on your own, VM-Ware is the only option.
Br,
Khurram
|
58068 | 28 Jun 2016 @ 12:36 PDT | dnoeth | Database | Reply | How to Write the correct syntax for Join | That's the same query you already got on StackOverflow:
SELECT COUNT(DISTINCT a.sku),COUNT(DISTINCT b.sku),COUNT(DISTINCT c.sku)
FROM skuinfo a
JOIN skstinfo b
ON a.sku=b.sku
JOIN tr... |