We have to include one variable in working storage datatype s9(4). and

How do you retrieve the data from a nullable column?

Question Posted / amol

2 Answers
8693 Views
I also Faced
E-Mail Answers

Answer Posted / amol

We have to include one variable in working storage datatype
s9(4).

and while retriveing the value from nullable column we can
give ;host variable :null indicater. If value from column
is found to be null it will stoare in null indicater.

If we have not include the null indicater and value while
fetching found to be null the program will abend with
saqlcode -305.

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which isolation level provides maximum concurrency?

1101

How to take backup of table in db2?

1029

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11630

What is multi row fetch in db2?

998

Explain db2.

998

What is explain plan in db2?

947

What is a db2 collection?

995

Mention the definition of cobol in varchar field.

1196

What is check constraint. Explain with example.

1051

What is host variable?

1024

Is db2 relational database?

927

How to find the number of rows in a db2 table?

1077

What is the function of logging in the db2 database?

1079

Is db2 a mainframe?

986

what is a corelated subquerry?

1075