Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of using VARCHAR?
- 3 Answers
- 15661 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
1.Additional 2 byte length indicator is stored along with
the VARCHAR column.
2.It can potentialy affect the amount of logging when the
row with VARCHAR column is updated.
3. The placement of the VARCHAR column in a DB2 table has
performance impact. DB2 has to calculate the offset of the
the column that occurs after the VARCHAR each time the
column is accessed that increases the CPU consumption.
Atleast 5-15 instructions are executed per column.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / vinod babu
Varchar data types have to handle carefully. otherwise high
chances to get -311 error during the process.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / s
When updating VARCHAR columns, the row may not fit on the
page anymore and a pointer to the new row is left in the
orginal space. Over time, there will be more relocated rows
that degrades performance.
| Is This Answer Correct ? | 6 Yes | 6 No |
What is the max length of sqlca?
Q4. How will you get the count of record without using COUNT verb in query?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
Explain the contents that are a part of dclgen.
pls explain the precompilation process of cobol-db2 pgm
Describe what a storage group(STOGROUP) is?
Define db2 and its databases?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
Can a array declared with an index be displayed(readable format) in spool?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is a collection?
What os does db2 run on?
COBOL 
