Interested to Buy Any Domain ? << Click Here >> for more details...
How can the duplicate values be eliminated from db2 select?
- 0 Answers
- 1106 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What techniques are used to retrieve data from more than one table in a single SQL statement?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What is view db2?
When reorg is used?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
Mention some fields that are a part of sqlca.
Write a query to retrive partial string.
How will you delete duplicate records from a table?
Define data page.
What is Skeleton cursor table (SKCT)?
What is QUIESCE?
COBOL 
