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
- 19586 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
How can you write parallel routines in datastage PX?
whom do you report?
Difference between data warehousing and olap?
Describe stream connector?
What are the features of datastage flow designer?
Give an idea of system variables.
Can you define merge?
Why do we use exception activity in Datastage?
how many rows sorted in sort stage by default in server jobs
How do you remove duplicate values in datastage?
describe the Steps to confiure a Qlogic switch
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the job parameters?
