Interested to Buy Any Domain ? << Click Here >> for more details...
1. what if null values retrived from database and no null
indicator mentioned in query. What is sql code.
- 1 Answers
- 8545 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
can all users have the privilage to use the sql statement select * (dml)?
what is the difference between join and union?
Outputs of explain are with matchcols = 0. What does this signify?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What are catalog tables in db2?
Which isolation level provides maximum concurrency?
What does db2 blu stand for?
What is image copy in db2?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
Can you use max on a char column?
What are the 4 environments which can access DB2 ?
COBOL 
