#DateForumTypeThreadPost
6516 Apr 2014 @ 08:49 PDTDatabaseReplyFallback technique in TeradataThe problem with alter is that the table gets locked and will not be available for any user even though anyone is accessing through a view. if there is no space limitation on your system, to have m...
6411 Apr 2014 @ 11:42 PDTGeneralReplyIs my table going to be Skewed?Raghuram,   In the second case where you did not define PI, the value 1 becomes the PI of the table and will be skewed on a single AMP. Also the syntax is wrong. Create table table2 as (sel...
6311 Apr 2014 @ 11:36 PDTToolsReplyIMPORT issue with Teradata SQL assistant.Blank is not considered to be null instead a character. you need to specify NULL in the CSV file for Null characters.if the datatype is defined as a numeric NOT NULL  then it will be defaulted...
6209 Apr 2014 @ 02:59 PDTDatabaseReplyRounding NumberThe one mentioned by Adarsh will work in the first case but not in the second case.sel cast(4.3505 as decimal(10,0)) gives the result as 4. Any casting you do like this with less than 0.5 will...
6109 Apr 2014 @ 01:25 PDTDatabaseReplyunable to download vmware teradata expressYadgiri, at the screeen in which you are seeing them in "deactive mode", you need to provide additional details on your personal information that are required to activate the option for t...
6008 Apr 2014 @ 09:42 PDTDatabaseReplyHelp needed in Bteq Exportwhat do you see the output for just the query in sql assistant. if it is as per your requirement then try changing all the inner char to varchar  keeping the wrapped char as char(45) and try e...
5907 Apr 2014 @ 09:22 PDTDatabaseReplyHelp needed in Bteq Export Select   cast(( CAST (BANK_NUM AS CHAR(2)) || CAST (ACCT_NUM AS CHAR(10))|| CAST(INC_TRXN_CD AS CHAR(4)) || CAST ((inc_amt*100 (Format '9(15)')) AS CHAR(15)) ||   ...
5807 Apr 2014 @ 11:36 PDTDatabaseReplyHelp needed in Bteq Export Select cast( CAST (BANK_NUM AS CHAR(2))  (title '')|| CAST (ACCT_NUM AS CHAR(10))  (title '')|| CAST(INC_TRXN_CD AS CHAR(4))   (title '')|| CAST ((...
5707 Apr 2014 @ 11:28 PDTDatabaseReplyExecution time for PI and NoPI for 30 million records is sameSkew might be the distinguishing factor. Can you check the skew factor with the PI for the 4 million and 30 million records. if the skew percentage is high then it takes more time to load a PI base...
5607 Apr 2014 @ 11:11 PDTDatabaseReplyNo More Spool Space issue encountered.This also might be happening at times due to stale stats on the tables. Please try collecting stats on the PI and the Join columns on the tables in the original query. As Adarsh mentioned splitting...
5507 Apr 2014 @ 10:57 PDTDatabaseReplyRow logging into ET tableDid the create happen with the same script. it should show a syntax error for a missing comma between code column and Desc column. As Qaisar mentioned please share the FLOAD script.
5431 Mar 2014 @ 10:03 PDTDatabaseReplyAnalyzing Teradata SQL QueriesDBQLobjtbl_hst would be a good source to avoid the issue with aliases mentioned byu Dominiq in which you can use the objectdatabasename and objecttablename irrespective of the aliases. Take the log...
5328 Mar 2014 @ 01:13 PDTGeneralReplyRun Derived table query     sel    col list         from             (     ...
5226 Mar 2014 @ 09:27 PDTDatabaseReplyPopulated zero in decimal field when given space as a value CT Sample_1(ID DECIMAL(5,2));  INS INTO Sample_1 VALUES(' ');   INS INTO Sample_1 VALUES(Null);  SEL * FROM Sample_1; Hope the above explains. if you are trying to view...
5126 Mar 2014 @ 09:16 PDTDatabaseReplySpace in the database@Sayak, at the time of table creation by default, the header is created on all amps. Though the table does not have any data, the table occupies some currentperm due to the header that was created.
5026 Mar 2014 @ 08:59 PDTToolsReplyTPT Error using DATACONNECTOR PRODUCER Operatoris the header existing in the file supplied.EMPID not being an integer might be causing the issue.
4926 Mar 2014 @ 08:56 PDTToolsReplyBTEQ Parallel Execution to speed up executing SQL statements@SriLaxmi, I do not think this will make the sql's run in parallel. instead it will increse the number of sessions connecting to Teradata and will execute each query faster. @Muthu: Are the sq...
4826 Mar 2014 @ 08:49 PDTToolsReplyRetrieve password from SQL AssistantThe password might have expired.  Please contact your DBA and he can reset your password.
4725 Mar 2014 @ 12:24 PDTToolsReplyFastload Utility Locks due to abort- .FILLER command- possible solution?The filler command is used to when you do not want to load a particular field but why do you want to use the columns and complicate the script. Theoretically speaking it might be possible but a&nbs...
4625 Mar 2014 @ 09:59 PDTDatabaseReplyhow to know the % table size growth/reduce in teradataAs such if you have the PDCR or SYS_MGMT enabled to hold the historical query log related data, you will see a table tablespace_hst which gives the associated information at a day level f...
4525 Mar 2014 @ 09:02 PDTToolsReplyTeradata TPT Error :: TPT10508: RDBMS error 3812: The positional assignment list has too few values.The view might be having an additional column which is not existing in the table. might be a calculated value. Please select specific columns from the view.
4424 Mar 2014 @ 02:07 PDTDatabaseReply*** Failure 3156 Request aborted by TDWM. Exception criteria exceeded: AMP CPU Skew, AMP I/O Skew.This might be because of the session timeout set. there is a parameter like a system throttle which will abort any sessions which are logged on to the system for more than a specified period of tim...
4324 Mar 2014 @ 09:47 PDTDatabaseReplyHow to check if a same column exists in various tablesin the second condition use b.tablename='table2' instead of a.tablename='table2'. However it might not always be tru that the column names are the same across the tables. you shoul...
4224 Mar 2014 @ 08:22 PDTToolsReply Issue while loading space delimited flat file using fastload on TPTIs the original file a tab delimited? Replace the space in the file with a comma and try. Also modify the VARCHAR textdelimiter=',' and try.
4124 Mar 2014 @ 08:19 PDTToolsReplyMload error while using Update/Insert for null PI fieldsNULL value comparision seems to be causing the issue here. To avoid this try to use coalesce.

Pages