when we are trying to update db2 rows. if the program
abends . how we will know that the last successful update
row was
Answers were Sorted based on User's Feedback
Answer / jagan
In SQLCA , we have field named SQLERRD . In SQLERRD(3) , the
no of rows successful updated (or) inserted can be found .
Is This Answer Correct ? | 15 Yes | 2 No |
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.
Is This Answer Correct ? | 1 Yes | 0 No |
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..
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ramesh m
You can do the select query and in where condition, you
have to query for current timestamp for the particular row.
Is This Answer Correct ? | 1 Yes | 2 No |
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.
Is This Answer Correct ? | 1 Yes | 3 No |
What does db2 stand for?
Can a Db2 table data be retrived through JCL?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
can any one expalin check point with an example?
What is DCLGEN ?
Which command is used to connect to a database in DB2 ? Give the Syntax.
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is load utility in db2?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
Explain the EXPLAIN statement?
Is db2 a mainframe?
select 100 records from million records ?