Interested to Buy Any Domain ? << Click Here >> for more details...
When would you prefer to use VARCHAR?
- 3 Answers
- 7511 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
The obvious benefit is savings in disk space. Thus reduced
row length means more rows per page which means lesser
getpages. Fewer getpages mean less locks hence less CPU
costs and less I/O. Use of VARCHAR reduces the number of
bytes passed between DB2 and application. There is a CPU
cost associated with each byte of data moved.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / kums
Rather than storing the object in the data base, specify
the location of the object (image) by creating a column
with VARCHAR. This kind of approach may be used in web
technologies. pl correct if I'm wrong.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the isolation levels possible ?
What is the significance of DB2 free space and what parameters control it?
what is the soft code for deadlock ?
What does db2 mean?
How to test SQL -911 error while developing COB-DB2 program
Update command
How do you retrieve the first 5 characters of firstname column of db2 table emp?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
Return code 100 means?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
What is sqlcode -922 ?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
COBOL 
