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 / 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
What is ds designer?
What is the importance of the exception activity in datastage?
What could be a data source system?
Name the command line functions to import and export the DS jobs?
Have you have ever worked in unix environment and why it is useful in datastage?
how to sort two columns in single job in datastage.
How to perform incremental load in datastage?
What are the differences between datastage and informatica?
why do u need the IOS upgradation in a FC switch
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
what is the difference between == and eq in UNIX shell scripting?
project Steps,hits, Project level HArd things,Solved methods?
how to export or import the jobs in .ISX file
Notification Activity
What is the use of datastage director?