What if , we failed to mentioed null indicator in sql
select query , that may retrieve null value ?
Answer Posted / santy
Sorry for the above answer :(
Please see the Correct answer, we will get the SQL error -
305
-305:- The NULL value cannot be assigned to output host
variable number because no indicator variable is specified.
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Define data page.
How to resolve deadlock issue
How do I copy a table in db2?
What is database reorganization?
What is bufferpool in db2?
What is the use of db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
what are bind concepts in db2 cobol?
What is the syntax for seeing the columns and data types of a table in the db2 database?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Define declaration generator (dclgen).
What are concurrency issues?
How is deadlock resolved?
What is cursor with hold option in db2?