one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
TCS,
9 11136Two source files contains same meta data third file contains different data types can I funnel that file.
2 81803) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
2 6131i would like to attend for an interview of datalab technologies company i want to know the pattern of imnterview.
2407how to find the co-efficient of variation for the following data x: 42 45 35 38 50 55 48 50 36 40 y: 15 10 18 22 25 18 17 20 18 12
3155db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above. 1 What is the maximum number of tables that can be stored on a Partitioned Table Space ? 1 what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names Accenture 5 Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code? 6 When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing? 2 how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE IBM 7 max number of columns in a db2 table? 6 What is package versioning? Please give an example. 1 What is the picture clause of the null indicator variable? 6 How do you filter out the rows retrieved from a Db2 table ? 1 What is DB2 (IBM Database 2)? 3 Can any one tell me about Restart logic in DB2.
2 5653When passing data values between different machines whith different operating system what problem have to be solved ?
Jomo Kenyatta University, MMUST Masinde Muliro University of Science and Technology, SAB, University,
1 11560i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.
CTS,
6 13006if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
TCS,
2 6298
Can we install Oracle database in VT100 Server?
Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?
How to connect to a remote database using Applet?
How database connectivity in XML is achieved?
How data can be inserted into long row column of database?
How to know howmuch data is truncated?
What are the parameters available in user exit for enhancing master data?
What are the data target administration tasks?
Where the data is extracted during init of delta and during delta updates?
How do you transform OH data?
How will you do data driven testing using Robot?
Where the datapool values are stored?
What is datapool cursor?
What is standard data type and what is user defined data type?
What information is contained in the Datapool_config section?