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 / ravi

1 answere : we can use @rownum =1 and reject the first record....

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you reject records in a transformer?

699


project Steps,hits, Project level HArd things,Solved methods?

1688


What are the different types of lookups in datastage?

688


why do u need the IOS upgradation in a FC switch

1933


What is a datastage job?

681






Define Job control?

737


How many Key we can define in remove duplicate stage?

894


What are the important features of datastage?

674


Where do you see different stages in the designer?

704


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1537


What is oci?

927


how to delete one row in target dataset

2664


Highlight the main features of datastage?

678


Does datastage support slowly changing dimensions ?

714


Give an idea of system variables.

659