How will you send data from a cobol file to DB2

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

(Continued from previous question...)

How will you send data from a cobol file to DB2 table?

USING HOST VARIABLE we can pass data from COBOL to DB2
Both the above ways can be selected.
If you want to load the table with some data you can use load utility.
If you want to move some value in the prog then you can go for the host variables.

(Continued on next question...)

Other Job Interview Questions

• How does DB2 determine what lock-size to use?
• What is EXPLAIN?
• How to increase table space in DB2?
• What is the COBOL picture clause of the following DB2 data types:
• When do you use a LIKE statement?–
• How will you send data from a cobol file to DB2 table?
• What is CHECK PENDING ?
• If I have a view which is a join of two or more tables, can this view be updateable?
• Can I use LOCK TABLE on a view?
• Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened? ––
• More...