#DateForumTypeThreadPost
1820 Sep 2013 @ 10:22 PDTDatabaseTopicVolatile Table In View ??Hi, I am writing a view within which i have some restriction to apply. Following is my current working query : REPLACE VIEW person_view AS LOCKING ROW FOR ACCESS SELECT distinct dat...
1716 Sep 2013 @ 05:01 PDTToolsReplySQL Assistant Preferences & DSN entries locationThanks a lot. Completely answers my query.
1616 Sep 2013 @ 02:18 PDTToolsReplySQL Assistant Preferences & DSN entries locationThanks ... This will certainly be helpful. Looking forward for help regarding the Preferences....
1516 Sep 2013 @ 01:51 PDTToolsTopicSQL Assistant Preferences & DSN entries location Hi All,   I am using SQL Assistant as my workbench for TERADATA. Recently, my system crashed and i had to setup the SQL assistant again. SQL history was available in a MS Ac...
1426 Jun 2013 @ 12:40 PDTGeneralReplyReferential Integrity for temporal tablesThough, i was getting another error. But, this might be of some help :  http://forums.teradata.com/forum/database/creating-a-soft-ri
1326 Jun 2013 @ 12:37 PDTDatabaseReplyCreating a Soft RIToo late to respond though; but Thanks for the inputs...
1208 Jun 2013 @ 07:37 PDTDatabaseReplyAlter an Existing PPIFigured out the sytax and was able to alter PPI using the following command :   alter table person_car_dtl MODIFY PRIMARY INDEX (p_num) ADD RANGE BETWEEN DATE '2014-01-01...
1108 Jun 2013 @ 04:36 PDTDatabaseTopicAlter an Existing PPIHi All,   I have the following table defined :   person_car_dtl p_num bigint p_dt date p_car_num varchar(100)   primary index (p_num)  PA...
1008 Jun 2013 @ 04:33 PDTDatabaseTopicCreating a Soft RI Hi All,   I have to implement a soft ri in one of my project.   Following are the tables in PER_DATA:   person_mst with columns p_num bigint p_dt d...
925 Feb 2013 @ 08:39 PSTDatabaseReplyDropping Primary Composite KeyThanks for the inputs everyone ..:)
822 Feb 2013 @ 05:33 PSTDatabaseReplyDropping Primary Composite KeyHi, Thanks for your inputs. However, i understand that if primary key is not a part of primary index , then the primary keys are created as unique secondary indexes. I was able to drop the prima...
721 Feb 2013 @ 10:04 PSTDatabaseTopicDropping Primary Composite KeyHi All, I have a table that has a composite key defined on 2 columns. These column are not a part of primary index. The table contains data. I am trying to drop primary key using the following ...
621 Feb 2013 @ 01:42 PSTDatabaseReplyCommand Help : Alter table modify columnHi All, Here DBA team has a different standardised approach as per them. They ask you to create new columns, copy data , drop old column , rename new columns. Its a burden on developer as to cha...
521 Feb 2013 @ 01:37 PSTToolsReplyAlter table to add column after specific columnHi Prabhakar, I am facing the same issue and reason for placing the column at same location is because of dependency on file feed layout. If we add it in the end, the load process will start fail...
420 Feb 2013 @ 04:40 PSTDatabaseReplyCommand Help : Alter table modify columnThanks for your inputs ... I am aware of this approach. However, wanted some inputs as there are 25 columns to be renamed !!! Further, i need to maintain the same order of columns as there is lo...
320 Feb 2013 @ 01:55 PSTDatabaseTopicCommand Help : Alter table modify columnHi All,   I have an existing table in TERADATA and it has a field named log_dttm defined as timestamp. I want to change the column data type to varchar(30). "alter table modify" ...
220 Feb 2013 @ 01:52 PSTDatabaseReplyTeradata Error Code 7693Thanks for the inputs. Resoved as the exception was thrown by a user defined fucntion.
113 Feb 2013 @ 06:08 PSTDatabaseTopicTeradata Error Code 7693Hi, i am calling a utility stored procedure within my application and its failing due to error code 7693. The following is what i see in SQL assistant :   "CALL Failed. 7693: ...

Pages