What does it mean if the null indicator has -1, 0, -2?
Answer / islam
-1 indicates that the field contain a NULL value
0 indicates that the field contain valid value
-2 indicates that the field the field contain junk value
due to data conversion error
| Is This Answer Correct ? | 19 Yes | 3 No |
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is a data page?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Mention the different locking levels that are available in db2.
i want to maintain uniqueness on pdf without make lf??????????
what is differnece between DROP TABLE & DELETE TABLE .
what is a corelated subquerry?
What will the DB2 optimizer do?
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).
How to find last record before record through SQLRPGLE?
What are packages in db2?
How to connect to db2 database from windows command line?