When would you prefer to use VARCHAR?

Answer Posted / sunil1405

when u declare a column with 10 bytes and only the field is
using 6bytes of storage , the balance 4 bytes will be
reclaimed ie its not wasted.

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find the number of rows in a db2 table?

645


Explain packages.

666


Why do we use cursor?

599


What is a db2 tablespace?

602


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1824






What does sqlcabc has?

633


How do you concatenate the firstname and lastname from emp table to give a complete name?

605


What is bind in db2?

608


How to connect to db2 database from windows command line?

564


Explain what are the various isolation levels possible?

612


What is the reason behind not using select * in embedded sql programs?

607


How to check sequence on a table in db2?

602


What is the difference between dbm cfg and db cfg file in db2 ?

1009


What is the use of with ur in db2?

621


What is the syntax for creating a table in the db2 database?

628