What is a SELECT statement?
Answer / s
SELECT is a Data Manipulation Language statement that is
used to select rows from a table.
| Is This Answer Correct ? | 2 Yes | 0 No |
What can the Locate option of the Repair Utility accomplish?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What is sqlca?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
how will you retrieve first record in table
what is plan? is plan executable or package?
Define check constraint.
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What is role in db2?
Which components manage deadlocks in db2?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
How can you display the current date & current time ?