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
Explain how a source file is populated?
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
How do y read Sequential file from job control?
what is ds administrator used for?
Is possible to create skid in dim,fact tables?
Differentiate between hash file and sequential file?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How do you reject records in a transformer?
What are iconv and oconv?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Highlight the main features of datastage?
sed,awk,head
What is the difference between orabulk and bcp stages?
What is ibm datastage flow designer?
what is 'reconsideration error' and how can i respond to this error and how to debug this