#DateForumTypeThreadPost
99616 May 2016 @ 02:05 PDTTeradata Database on VMWareReplyConfused over which VM to downloadFor Windows 10 you can use VMWare Workstation Player 12. No, for TDE 15.0 and TDE 15.10, only 40GB images are provided.
99516 May 2016 @ 01:02 PDTDatabaseReplyHow to resolve 'string contains untranslatable character' while using XMLAGG in TeradataWhat client character set are you using for the INSERT? Have you checked, e.g. using CHAR2HEXINT, to be sure proper UNICODE values have been stored?  
99414 May 2016 @ 04:38 PDTDatabaseReplySelected non-aggregate values must be part of the associated groupInstead of CASE WHEN condition THEN SUM(expression) ELSE 0 END you need to code these as SUM(CASE WHEN condition THEN expression ELSE 0 END)
99314 May 2016 @ 04:34 PDTToolsReplyHow to make use of ARCMAIN utility to take DB backup.Please start a new topic for new questions. Someone or some automatedl process (e.g. monitoring "idle" sessions) issued an ABORT. Check DBC.Software_Event_LogV for more detail. You may ...
99214 May 2016 @ 04:30 PDTDatabaseReplyError while Executing a Dynamic SQL in Teradata Stored ProcedureSELECT is not valid for EXECUTE IMMEDIATE. If you want to build a SELECT statement dynamically, use a dynamic cursor DECLARE C1 CURSOR FOR S1; PREPARE S1 FROM UPD_STRING; OPEN C1;   ...
99114 May 2016 @ 04:26 PDTDatabaseReplyexecute immediate with sting in sql statement in teradataAnswered in the other thread. Please open a new topic for new questions - go to hte main page for this forum and click the big button at the top.
99011 May 2016 @ 09:01 PDTDatabaseReplyRELEASE MLOADCorrect.
98911 May 2016 @ 09:00 PDTDatabaseReplySecurity - DBADMIN vs individual DBA accounts - tracing accountabilityUsing DBADM (or SECADM), you could create stored procedures with SQL SECURITY CREATOR, which perform administrative functions via dynamic SQL. Then grant EXECUTE PROCEDURE to the individual DBAs (d...
98810 May 2016 @ 12:22 PDTDatabaseReplyHow to load chinese characters - RDBMS:5356Is it possible that there is a different (older) UDF installed named OREPLACE? Try qualifying with TD_SYSFNLIB. Also, since this is a single character, I would use OTRANSLATE instead of OREPL...
98710 May 2016 @ 10:53 PDTDatabaseReplyhexadecimal values and char- to and froThe repertoire for XC literals defaults to the session default character set. It appears your default is _Latin so '000A'XC is two characters. You can explicitly specify _Unicode '000A...
98609 May 2016 @ 11:25 PDTDatabaseReplyRELEASE MLOADThere are two forms of RELEASE MLOAD command.   In the acquisition phase, cleanup is simple since no changes have actually been made to the target table. In the application phase, the targe...
98509 May 2016 @ 10:17 PDTDatabaseReplyHelp with update statementSyntactically: when the FROM clause includes the target table, use the alias before the FROM. Never use the alias on left hand side of SET.   UPDATE MBR FROM ENTPR_INTEL_TDW.VBC_MBR_AT...
98406 May 2016 @ 03:26 PDTDatabaseReplyBad data in table , need suggestion to isolate the problemIt's possible that data can be stored as a valid TIMESTAMP value but it's so close to the min/max allowable that applying the local / session time zone offset causes the result to...
98306 May 2016 @ 02:57 PDTDatabaseReplyHow to identify Expired Partitions in Teradata v14.0There is no simple solution. You can parse ConstraintText from DBC.PartitioningConstraintsV.
98206 May 2016 @ 02:52 PDTConnectivityReplyConnection from SAS and the ability to change Teradata passwordWhat sort of failure do you see?   From the database side, when the password is expired logon succeeds but a MODIFY USER to change the passsword is the only acceptable statement. So I ...
98106 May 2016 @ 02:32 PDTTeradata ApplicationsReplyTPT 15.00.00This question belongs in the TOOLS forum. You need to supply the MaxDecimalDigits parameter for the export operator. (The default is 18 digits.)
98006 May 2016 @ 02:20 PDTDatabaseReplyExecution modes in teradata'S' indicates one of the "Embedded Services" System Functions in TD_SYSFNLIB
97906 May 2016 @ 02:10 PDTDatabaseReplyCAST VarcharIn Teradata mode, string right truncation is ignored. But in ANSI mode, you get 3996 error if a non-blank character is truncated. Eliminate the error either by increasing the length for ...
97803 May 2016 @ 01:43 PDTToolsReplyTTU programs fail to open The uninstall script is specifically designed to remove earlier versions. Why not use the uninstall from 15.10 to remove 14.10, then reinstall a complete 15.10.01?
97702 May 2016 @ 11:10 PDTToolsReplyTPT wizard finish button to run is not doing anythingMost likely you don't have write access to the "objectrepository" subfolders to save the definition. By default, REPOSITORY_ROOT is set to C:\Program Files (x86)\Teradata\client\15.0...
97628 Apr 2016 @ 03:56 PDTToolsReplyTPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11If "same" means Signal 11, that could be due to mixing 32-bit libraries with 64-bit application or vice versa. It could also be a bug. Be sure you have PATH, etc. is correct in...
97523 Apr 2016 @ 09:49 PDTGeneralReplySAP BODS script + teradata fails with "Only an ET or null statement is legal after a DDL"It appears that BODS has wrapped your script call with BT; / ET; but Teradata requires DDL to commit or roll back before any other statement is allowed. CREATE VOLATILE TABLE ... E...
97421 Apr 2016 @ 12:23 PDTDatabaseReplyTerradata : Terradata not taking table-name for query.Are you just saying that the wording of the error message is a bit misleading and it would be clearer to say: Column smallname not found in a or b or Column smallname not found in domain.sourceT...
97319 Apr 2016 @ 01:58 PDTDatabaseReplyquery to find roles and access rights relatedBy default, some DBC views have SELECT access granted to PUBLIC. Some of these rights can be revoked, but the client drivers need some way to retrieve metadata in order to process queries and resul...
97217 Apr 2016 @ 11:12 PDTGeneralReplySet tenacity and sleep in Tearadata JDBCIt appears you don't have utility throttles defined in workload management.   In that case, the logic to catch the 2633 error, sleep, and retry would have to be added to the Java applica...

Pages