#DateForumTypeThreadPost
52114 Jan 2014 @ 11:26 PSTConnectivityReplySqoop Import from Teradata with 30 lines of SQL query using –query is failingWhy do you have \$CONDITIONS after the GROUP BY list?
52014 Jan 2014 @ 11:09 PSTConnectivityReplyWhich Teradata drivers support data encryption?No, you can't use .NET provider unless you change the application. Yes, if you simply upgrade to the current version of ODBC you can set data encryption in the DSN properties.
51910 Jan 2014 @ 04:03 PSTDatabaseReplyTeradata Question regarding deleting duplicated & Merge statementTeradata does not allow the left-hand side of SET to be explicitly qualified. Also MERGE does not allow updating a column that is used in the match (ON condition). Do a joined UPDATE instead.
51809 Jan 2014 @ 12:46 PSTToolsReplyOLELoad and FastLoad on LinuxNo, you can't use the AMJ files on Linux. OLELOAD is Windows-only. And FastLoad can only communicate with Teradata. Consider using TPT with Load and ODBC operators, plus a SQL Server ODBC driv...
51709 Jan 2014 @ 12:38 PSTDatabaseReplyProper database Terms for for Teradata I can understand the confusion. There is an unfortunate tendency in Teradata literature to use the word "database" to refer to both an instance of the Teradata Database (what Studio...
51608 Jan 2014 @ 09:41 PSTToolsReplyTPT Template operators with LDAP authenticationDoes the password contain special characters, e.g. @? If so, use escape sequence: \@
51508 Jan 2014 @ 09:35 PSTDatabaseReplyMODE and FORMAT - TD Utilities.RE: Using output of FastExport as input to FastLoad If there is a chance you have NULL values, use INDICATOR mode (the default) on the export and specify INDICATORS (NOT the default...
51403 Oct 2013 @ 02:35 PDTDatabaseReplyUsing MONTH in case statementBecause there is no MONTH function. Try EXTRACT(MONTH FROM ORDER_DATE) = EXTRACT(MONTH FROM DATE).
51302 Aug 2013 @ 05:14 PDTGeneralReplyHow do i know how much CPU consumed by running query(not completed one) within session using Monitorsession function?The AMPCPUTime value is for the active request, not the entire session.  
51202 Aug 2013 @ 05:06 PDTTeradata ApplicationsReplynewbie question getting started1) Right click on the schema, choose "new table" 2) Neither. You can't create in PUBLIC or DEFAULT, and DBC should normally be reserved for the system. Start by creating your own ne...
51102 Aug 2013 @ 05:03 PDTGeneralReplySelect all Column Names where the Row value = '1'UPDATE TABLEX SET Z = TRIM(TRAILING '/' FROM (CASE WHEN A>0 THEN 'A/' ELSE '' END||  CASE WHEN B>0 THEN 'B/' ELSE '' END||  CASE W...
51026 Jul 2013 @ 02:15 PDTDatabaseReplySTDOUT output file locationsYou use standard OS redirection on the command line to send STDOUT to a file, e.g.   bteq <myScriptFile.txt >myOutputFile.txt
50926 Jul 2013 @ 02:10 PDTDatabaseReplyCreate volatile table failed 3707 expected Unicode delimited identifier...The "derived table expression" in the FROM clause must have a name, e.g. and REQ.APRVD_INPAT_DAYS_NBR > 0 ) MyDT ) WITH DATA But the outer SELECT isn't adding any value. Wh...
50817 Jul 2013 @ 11:32 PDTUDAReplywhy should we use SET table ? Simply having a NUPI does not slow down inserts, and having a small number of duplicates won't be a problem. But when you insert the Nth row with the same NUPI, Teradata must check ...
50717 Jul 2013 @ 11:02 PDTDatabaseReplyHow to find the system IP of Teradata Account Locked by another user with a usernameThe offending client IP should be recorded in DBC.LogOnOffV where Event='Bad Password' and UserName=<your ID>.
50617 Jul 2013 @ 10:58 PDTDatabaseReplyCan someone plz elaborate with example on byte-packed format rather than byte-aligned formatSee the Database Design manual for discussion and examples.
50517 Jul 2013 @ 10:55 PDTDatabaseReplyDownload Teradata Express 13.0 for WindowsTeradata Express for Windows is no longer available. Teradata Express for VMWare still has TD13.0 available, as well as newer versions.
50417 Jul 2013 @ 10:43 PDTConnectivityReplyUnable to connect to Local host/dbcTeradata Studio [Express] is a client tool. You'll need a Teradata database server also. Install Teradata Express for VMWare on your PC, if you don't have access to an actual Teradata ...
50317 Jul 2013 @ 10:33 PDTDatabaseReplyDifference between Application RI,Batch RI,explicit & standard RI?Explicit just means the RI constraints are declared to the database. So Standard, Batch, Soft are all explicit. The Application can also enforce RI without explicitly declaring (Soft) co...
50216 Jul 2013 @ 03:40 PDTDatabaseReplyDifference between Application RI,Batch RI,explicit & standard RI? Standard - checked for each individual SQL request Batch - checking postponed until transaction COMMIT time Soft - not enforced by the DBMS (in which it should be Appli...
50116 Jul 2013 @ 03:09 PDTConnectivityReplyPrecision error in FLOAT type constant or during implicit conversionsWhen one of the terms is numeric and the other is a string, Teradata will attempt to implicitly convert both to FLOAT in order to do the comparison. Make the data types match; e.g. use a numeric co...
50016 Jul 2013 @ 03:03 PDTGeneralReplyError while creating Volatile TableYou may be using Teradata SQL Assistant 14.01 as the client tool, but the database you are connected to is a DB2 instance. It does not recognize Teradata-specific SQL.  
49916 Jul 2013 @ 02:53 PDTDatabaseReplySystem Views DBC.COLUMNSTATS & DBC.MULTICOLUMNSTATS not existig in TD 14See the Data Dictionary manual for TD14. Stats information is significantly changed. DBC.ColumnStatsV, DBC.IndexStatsV, DBC.MultiColumnStatsV exist but are likely not direct replacement for your a...
49812 Jul 2013 @ 01:47 PDTToolsReplyTPT - TenacityThe utilities support a "configuration file" to set parameter defaults, and many sites use some sort of "wrapper" scripts. But if your jobs were not designed that way to start w...
49708 Jul 2013 @ 10:07 PDTGeneralReplyReg: spool space errorThe date is (20)13-07-02 (02 July 2013), so not that long. But as Dieter noted, the type mismatches and character set TRANSLATEs can result in stats not being used, even if they are current. &nbs...

Pages