How do you retrieve the data from a nullable column?
Answers were Sorted based on User's Feedback
Answer / s
DB2 application must also include a null indicator host
variable along with the host variable to contain the actual
value.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / amol
We have to include one variable in working storage datatype
s9(4).
and while retriveing the value from nullable column we can
give ;host variable :null indicater. If value from column
is found to be null it will stoare in null indicater.
If we have not include the null indicater and value while
fetching found to be null the program will abend with
saqlcode -305.
Is This Answer Correct ? | 3 Yes | 2 No |
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
what is consistency token
Is it possible using max on a char column?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
Explain in detail about buffer manager and its functionalities?
What is a subselect? Is it different from a nested select?
how can u understand the end of the table ?
Explain db2.
How do you define a correlated name?
Are views updatable ?
What is the difference between SYNONYM and ALIAS?
Is db2 free?