#DateForumTypeThreadPost
8120 Jan 2012 @ 01:36 PSTToolsReplyWhere can I find BTEQ?   You can download the document in teradata document website:   Refer below link: http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtr...
8019 Jan 2012 @ 11:25 PSTDatabaseReplyBest way to update single column in a large table. Hi,   If space is not a constraint, you can go for Insert/Select option, as explained by ulrich.   But if you have space constraint and looking for some other option, t...
7908 Oct 2009 @ 01:04 PDTDatabaseReplyteradata stored procedureHi,It is similar like you use the variable 'query' in DBC.EXEC().You can make use of concatenation operator ( '||' ) while building a dynamic query which involves in using more than one local varia...
7801 Oct 2009 @ 05:46 PDTDatabaseReplyStored procedureYou can do like this.. but by just doing 'select *' in SP you will not be able to see any return values unless you have any output variable... but you can try with other operation within SP.Add ';'...
7701 Oct 2009 @ 05:04 PDTDatabaseReplyStored procedureHi,The 'REPLACE PROCEDURE Proc_Name' command will create a new Procedure if the Proc_Name is not exist, if exist it will replace with the new procedure code with the same object name. It works simi...
7601 Oct 2009 @ 03:39 PDTDatabaseReplyStored procedureHi,It seems you are expecting to include your View DDL statement in SP.Following are the few examples of DDL statements in various Mode:1. Implicit Transaction Mode: REPLACE PROCEDURE Proc_N...
7501 Oct 2009 @ 01:50 PDTDatabaseReplyStored procedureHi,Yes it should be included anywhere between BEGIN and END..You can use view in a SP similar to any table...like...Select col1 from DB_name.view_nameYou can also assign return value of a select st...
7430 Sep 2009 @ 08:09 PDTDatabaseReplyStored procedureHi,Can you specify what exactly you are trying to do with stored procedure..?Following is the simple syntax for SP: CREATE/REPLACE PROCEDURE Database_Name.Procedure_Name(IN In_Var1 INTEGER, OUT Out...
7329 Sep 2009 @ 02:45 PDTDatabaseReplyGlobal temp OR Derived tableHi,Global temp table/Volatile table will be created in the spool space which is allocated to the logon user ID, so DB name is not required to mention for this.The data loaded in this table is valid...
7229 Sep 2009 @ 02:01 PDTDatabaseReplyLike - WildcardTo add more to Jimm reply...The ALL and ANY is quantifiers for 'LIKE' operator, these quantifiers are used to indicate how many string patterns must be found in the string expression.ANY - one or m...
7129 Sep 2009 @ 12:20 PDTDatabaseReplyDifference between select * from table & select individual columns from tableHi,AFAIK there will not be any performance difference between "select * " and "select column_lists", since the optimizer will generate same plan for both the query.Regards,Balamurugan
7029 Sep 2009 @ 12:08 PDTDatabaseReplyAnalytical functionsHi Simtaa,Refer SQL Reference: Functions and Operators PDF in www.info.teradata.com, Select 'Database' link and then select any teradata version to reach the list of teradata documents.Regards,Bala...
6928 Sep 2009 @ 02:45 PDTDatabaseReplyStrange Problem on "qualify"Hi Gary,You will be getting following error with your second query: 1. Syntax error 3706: All expression in the derived table must have an explicit name.After adding the alias name to sum() colu...
6828 Sep 2009 @ 02:18 PDTDatabaseReplyCannot Drop TablesHi,If you are getting any specific error message do share them to get appropriate reply.Do check if there are any referential constraint exist in those tables, if so first drop all those constraint...
6728 Sep 2009 @ 01:44 PDTDatabaseReplyHow to Count Multiple StatusHi,You can try below query, I have assumed 5 status in this example:Select(B.No, sum(Status1) as Status1,sum(Status2) as Status2,sum(Status3) as Status3,sum(Status4) as Status4,sum(Status5) as Stat...
6608 Sep 2009 @ 04:46 PDTDatabaseReplyDesign IssueHi,To add more on choosing PI first do the data profiling:Consider both the column as candidate columns for PI selection and identify the following stats for each of them: 1. Number of rows 2...
6515 May 2009 @ 04:53 PDTToolsReplyHow to find a primary key in teradata tables?Hi,While creating a table if we specify Primary Key then this will be created as either UPI or USI.(If we are not specified any PI, then PK will be chosen as PI ie., UPI, else USI).you can also use...
6414 May 2009 @ 05:48 PDTDatabaseReplyMLOAD / FLOADHi,In 'Teradata manager' under Monitor tab, select 'All session Information', you can see all session including your MLOAD sessions and other required information, by looking into the SQLs of each ...
6307 May 2009 @ 06:17 PDTAnalyticsReplyCalling a bteq Script from informaticaHi,Instead of calling a shell script and invoking a BTEQ, you can directly invoke a BTEQ script in a command Task immediately after the required session.Regards,Balamurugan
6207 May 2009 @ 05:26 PDTDatabaseReplydistinct rowsHi,Try filtering the records before doing the join operation, so that in Join you won't get duplicate records.If it is not possible then you have to use Group By/Distinct to avoid duplicates.Regard...
6107 May 2009 @ 05:10 PDTDatabaseReplydistinct rowsHi bharani,'Group BY' can be used after a join condition to restrict duplicate records in results sets.Select A.Col1,A.col2, B.Col3 from Table1 AInner join Table2 BOn A.Col1 = B.col1group by 1,2,3Y...
6012 Mar 2009 @ 03:30 PDTUDAReplyconvert varchar to timestampHi,Try the following query:SELECT CAST( SUBSTR('20090310181010',1,4) || '-' || SUBSTR('20090310181010',5,2) || '-' || SUBSTR('20090310181010',7,2) || ' ' || SUBSTR('20090310181010',9,2) || ':' || S...
5925 Feb 2009 @ 08:02 PSTUDAReplyTimestamp FormattingHi adash,I think we cannot format with a single command as ‘28th FEB’ from TimeStamp column.But you can use EXTRACT function to get Month and Date, try using the below query: SELECT EXTRACT(DA...
5813 Feb 2009 @ 02:57 PSTDatabaseReplyIdentity Column as Composite UPIHi,Yes Teradata will not allow to create any composite index on Identity column.To have composite index on the sequence generated column you can have the Identity column in a new table along with t...
5727 Dec 2008 @ 04:39 PSTDatabaseReplyReg Syntax error 3706Hi,We will not be able to overwrite the query, since it is automatically generated by BO.Is there any other option?Regards,Balamurugan

Pages