#DateForumTypeThreadPost
1911 Sep 2013 @ 12:42 PDTDatabaseReplyADD_MONTHS vs INTERVALHi, Interval is a data type in Teradata that represent displacement between two points in time.  ADD_MONTHS adds the months and years (Months * 12) to a specific date, while using Interval y...
1810 Sep 2013 @ 12:45 PDTDatabaseReplyImporting the large flat files failingI would say it is not a limitation of Teradata, as Teradata can handle trillions of rows.  Rather it can be a limitation of SQL Assistant, ODBC and Network resources.  When you import f...
1709 Sep 2013 @ 12:34 PDTToolsReplyhow ot use a loop in btep?In BTEQ there is a command available to repeat a stement multiple times. .REPEAT INTEGER(how many times you want to repeat) Example: .Repeat 5 SELECT Data; This will repeat this select 5 times...
1606 Sep 2013 @ 02:15 PDTDatabaseReplyNeed Analytical window query helpAssuming the ID column as Primary_key I have made the following sample query: SELECT ID, Status, CASE WHEN NEW_DATA.Status = OLD_DATA.STATUS THEN 1 ELSE 0 END ...
1506 Sep 2013 @ 01:01 PDTDatabaseReplyLeading Spaces in answer set in SQLAHi Barani, You are right the output will be in character using TO_CHAR, But upto my knowledge the to_char do not perform in implicit truncation while CAST perofrms imiplicit truncation and re...
1406 Sep 2013 @ 12:18 PDTDatabaseReplySelect Failed: 3504: Selected non_aggregate values must be part of the associated groupIn fact you are using aggregate function in you query and forgot to use group by clause for non aggregate columns. for example for the following part of your query the group by is missing: -- ...
1306 Sep 2013 @ 12:01 PDTDatabaseReplyLeading Spaces in answer set in SQLAHi,  As Integer ranges from -2147483648 to +2147483647, So it needs 10 characters for digits and1 for sign. By default when you convert an integer to characters it is right justfied inside ch...
1204 Sep 2013 @ 11:38 PDTDatabaseReplyTitile Stacking?My apologies, I just passed through a teradata documentation and came to know that Title Stacking occurs only in BTEQ. In SQL Assistant it occures only due to column width. If we expand the column ...
1104 Sep 2013 @ 09:56 PDTDatabaseReplyRANKSELECT ALTKN, DOCNUM, KUNNR FROM TABLE_NAME QUALIFY ROW_NUMBER() OVER(PARTITION BY ALTKN ORDER BY DOCNUM DESC) = 1;    
1004 Sep 2013 @ 09:53 PDTToolsReplyTPT script to move data from table to fileHi Atul, delete the checkpoint file, and rerun the job, it will be working fine. 
902 Sep 2013 @ 05:48 PDTToolsReplyTPT load source files with regular expressionHi, Appearantly this regular expression for file names should work, because the * means anything in the file name. Can you please paste the actual error you are facing. Also consult the following...
802 Sep 2013 @ 05:26 PDTDatabaseReplyVMWare Teradata 14.00 - Error while loading data into tableHi, Can you please confirm you are trying to connect from your host machine OR you are runnning this command iside VMWARE?  This error means that the TPT is unable to find the server. You ne...
731 Aug 2013 @ 03:25 PDTDatabaseReplyColumnName is missing with error messagesHi, Yes there is a method to identify the mismatch column. It might be a slow process, but always worked for me. You can use the following statment.  SELECT column1 , --column2 , --co...
631 Aug 2013 @ 03:17 PDTDatabaseReplyTitile Stacking?Hi, Dieter is very right. I would like to add that the same can be acheived using the same statement in both BTEQ & SQL Assistant as well. Khurram
510 Jun 2013 @ 12:00 PDTDatabaseReplyCreating a Soft RIHi, To create references to existing tables, a REFERENCES privilege is needed. use one of the following: GRANT REFERENCES ON person_mst TO xyz;  /* On all columns */ GRANT ...
431 May 2013 @ 02:12 PDTDatabaseReplyCHR function failsHi,   This quesry is running fine at my end both at Bteq and SQL Assistant, and I have checked it at bother versions (13.10 & 14).   Can you please paste the actual query you are ...
331 May 2013 @ 01:16 PDTDatabaseReplyReplace with carriage return/ line feedHi Nolan, Try this it will solve your problem SELECT REGEXP_REPLACE('A|b','\|','0D0A'XC); In fact to replace a special character like | you have to precede it with a back...
230 May 2013 @ 04:12 PDTDatabaseReplyTranslate loop into Teradata Stored ProcedureHi, Hope this will work for you!   REPLACE PROCEDURE Test() BEGIN DECLARE logdate DATE; DECLARE hrinput1 INTEGER; DECLARE hrinput2 INTEGER; SET logdate = '2013-03-01'; SET ...
104 Oct 2012 @ 11:12 PDTGeneralReplyInformatica/ Teradata INSERT Access WITH GRANT Issue while LoadingHi, I am facing the same issue using TPT Stream Operator, The error message is:     TPT10508: RDBMS error 5315: An owner referenced by user does not have INSERT WITH GRANT OPTION acce...

Pages