All forum activity

#DateUserForumTypeThreadPost
5809228 Jun 2016 @ 11:34 PDTIvyuanToolsReplyFastExport : SET SESSION SEARCHUIFDBPATHHi, 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&...
5809128 Jun 2016 @ 10:56 PDTTDScottDatabaseReplyRecommendations 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 ...
5809028 Jun 2016 @ 10:15 PDTTDScottDatabaseReplyRecommendations for dynamic phrase searching with tagging output.correction, on the second group of insert examples, I meant Z_Text not Z_Tag.   
5808928 Jun 2016 @ 09:55 PDTtimlisa20ConnectivityReplyODBC Connection Error - Specified driver could not be loadedabove 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 ...
5808828 Jun 2016 @ 09:27 PDTTDScottDatabaseTopicRecommendations 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...
5808728 Jun 2016 @ 09:20 PDTsachin.sebastianGeneralReplyStore 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...
5808628 Jun 2016 @ 09:11 PDTsachin.sebastianGeneralReplytranspose in teradata(columns to rows viseversa)You can also try out the TD_UNPIVOT Function (available from Teradata 14.10)
5808528 Jun 2016 @ 08:56 PDTsachin.sebastianGeneralReplytable needs changeThis 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...
5808428 Jun 2016 @ 08:50 PDTfgrimmerTeradata StudioReplyIssue Downloading Studio even After Java installedIt 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...
5808328 Jun 2016 @ 08:19 PDTsachin.sebastianGeneralReplyJoin IndexIf 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 ...
5808228 Jun 2016 @ 08:00 PDTsachin.sebastianGeneralReplyHow to detect updates in a teradata table at runtime without using timestamp column or last acess time stamp,You may want to explore 'Triggers' 
5808128 Jun 2016 @ 07:30 PDTquestDatabaseTopicTransaction control in BTEQ scriptHi 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...
5808028 Jun 2016 @ 06:04 PDTAtardecerR0j0DatabaseReplyleading zeroes select 7 (format '999')(char(3)) This is other way
5807928 Jun 2016 @ 06:04 PDTVandeBergBDatabaseReplyit seems teradata doesn't support != as not equal, right?A left outer join will work as well.
5807828 Jun 2016 @ 05:20 PDThagrdanDatabaseReplyDatabase 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...
5807728 Jun 2016 @ 04:44 PDTrahul1987DatabaseReplyit 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...
5807628 Jun 2016 @ 04:40 PDTsri67AnalyticsReplyHelp 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
5807528 Jun 2016 @ 03:53 PDTdnoethDatabaseReplyleading 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')
5807428 Jun 2016 @ 03:48 PDTirtizaNConnectivityReplyTeradata ODBC driver with Apache/PHPWrote 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...
5807328 Jun 2016 @ 03:20 PDTYIAPIPIDatabaseTopicleading zeroesHi 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...
5807228 Jun 2016 @ 02:45 PDTirtizaNConnectivityReplyTeradata ODBC driver with Apache/PHPHi, 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...
5807128 Jun 2016 @ 02:44 PDTSwapna1083DatabaseReplyRevoke UserHi,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
5807028 Jun 2016 @ 01:10 PDTM.Saeed KhurramAsterReplyusing Teradata Stored Procedures to pull data into AsterHi, 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...
5806928 Jun 2016 @ 01:08 PDTM.Saeed KhurramGeneralReplysteps to install td-ttu-15.10.05_for_WindowsHi 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
5806828 Jun 2016 @ 12:36 PDTdnoethDatabaseReplyHow to Write the correct syntax for JoinThat'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...

Pages