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
Explain the function done by data manager?
What db2 400?
How can you count the number of rows from a table tab?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How connect db2 database to datastage?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How can you classify the locks in db2?
How and when does the db2 enforces the unique key?
Explain what are the various isolation levels possible?
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 ?...
How to restart a DB2 program?
What is bind plan?
What is the use of reorg in db2?
What is db2 optimizer?
How to check table size in db2 sap?