Interested to Buy Any Domain ? << Click Here >> for more details...
how does the defining of a stored procedure effect the size
of a DB2 data base
A) it increases the size of a data base
B) it decreases the size of a data base
C) it does not effect the size of the data base
D) it changes the table space structures
- 2 Answers
- 10353 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / alucard
a - it increases the size of a data base.
Because a stored proc is called from a program and the
stored proc is stored along with the DB..hence the size of
the db increases.
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / guest
C. It does not effect the size of the database. The stored
procedure is not associated with any other object in the
database.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is ACQUIRE/RELEASE in BIND?
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).
how to unload different table data into different gdg files/ vsam files.
What is cloudant database?
can i code union in cobol-db2 pgm ?
What is an instance database?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What is a Resource Control Table(RCT)? Describe its characteristics.
What is the function of buffer manager?
How to get the ddl of a table in db2?
What is load replace in db2?
How to resolve -502 sql code in DB2?
COBOL 
