What if , we failed to mentioed null indicator in sql
select query , that may retrieve null value ?
Answers were Sorted based on User's Feedback
Answer / 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 |
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is package in db2 mainframe?
When is the authorization check on DB2 objects done - at BIND time or run time?
what is difference between Plan and Package
What is db2 bind?
What is the maximum size of a char data type in db2?
wt is view ? wht r the restrictions for view ?
What is a storage group (stogroup)?
Is the primary key a clustered index?
How to select the duplicate rows from a table?
Differentiate between cs and rr isolation levels? Where do you specify them?
select distinct(empid),distinct(dept),name from EMP will the above query work?