Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the data from a nullable column?
- 2 Answers
- 8805 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 |
what is REORG? what is the use?
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?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What are leaf pages?
What do you mean by NOT NULL? When will you use it?
What is the connection string to connect to the DB2 Database ?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
how to fetch first 100 rows in db2
How to see the structure of db2 table??
What are packages in db2?
Define sqlca.
COBOL 
