GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 8 of 126    Print  
How do you change column name of a table?
What is atomicit?
What is RDBMS and ORDBMS?

  
Total Answers and Comments: 2 Last Update: December 03, 2006     Asked by: prashannaa 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 19, 2006 11:00:22   #1  
SunilDutt N        

RE: is it possible(rename) to change column name of a ...
Yes we can alter Column name in a table using the following query:alter table rename column to RegardsSunilDutt N
 
Is this answer useful? Yes | No
December 03, 2006 06:36:11   #2  
rampratap409 Member Since: September 2006   Contribution: 111    

RE: is it possible(rename) to change column name of a ...

yes you can change the column name only for oracle 9.2 and above.

RDBMS:   Relational DataBase Managment System ( for example a combination of object type into  nested table and  using this nestedtable as a datatype for a  column of table  is not supported)

ORDBMS:  Obeject Relational DataBase Managment System  (for example a combination of object type into  nested table and  using this nestedtable as a datatype for a  column of table  is  supported)


 
Is this answer useful? Yes | No

 Related Questions

We have the Datastage server7.5 installed on Unix machine. We need to have a DSN to connect to the database which is on some other unix machine.please let me know it is enough if we create a DSN at the client machine or do we have to change the config file in UNIX?It is very urgent for us and we are not able to solve?pls help me in this regard.Madhavi
Read Answers (1) | Asked by : Madhavi

Latest Answer : yes you can change the column name only for oracle 9.2 and above.RDBMS:   Relational DataBase Managment System ( for example a combination of object type into  nested table and  using this nestedtable as a datatype for a  ...
Tags : RDBMS

Latest Answer : It's very difficult to have a good usgae analysis in oracle and see exactly who is touching what and how on table and column level. However I know that there is a good tool called DB*Classify that provides this information and much more regarding the ...
Read Answers (1) | Asked by : Anonymus

Latest Answer : First sort the data on Marks  column using sort stage then use transformer stage.In constraints use system variable @INROWNUM (@INROWNUM
Read Answers (1) | Asked by : sudhakar

What is the difference between importing table definitions by Orchestrate Schema Definition or Plug-in Meta Data Definitions?

Latest Answer : It is available in 3 places1)When u open the ds Administrator ; there open any project properties;there u can see the Runtime Column Propagation.2) If u open the job properties there u can see the same option.3) When u click the column tab of input ...
Read Answers (2) | Asked by : Shankar

Error while connecting to DataStage project-expiry date '-479/1/71379' is unrecognizable Requirement: I have installed datastage7.5 server/client on windows 2003 server, the installation has been done successfully, but later when I login into the projects it is giving an error.Requirement : I have installed on the Windows 2003 server datastage7.5 server/client. the installation has been done successfully. but later when I Login into the projects it is giving an error. Error Description:
Read Answers (1) | Asked by : Prashanth Reddy

View Question | Asked by : noverino

?A byte stream file was ftp'd from an HP3000 MPE/iX server to the ETL server (windows 2000). The column values are enclosed in double quotes (") and the spaces within these are not lost Comma 
View Question | Asked by : Jackie Savinon

I would like to know whether it is possible to create an outer join when I link the data from a HF to a transformer. The situation is I retrieve data from source table and transform them by using a transformer. 
View Question | Asked by : pompui


 Sponsored Links

 
Related Articles

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

jQuery Table Row Finished Code

jQuery Table Row Finished Code The Finished Code Our second example page has demonstrated table row striping highlighting tooltips collapsing expanding and filtering Taken together the JavaScript code for this page is mosgoogle geshibot lang php" document ready function var highlighted
 

jQuery Expanding and Collapsing Table Rows

jQuery Expanding and Collapsing Table Rows The expanding and collapsing behavior added earlier also conflicts with our filters If a section is collapsed and a new filter is chosen then the matching items are displayed even if in the collapsed section Conversely if the table is filtered and a section
 

jQuery Table Row Filtering

jQuery Table Row Filtering Earlier we examined sorting and paging as techniques for helping users focus on relevant portions of a table s data We saw that both could be implemented either with server side technology or with JavaScript Filtering completes this arsenal of data arrangement strategies B
 

jQuery Collapsing and Expanding Table Rows

jQuery Collapsing and Expanding Table Rows When large sets of data are grouped in tables as each year s set of articles are in our News page collapsing or hiding a section s contents can be a convenient way to get a broad view of all of the table s data without having to scroll so much mosgoogle To
 

jQuery - Column Highlighting

Learning jQuery Column Highlighting It can be a nice user interface enhancement to visually remind the user of what has been done in the past By highlighting the column that was most recently used for sorting we can focus the user s attention on the part of the table that is most likely to be releva
 

jQuery Table Manipulation

Learning jQuery Table Manipulation By Karl Swedberg Jonathan Chaffer Better Interaction Design and Web Development with Simple JavaScript Techniques Learning jQuery packtpub com jQuery book Table Manipulation Let em wear gaudy colors Or avoid display Devo Wiggly World" In the first si
 

What is Change Data Capture

Change Data Capture refers to the process of capturing changes which are made to a production data source. Change Data Capture is typically performed by reading the source of database management software logs. Some of the features of Change Data Capture are It consolidates units of works En
 

SQL Table Commands

SQL Table Commands Overview As mentioned previously in this series of SQL articles, databases are primarily composed of tables. The “columns and rows” structure of the table allows data to be efficiently inserted, manipulated, updated, and deleted from the database. The three mos
 

Top 5 Reasons Why You Need a Career Change

For many people, a change in career takes place more than three times in their life. Reasons for this vary. There are those who make the change because the reality is that people make mistakes in choosing their career paths and would therefore like to correct that by aiming for what they really want
 

Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape