Interested to Buy Any Domain ? << Click Here >> for more details...
1) In a dataset how to delete a single row?
2) i have 50 rows , i want to display 5-7 records only?
How to write the sql query?
3)i have 40 rows,i want to display last row? write sql query?
- 7 Answers
- 19888 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ritesh chatterjee
Answer to Qust 1
Sed 1d "Dataset Name" from unix by this way you can delete
1st record from dataset,in place of 1 you can place any number.
Answer to Question 2
select * from tablename
where rowid between 2 and 7;
Answer to 3rd qus:-
select * from tablename
where rownum = 40;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
CHANGE CAPTURE
What is difference between join, merge and lookup stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
what is use of SDR function?
What all are the different way to run a job?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How can you write parallel routines in datastage PX?
What are the different type of jobs in datastage?
In Datastage, how you can fix the truncated data error?
What can we do with datastage director?
What is the difference between passive stage and active stage?
What are the benefits of datastage?
Enlist various types of routines in datastage.
How many areas for files does datastage have?
what is the use of skid in reporting?
