Hello,
We work quite much with the SQL statements executed using dbxquery. It would be very helpful for us to have the response of the database interface. Here I mean not only the result itself (dataset returned), but also the error and status messages, like the number of rows affetced / updated / inserted, etc.
Example:
After execution of the delete statement on the database, we get the following message:
Statement 'delete from ZKPID_HHIGHMEM_STATEMENTS'
successfully executed in 6 ms 575 µs (server processing time: 1 ms 587 µs) - Rows Affected: 595
It would be very good to have it under some variable in SPL.
Is it possible?
Another example:
Let us say I have the following SQL statement: insert into tab1 (select * from tab2);
I would like to know:
- was the insert successful?
- how many rows have been inserted?
Please advice.
Kind Regards,
Kamil