If we have 100 records in the PF, we deleted all the records
then what is the Size of the PF?
- 2 Answers
- 5296 Views
- I also Faced
- E-Mail Answers
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 |
Is DECLARE TABLE in DCLGEN necessary? Why it used?
Mention and explain the contention situations caused by locks?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What is the syntax of SELECT statement when embedded in a COBOL program?
Which command is used to remove all rows from a table?
Suppose if I need to update a column, how you do that using cursor?
What is the physical storage length of date data type?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
What is the difference between oracle and db2?
what is + sign and -ve sign for sql code ?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
Is Cursor exicutable ?
COBOL 
