What is a host variable?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a host variable?

This is a data item that is used in an SQL statement to receive a value or to supply a value. It must be preceded by colon (:) to tell DB2 that the variable is not a colunm name.

(Continued on next question...)

Other Job Interview Questions

• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What information can you find in SYSIBM.SYSLINKS table?
• When would you prefer to use VARCHAR ?
• What is a data type?
• How does DDB2 use multiple table indexes ?
• How many Buffer pools are there in DB2 and what are they ?
• What DB2 Catalog column tell you when an index needs table reorganized?
• What is the difference between TYPE 1 index and TYPE 2 index?
• What is isolation level?
• What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run ?
• More...