#DateForumTypeThreadPost
2509 Jun 2009 @ 03:29 PDTDatabaseTopicGetting result in order from Select query.....Hello,I have created table asCREATE TABLE TESTINDEX(EMPNO DECIMAL(18,0), EMPNAME VARCHAR(100)) UNIQUE PRIMARY INDEX (EMPNO);following records are inserted into to TESTINDEXINSERT INTO TESTINDEX VAL...
2403 Jul 2008 @ 05:13 PDTDatabaseReplyDeleting Duplicate records...Hi,you can change your table defination i.eyou have to change only the keyword "MULTISET" to "SET"this will automatically take distinct records and avoid duplication
2303 Jul 2008 @ 02:28 PDTDatabaseTopicJob schedulingHi,I need to schedule the job which will execute my tasks on specified day and time. I have done it through SQL server by creating job.Is such facility is available in Teradata.If someone konws ple...
2224 Jun 2008 @ 02:30 PDTDatabaseTopicCrystal Reports with TeradataI have a set of reports developed in Crystal Reports with SQL SERVER as Database. Now i need to port these reports on Teradata. I am facing following problems.1: I have a piece of code which sets D...
2123 Jun 2008 @ 03:30 PDTDatabaseReplyBatch execution of stored proceduresThanks it works...
2023 Jun 2008 @ 01:31 PDTDatabaseTopicBatch execution of stored proceduresHi,I need to execute the stored procedures is batch.I am having 40 stored procedures and I need to execute all these in single batch i.e all 40 gets created in one execution.If someone knows please...
1912 Jun 2008 @ 04:02 PDTDatabaseReplyGeneration of IDENTITY values for a columnHi ,Can you please tell me How to use these ROW_NUMBER and RANK in above case...
1812 Jun 2008 @ 02:12 PDTDatabaseTopicCursor FETCH_STATUSHi ,I am using cursors in TD and I need some help related to fetch_status below are the SQL Server FETCH_STATUS valuesReturn value Description 0 FETCH statement was successful. -1 FETCH statement ...
1712 Jun 2008 @ 02:04 PDTDatabaseReplyGeneration of IDENTITY values for a columnThanks,Is there any solution TD which will give me sequence no like IDENTITY field in SQL?
1612 Jun 2008 @ 01:16 PDTDatabaseReplyGeneration of IDENTITY values for a columnHi,The CREATE Statement for the table is CREATE RPT_PLANDETAILS ( rptid DECIMAL(18,0) NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 ...
1511 Jun 2008 @ 08:56 PDTDatabaseTopicGeneration of IDENTITY values for a columnHi ,I am generating identities values for a column for the following table CREATE RPT_PLANDETAILS ( rptid DECIMAL(18,0) NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 ...
1410 Jun 2008 @ 12:33 PDTDatabaseTopicCursorHi,I am migrating stored procedure of SQL Server 2005 to Teradata. This stored procedure contains cursor and the statement IF (@@FETCH_STATUS <> -2)BEGIN --Some statements END;I need t...
1303 Jun 2008 @ 01:52 PDTDatabaseTopicMacro does not work when converted into stored procedureHi, Following macro executes successfully. When the query batch from this macro is repackaged as stored procedure, I get a syntax error. Please see macro definition, stored procedure definitio...
1228 May 2008 @ 05:01 PDTDatabaseReplyCreating Stored Procedures in BatchThanks,I am using Teradata SQL Assistant 7.1
1128 May 2008 @ 04:45 PDTDatabaseReplyCreating Stored Procedures in BatchHi ,IF I am executing following three statements at a time then they get executed even if executed individually then they also get executed as like same I need to create 5 stored procedureCREATE TA...
1028 May 2008 @ 04:34 PDTDatabaseReplyCreating Stored Procedures in BatchThanks for Reply,I am using Teradata SQL Assistant for creation of the stored procedures.They get created if executing individually but i need to execute all in a batch.Thanks
928 May 2008 @ 04:25 PDTDatabaseTopicCreating Stored Procedures in BatchHi,I need to create multiple stored procedures in a single script, i meanI am having definitions of 5 stored procedures.Individually they get created but when same definitions are executed in batch...
823 May 2008 @ 12:31 PDTDatabaseTopicCursors in teradataHi,I am having a stored procedure containing cursor declaration.I have fetched employee ID's in the cursor ..I need to loop through the cursor variable..If some one knows, please let me know..........
719 May 2008 @ 01:19 PDTDatabaseTopicConcatenation in MacroI am writing a macro with a parameter and I need to concatenate this parameter as where condition for the select statement in the macro.Create macro mymacro (whereCondition varchar(100)) As(select ...
619 May 2008 @ 01:18 PDTDatabaseReplyConcatenation Of two Strings.......Thanks,I am writing a macro with a parameter and I need to concatenate this parameter as where condition for the select statement in the macro.Create macro mymacro (whereCondition varchar(100)) As(...
516 May 2008 @ 01:59 PDTDatabaseTopicConcatenation Of two Strings.......Hi,If I am executing select * from user where userid=102;This is working properly, Butif I am rewriting the above query asselect * from user ||' where '|| userid=102;this is giving me following err...
416 May 2008 @ 01:51 PDTDatabaseReplyCreating Table In Stored Procedure....Thanks a lot...
313 May 2008 @ 02:45 PDTDatabaseTopicCreating Table In Stored Procedure....Hi All,I need to create the volatile table in the stored procedure. I have written the stored procedure but it is giving following errorStored Procedure :Replace Procedure try( )Begin Create volati...
208 Apr 2008 @ 07:39 PDTDatabaseTopicStored procedure in teradataHi,I need to create stored procedure in teradata.I am using demo version 7.1I am executing following procedure Replace Procedure defdb(Out db varchar(30))Begin sel Database Into :db;End;while run...
113 Feb 2008 @ 02:15 PSTToolsTopicModifying table definitionHi AllI need to modify the table in Teradata using Teradata Administrator 7.1. I am aware that I can use "Alter table" for the same, but I need to know if there is any ways I can do the same using ...