Delete query in Embedded SQL
I have a delete query in embedded SQL. How can I know how many records are deleted?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 30, 2012 5:18 AM
UPDATED:
June 13, 2012 2:23 PM
Approved Answer - Chosen by RamvishakRamesh (Question Asker)
C Name
COBOL Name ILE RPG Name
PL/I Name RPG/400 Name Field Value
SQLERRD(3) SQLERRD(3) For a CONNECT for status statement, SQLERRD(3) contains
sqlerrd[2] SQLER3 information about the connection status. See “CONNECT (Type 2)”
on page 647 for more information.
For INSERT, UPDATE, REFRESH, and DELETE, shows the number
of rows affected.
For a FETCH statement, SQLERRD(3) contains the number of rows
fetched.
For the PREPARE statement, contains the estimated number of rows
selected. If the number of rows is greater than 2 147 483 647, then 2
147 483 647 is returned.
Other Answers:
Use c+ GET DIAGNOSTICS :delrowcnt = ROW_COUNT after delete statement that should give number of deleted records
To see other answers submitted to the Answer Wiki: View Answer History.
The field SQLER3 will contain the number of rows affected. This field is part of the SQLDA data structure populated for each SQL statement executed. In RPG(LE) programs, this data structure is automatically available to you.
This field is part of the SQLDA data structure…
Minor typo? But the student/interviewee can track down the appropriate data structure from the information given.
Tom
SQLERRD(3) is a part of SQLCA