i have a db2 variable how do u declare tht into working storage section ?
Answer / guest
the db2 variable can be declared in the working-storage
section by using the DCLGEN of the particular table.
|Is This Answer Correct ?||2 Yes||1 No|
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
Why do we use cursor?
How do you retrieve the data from a nullable column?
What is ALTER ?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
How would the varchar column remarks defined?
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?
When Can you be sure that a query will return only one row?
How do I connect my db2 database to ibm?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
Explain the use of the WHERE clause?
how will you retrieve first record in table