Answer Posted / biswamoy majumder
To insert a NULL, move -1 to the null indicator, To insert
a valid value, move 0 to the null indicator.
declare separately Null indictor variable in Working-
Storage section.
10 variable-NI pic s9(04) Usage comp.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between cursor and select statement?
Explain correlated sub-queries.
Why select is not preferred in embedded sql programs?
What is a buffer in memory?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Explain about cursor stability?
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 resolve deadlock issue
What is cursor in dbms?
How can you find out the # of rows updated after an update statement?
What is release/acquire in bind?
Is ibm db2 free?
What is the use of db2 optimizer?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Explain the contents that are a part of dclgen.