How can we define a table? How can we apply SEARCH ALL on it ?
- 1 Answers
- 3912 Views
- I also Faced
- E-Mail Answers
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 |
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What is copy pending and check pending in db2?
What is index cardinality?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How do we specify index to include or not during bind process.
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
What is the maximum number of columns in a db2 table?
what is diffrence b/w file-aid tool and file-aid utility???
List out the data types available.
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
COBOL 
