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
- 10558 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Where do you specify them?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is a db2 tablespace?
What is the difference between cursor and select statement?
What are iseries servers?
What is the clustering index in the db2 database?
What is dpf in db2?
What does db2 stand for?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is runstats and reorg in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is check constraint in db2?
How to run db2 command in windows?
What is lock escalation in db2?
How do you stop a db2 database in linux?
