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?
Answer Posted / segu satish
answer for 3rd question:
select * from emp where rowid =(select max(rowid) from emp)
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Where the datastage stored his repository?
Is the value of staging variable stored temporarily or permanently?
what is the use of skid in reporting?
How to read multiple files using a single datastage job if files have the same metadata?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How many types of stage?
What is datastage?
Can you filter data in hashed file?
How and where you used hash file?
What are datastage sequences?
How do you import and export data into datastage?
How can you write parallel routines in datastage PX?
How a server job can be converted to a parallel job?
Explain the datastage parallel extender (px) or enterprise edition (ee)?