Answer / jagan

In SQLCA , we have field named SQLERRD . In SQLERRD(3) , the
no of rows successful updated (or) inserted can be found .

Answer / vinay srivastava

We can go in Abend Aid and look for the source listing where
we can find the last values stored in Host Variables where
the Job Abended.

Answer / lenin

In cobol program, we can create one counter after each
successful update. So by checking the counter value we can
find out howmany rows are updated.

Please correct me if i am wrong..

Answer / ramesh m

You can do the select query and in where condition, you
have to query for current timestamp for the particular row.

Answer / prachi

check for sqlca.sqlerrd[2] -
as it indicates the number of rows processed before the
error occurred in a multirow INSERT, UPDATE, or DELETE
statement.

i want to delete 20th million record how ?

4 Answers   IBM,

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

What is a recovery log?

1 Answers  

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,

What is buffrpool? Where we use it ?

2 Answers   Tesco,

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

What is a DB2 bind?

1 Answers   Logica CMG,