How can we define a table? How can we apply SEARCH ALL on it ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the bind parameters ibm db2?

810


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

830


What is the syntax for FETCH in DB2 ?

911


Define predicate?

861


What is the role of the data page in the db2 database?

782


Name the various locking levels available?

821


Explain the function of data manager.

810


What is the maximum No of rows per page?

814


How to view db2 table structure?

800


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1827


How does a cursor work?

753


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1969


What is the reason behind not using select * in embedded sql programs?

843


What is multi row fetch in db2?

775


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

7430