How can we define a table? How can we apply SEARCH ALL on it ?
Answer / rana
If u are asking about COBOL internal tables then it can be
defined with occurs clause.
SEARCH ALL is the binary search in COBOL with only one WHEN
Condition. Remember to declare the table with INDEX if you
want to apply SEARCH ALL on it.
| Is This Answer Correct ? | 7 Yes | 0 No |
What is cursor with hold option in db2?
What's The Percentage Free Space ?
Suppose if I need to update a column, how you do that using cursor?
How to resolve -805 error in DB2?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
What is a collection?
Can you Average the Characters ?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
How many buffer pools are available in db2?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
In a single table,How to retrieve a employee-id of an employee who works in more than one department?