New syntax for checking single record in DB

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

OUTPUT

SAMPLE CODE- WHERE condition fully specified key but record not present

OUTPUT

SAMPLE CODE- WHERE condition partially specified key

OUTPUT

---