Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the data from a nullable column?
- 2 Answers
- 8915 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
DB2 application must also include a null indicator host
variable along with the host variable to contain the actual
value.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
how to resolve -811
What keyword does an SQL SELECT statement use for a string search?
What is pagespace?
What is COPY PENDING status?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is IMAGECOPY ?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What is buffer pool and list some of them?
Mention data types used in db2 ?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Discuss about db2 bind?
COBOL 
