DB2 9.7 Application Development v6.0 (C2090-543)

In a PHP script, which ibm_db2 functions should be used if the user wants to retrieve a row in a result set as an array, indexed by column name?

In a PHP script, which ibm_db2 functions can be used to retrieve the result set of a query executed against a database table?

Which statement(s) will create and bind the package for the program myprogram.sqc?

Click the Exhibit button.
UPDATE DBM CFG USING FEDERATED YES;
db2stop;
db2start;
CONNECT TO test;
CREATE WRAPPER oledb LIBRARY 'db2oledb';

CREATE SERVER nwind -

WRAPPER oledb -
OPTIONS (CONNECTSTRING 'Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=f:Northwind.mdb;', COLLATING_SEQUENCE 'Y');
CREATE FUNCTION nwind.customers()
RETURNS TABLE (customerid CHAR(5),
companyname VARCHAR(40),
contactname VARCHAR(30),
contacttitle VARCHAR(30),
address VARCHAR(60),
city VARCHAR(15),
region VARCHAR(15),
postalcode VARCHAR(15),
country VARCHAR(24),
phone VARCHAR(24),
fax VARCHAR(24))

LANGUAGE OLEDB -
EXTERNAL NAME 'nwind!customers';
COMMIT;
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in the exhibit was executed successfully.
Which statement can be used to verify that an OLE DB table function designed to retrieve data from the CUSTOMERS table of the NORTHWIND Microsoft Access database was created successfully?

A CLI/ODBC application uses the SQL FetchScroll() API to retrieve an updatable row set with five rows of data. Each column of the row set is bound to an array of application memory. The API is called with the SQL_FETCH_NEXT
FetchOrientation option and returns SQL_SUCCESS_WITH_INFO. Diagnostics show a truncation SQLSTATE of "01004".
Which API call correctly identifies the record with the failure?

What is the final result of executing the statements shown below?

CREATE SEQUENCE order_seq -

START WITH 100 -

INCREMENT BY 25 -

MAXVALUE 150 -
CYCLE;
VALUES NEXT VALUE FOR order_seq;
VALUES NEXT VALUE FOR order_seq;
VALUES NEXT VALUE FOR order_seq;
VALUES NEXT VALUE FOR order_seq;

Click the Exhibit button.
<personinfo>
<name>John Smith</name>
<address type="private">
<city>New York</city>
<country>US</country>
<phone>850-734-6672</phone>
</address>
<phone type="mobile">796-858-1272 </phone>
<phone type="security">646-252-1053</phone>
</personinfo>
The table PERSON is declared as shown below:
CREATE TABLE person (id BIGINT, info XML)
The document shown in the exhibit is successfully inserted into the table.
How many rows will be returned for the following statement?

SELECT t.* FROM -
xmlapp.PERSON,
XMLTABLE (
'$INFO/personinfo'

COLUMNS -
name VARCHAR(30) PATH './name',
phone VARCHAR(30) PATH './phone'
) AS t

Which return codes will be returned by SQLFetch() when there are no more records to be retrieved in a result data set?

Which three are required for a global transaction? (Choose three.)

Given the SQL statement shown below:
UPDATE employee SET lastname = CAST(? AS VARCHAR(12))
WHERE empno = ?00050??
What does CAST(? AS VARCHAR(12)) represent?

A CLI/ODBC application contains the lines of code shown below:
SQLHANDLE hstmt; /* statement handle */
SQLCHAR *stmt = (SQLCHAR *)"DELETE FROM org WHERE deptnumb = ? ";
SQLSMALLINT parameter1=5;
SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
SQLSetStmtAttr(hstmt, SQL_ATTR_DEFERRED_PREPARE,
SQL_DEFERRED_PREPARE_OFF );
If table ORG does not exist, which two CLI/ODBC APIs will return SQL_ERROR in the variable RC? (Choose two.)

When creating a trusted connection in CLI/ODBC, it is necessary to set a connection attribute.
What is the connection attribute?

A PHP Web application uses the ibm_db2 extension to establish a persistent connection to a remote database. What must be true of the connections to make full use of the db2_pconnect()
API?

While developing a CLI application, you use the code shown below:
SQLCHAR *stmt = (SQLCHAR *)"DELETE FROM org WHERE deptnumb = ? "; cliRC = SQLSetStmtAttr(hstmt, SQL_ATTR_DEFERRED_PREPARE,
SQL_DEFERRED_PREPARE_ON )
cliRC = SQLPrepare(hstmt, stmt, SQL_NTS);
Now, the ORG table does not exist in the database.
What will be the value of "cliRC" after executing the SQLPrepare command?

What are two valid values for the PARAMETER STYLE clause in the CREATE
PROCEDURE statement? (Choose two.)