Give the COBOL definition of a VARCHAR field.

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

(Continued from previous question...)

Give the COBOL definition of a VARCHAR field.

A VARCHAR column REMARKS would be defined as follows:
...
10 REMARKS
49 REMARKS-LEN PIC S9(4) USAGE COMP.
49 REMARKS-TEXT PIC X(1920)

(Continued on next question...)

Other Job Interview Questions

• What is the COBOL picture clause for a DB2 column defined
• How does one remove entires from the SCT02 table?
• Where could you look if you had a question about whether a column has been defined as an index?
• What is a SELECT statement ?
• What do you mean by NOT NULL ? When will you use it ?
• How are write I/Os from the buffer pool executed
• Can you access the DB2 Directory table using SQL?
• What is SKELETON cursor table (SKCT?
• In SPUFI suppose you want to selet maximum of 1000 rows ...
• How do you define a correlated name ?
• More...