For Null indicator we have 3 values 0,-1,-2.
0->Not nulll
-1->Null
-2->Value truncated
If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
- 1 Answers
- 5148 Views
- BNP Paribas, I also Faced
- E-Mail Answers
Answer / manikanta
No. Only these 3 values i.e 0, -1, -2 will be there in null indicator.
| Is This Answer Correct ? | 4 Yes | 2 No |
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is an access path?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What technique is used to retrieve data from more than one table in a single SQL statement?
What is node in db2?
what is REORG? what is the use?
If I have a view which is a join of two or more tables, can this view be updateable?
What is the difference between group by and order by?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
When Can you be sure that a query will return only one row?
how to copy the host variables from ps file into cobol program other than include statement
What is a view? Why use it?
COBOL 
