Why would you receive a command response of NORMAL when the attachment facility is not available?

Before executing SQL statements, you want to know whether the CICS attachment facility is available. How do you check?

What are two examples of steps that must be taken before coding an application with embedded static or dynamic SQL statements?

How many indexes will be created by the following statement? Create table Smarterer { Col1 int not null primary key, Col2 char (64), Col3 char (32), Col4 int not null, Constraint c4 unique (Col4,Col1) }

What's the output of a DB2 Bind

What must a SELECT statement be coded within?

What is a thread?

When will you use curser with hold option?

What is the statistics collected during RUNSTATS?

Under which circumstance would you create an index on a table?

How can you quickly find out the number of rows updated after an update statement?