#DateForumTypeThreadPost
13303 Dec 2015 @ 12:35 PSTDatabaseTopicUsing variable in Teradata SIGNALHi, I am using Teradata SIGNAL to raise an exception with my own SQL code and message. My SIGNAL code for raising the exception is given below: SIGNAL SQLSTATE VALUE 'U0927' SET MESSAGE...
13220 Oct 2015 @ 12:41 PDTDatabaseReplyTeradata Error 9936: The user does not have access to zoneHi Fred, Thanks for your response. Following are the details: Creator user of the SP:            ROOT_CANADA Caller user of the SP:   &nbs...
13119 Oct 2015 @ 04:51 PDTDatabaseTopicTeradata Error 9936: The user does not have access to zoneHi, We are getting the error 9936 "The user does not have access to zone STG_DB" while calling DBC.SYSEXECSQL. Following is the code of stored procedure: MAIN: BEGIN DECLARE vSQ...
13010 Aug 2015 @ 12:28 PDTToolsReplyTPT_INFRA: TPT04106: Error: Conflicting job names have been specifiedThe slashes issue (error TPT02992) is fixed after upgrading to TPT version 15.00.00.04
12905 Aug 2015 @ 01:09 PDTToolsReplyTPT_INFRA: TPT04106: Error: Conflicting job names have been specifiedNot sure whats going wrong over here but seemingly there is some issue with the slashes.   1- tbuild -L "C:/TEST/New_folder" -f sp.txt WAQ_JOB 2- tbuild -L "C:\TEST\New_fold...
12804 Aug 2015 @ 04:56 PDTToolsReplyTPT_INFRA: TPT04106: Error: Conflicting job names have been specifiedI've found that using \" in #2 is causing issue. The correct statement in the shell should be: tbuild -f sp.txt WAQ_JOB -L "C:/TEST/New folder" However, now the error has chang...
12704 Aug 2015 @ 04:11 PDTToolsReplyTPT_INFRA: TPT04106: Error: Conflicting job names have been specifiedIt seems like some issue with tbuild when exectes from shell. Check the below two statements. #1 is executed from CMD and #2 is executed from shell. #1 didn't produce any error however #2 ended...
12604 Aug 2015 @ 01:51 PDTToolsTopicTPT_INFRA: TPT04106: Error: Conflicting job names have been specifiedHi, I am getting the below error if I specify -L parameter (log path) in tbuild command: TPT_INFRA: TPT04106: Error: Conflicting job names have been specified 'tbuild' command argument &...
12516 Jul 2015 @ 03:05 PDTToolsReplyTPT buffer and shared memory usageI meant to say that does it also uses shared memory (like it does for load) to hold the data. But anyhow that answers this question. Thanks Feinholz
12413 Jul 2015 @ 02:02 PDTToolsReplyTPT buffer and shared memory usageThanks for the info. So since TPT holds the data between the streams, does TPT also uses shared memory to store data while using EXPORT operator?
12308 Jul 2015 @ 09:30 PDTToolsReplyTPT buffer and shared memory usageHi Feinholz, Thanks for your response. So what does TPT acutally store on that shared memory and when do we actually need to tweek it? Also is there any link/effect on buffer, block size and bloc...
12208 Jul 2015 @ 03:47 PDTToolsTopicTPT buffer and shared memory usageHi, We ran a job using TPT 14.10 and found the following information in the logs: Data Block size:        1992440 Buffers/Block:       &nb...
12109 Jun 2014 @ 03:11 PDTDatabaseReplyFailed 3607: Too many expressions in the select list of a query WHERE L1.ENTITY_1 IN ( SELECT * FROM DATABASE.BUREAU T4, DATABASE.CUSTOMERS T5 WHERE T4.BUREAU_ID = T5.BUREAU_ID AND T4.VIEW_DT IN (SELECT MAX(VIEW_DT) FROM DATABASE.BUREAU) )...
12029 May 2014 @ 05:00 PDTDatabaseReplyBest practise table creation with primary key or/and index?Just some clarifications on it: PI (Unique or non-unique): Primary index is used in Teradata for data distribution. The more even the data distiribution is, the better the perfomnce will be PK (a...
11929 May 2014 @ 03:07 PDTDatabaseReplyTeradata Express 14 Database Installation GuideTeradata 14 is available pre-installed on VM for non-commerical purposes. You can download it from the Teradata download page.
11821 May 2014 @ 12:20 PDTDatabaseReplyinsert into views using fast load utilityFastload loads data in one empty table at a time having no defined secondary indexes
11710 Apr 2014 @ 04:30 PDTDatabaseReplyInsert not workingOr else you can also use Left join on your key column (A in this case) to check whether the row already exist in your target or not (assuming from above SQL that you are only checking for "new...
11604 Apr 2014 @ 06:11 PDTToolsReplyError: "specified DSN contains architecture mismatch"Okay I've resolved the issue. I am not exactly sure about the reason of the issue but what I think I didn't follow the right sequence for installing the tools. Initially I installed every t...
11504 Apr 2014 @ 03:10 PDTToolsTopicError: "specified DSN contains architecture mismatch"Hi, I have recently downloaded TD 14 Vmware on my windows 7 (64 bit) along with the all the client utilities installed as well. Now I am trying to connect Teradata using the SQLA installed on my ...
11415 Jan 2013 @ 06:05 PSTDatabaseReplyDelete or Drop a table if it already exists In order fro my code to run, I want to ensure my tables are clear before the query runs again & adds extra data Why don't you just DELETE the existing data then?
11311 Jan 2013 @ 06:12 PSTDatabaseReplyTarget row updated by multiple source rows. Note:- for COL1,COL2 combination in where clause i am getting single row Doesn't look from the error.
11211 Jan 2013 @ 06:04 PSTDatabaseReplyString Replacements in Teradata SqlJust to add one more thing to what Qaiser suggested, you can also use recursive SQL to replace more than one occurances of a string. By the way in your example, you are not replacing one particlua...
11103 Jan 2013 @ 12:11 PSTDatabaseReplyParse and validate select statementWell in SQLA you can use F6 to get the explain plan. It will only generate the plan if you query is correct syntatically.
11003 Jan 2013 @ 12:09 PSTDatabaseReplyCollect statsWhat is the issue?
10903 Jan 2013 @ 12:06 PSTDatabaseReplyAlter table add columns from variableTrying using dynamic SQL

Pages