When would you prefer to use VARCHAR?
- 3 Answers
- 7958 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 |
Where can you declare a cursor in a cobol-db2 program?
What types of tables are there in the db2 database?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is a subselect? Is it different from a nested select?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
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?)
Define data page.
What is load utility in db2?
how to resolve -818 error. how to see timestamp token in load module and plan
What is a dbrm in db2?
What are the prerogatives?
List down the data types in the db2 database.
COBOL 
