1. what if null values retrived from database and no null
indicator mentioned in query. What is sql code.
Answer / santy
we will get the sql code "-305".
-305:- The NULL value cannot be assigned to output host
variable number because no indicator variable is specified.
| Is This Answer Correct ? | 8 Yes | 0 No |
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What is node in db2?
what is a collection?
What do you mean by between and in? Is between inclusive of specified range values?
What is host variable in db2 cobol?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is null value in db2?
Can we use select * statement in cobol program without giving field names ???
What are the four lockable units for DB2?
What is copy pending status in db2?
What are some SQL aggregates and other built-in functions?
When Can you be sure that a query will return only one row?