1. what if null values retrived from database and no null indicator mentioned

1. what if null values retrived from database and no null
indicator mentioned in query. What is sql code.

Question Posted / mangesh

1. what if null values retrived from database and no null indicator mentioned in query. What is sq..

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

More DB2 Interview Questions

how we will do null data selection in cobol-db2 program

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

How do you concatenate the firstname and lastname from emp table to give a complete name?

Explain an outer join?

What is db2 plan table?

What is the syntax for FETCH in DB2 ?

What is the role of data manager in the db2 database?

What is db2 look?

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

can all users have the privilage to use the sql statement select * (dml)?

What is deadlock?

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

For more DB2 Interview Questions Click Here