If we have 100 records in the PF, we deleted all the records
then what is the Size of the PF?
Answers were Sorted based on User's Feedback
Answer / divyananda
The memory will be held untill you compress the PF
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / rama
If it is a physical sequential file the size of the file
becomes 0.
| Is This Answer Correct ? | 5 Yes | 2 No |
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is dbrm in db2 database?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is the FREE command?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
what is the maximum number of tables that can be joined ?
Discuss about db2 bind?
What does CURRENTDATA option in bind indicate
how we will do null data selection in cobol-db2 program
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What are column-name qualifiers used?