Checking single record is present in DB without data transfer from DB to application layer.
SPFLI table content.
Initially there was no way of checking if a record is present in DB or not but instead we use SELECT SINGLE * or up to 1 rows in SQL query. This statement transfers a single record or a single column value from DB to the application server memory. Now we have a new SQL syntax that checks if a record is present in the DB or not without data transfer.
SAMPLE CODE- WHERE condition fully specified key
SAMPLE CODE- WHERE condition fully specified key but record not present
SAMPLE CODE- WHERE condition partially specified key