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
- 10498 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 |
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is a system catalog table in db2?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is -904 sql code? How to resolve it?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is null value in db2?
What db2 400?
How do you stop a db2 database in linux?
What is concurrency in db2?
What is the maximum size of a char data type in db2?
what are extents?
Is schema the same as database?
COBOL 
