#DateForumTypeThreadPost
102101 Jul 2016 @ 01:17 PDTTrainingReplyScript with the variable CURR_DATECURR_DATE appears to be a column in your Reporting_DB.V_REPORT_DATE view.
102001 Jul 2016 @ 01:12 PDTDatabaseReplyTeradata Table Naming No, existing objects are not affected. The new Name Validation rule applies when you CREATE new objects (or for the new name specified on a RENAME).
101930 Jun 2016 @ 04:07 PDTDatabaseReplyRevoke UserYou typically don't have LogonRules for every user; there are generic / "wild card" rules as well. The search order is: Session UserName and LogicalHostID both match a&nb...
101830 Jun 2016 @ 03:51 PDTConnectivityReplyODBC error (64bit)Teradata Studio doesn't use ODBC.   If you need ODBC for some other application, you probably need to clean up a previous failed install. Within the TTU distribution there is ...
101730 Jun 2016 @ 03:37 PDTToolsReply2555:TABLE DOES NOT BELONG TO THE MLOAD JOB.The MLOAD itself must create the log, work, and error tables when first started, and any restart must use the tables created by the initial run. You cannot create or drop these tables ma...
101623 Jun 2016 @ 03:25 PDTDatabaseReplyTransaction QUERY_BAND not workingHow are you submitting these statements? The semicolon at the start of the line is BTEQ-specific syntax for a multistatement request.
101522 Jun 2016 @ 03:38 PDTTeradata Database on VMWareReplyConfused over which VM to downloadNote that this forum is intended mainly for Teradata Virtual Machine Edition on VMWare ESX / ESXi (TVME). See the Cloud Computing forum on this site for discussions related to Teradata Express for...
101421 Jun 2016 @ 09:36 PDTTeradata StudioReplyTeradata Studio does not show all of my authorized tables-You can right-click on the "Databases" folder and use Teradata / Set Root rather than having to navigate down the tree.
101321 Jun 2016 @ 09:31 PDTToolsReplyNot able to download SQL AssistantIt's part of the TTU - Windows Install package here on this site. Or get it from T@YS. http://downloads.teradata.com/download/tools
101221 Jun 2016 @ 09:20 PDTDatabaseReplyBteq-import- Error Handling Not workingThe .IF command can only test the results of the most recent SQL statement (ERRORCODE, ERRORLEVEL, or ACTIVITYCOUNT), not other BTEQ commands. You apparently meant to .SET ERRORLEVEL 3807 SEVERITY...
101116 Jun 2016 @ 06:53 PDTDatabaseReplyInteger to date conversionCheck the logic in dbc.UsersV view definition.
101016 Jun 2016 @ 06:45 PDTDatabaseReplycalculate date errorDon't use INTERVAL MONTH arithmetic for this. There is no 2014-11-31 (18 months before 2016-05-31), but ANSI semantics for INTERVAL types only modifies the portion of the date/time value at the...
100909 Jun 2016 @ 02:35 PDTDatabaseReplyUnable to release locksEither re-run and complete the restore or drop the tables.
100809 Jun 2016 @ 02:24 PDTDatabaseReplySeeing Junk character when inserting hyphen (-)That combination of characters is the 3-byte UTF-8 representation of EN DASH U+2013, misinterpreted as Windows-1252. In short, you are loading UTF-8 data using ASCII as the session character set. ...
100704 Jun 2016 @ 08:03 PDTDatabaseReplyDBC space.( How much perm space and spool space) should be allocated. DBC PermSpace includes the data dictionary, log tables (e.g. ResUsage, DBQL) and should also be large enough to accommodate in-flight "Transient Journal" space. How much is needed will de...
100604 Jun 2016 @ 07:24 PDTGeneralReplyHow to download and install teradata on windows 10To run Teradata Express database on Windows you will need a VMWare server or player. The current version of the free Workstation Player should work. Also see "Teradata Express for VMWare"...
100504 Jun 2016 @ 07:15 PDTToolsReplyEncrypted logon fileThe short answer is no. A file input to .RUN must be plain text. If you must use ccrypt, you could wrap the BTEQ in a shell script that unencrypts the logon command and redirects it to BTEQ...
100404 Jun 2016 @ 06:46 PDTGeneralReplyInstall Teradata Windows or Open SuseMost of the information in this User Guide still applies: http://developer.teradata.com/database/articles/teradata-express-14-0-for-vmware-user-guide   If you have additional questions, ple...
100303 Jun 2016 @ 04:18 PDTDatabaseReplySTRTOK_SPLIT_TO_TABLEYou would use the passed-through "key" value to join the result back to the input table, in order to pick up more columns from the original row. (Which may require first c...
100203 Jun 2016 @ 04:08 PDTTeradata ApplicationsReplyUnity Source LinkOn the Teradata public documentation website http://www.info.teradata.com, click on "Data Warehousing" category and you will see Teradata QueryGrid as one of the subcategor...
100127 May 2016 @ 01:54 PDTDatabaseReplyCopying trillions of data to new tableFor huge volume, generally you want the target table to be empty and same structure as source, but with no SIs / JIs. Drop SIs, Delete, Insert/Select, re-Create SIs. The Delete should be done in ...
100020 May 2016 @ 04:24 PDTToolsReplySet TimeZoneString value using tdlocaledef or dbscontrol utilitiesYou can't update just one entry in the SDF, you must supply a complete SDF. The recommended process is to extract the current SDF settings to a text file, edit the text file, and then apply to ...
99920 May 2016 @ 04:08 PDTDatabaseReplyLocking Within Stored ProcedureFor row(hash)-level lock to be granted, the WHERE clause must specify the Primary Index value.
99820 May 2016 @ 03:58 PDTToolsReplyNeed help in using SQL AssistantIf you use the .NET data provider with SQL Assistant (as recommended), then you can used the Advanced connection properties to control the color bar at the top of the query window as...
99717 May 2016 @ 03:28 PDTTeradata Database on VMWareReplyConfused over which VM to downloadSee the "getting started" document. Click on the login box and leave the mouse cursor there. Use root for both login and password.  

Pages