sqlca.getwithnolock

Returns keyword name for "GetWithNoLock()" command for the currently used Database.

 

This command allows to read from tables without check locks or without creating own locks.

Only mssql. In Hana the command is not existing (return nothing)

 

Example:

select "ItemCode" from "OITM" <sqlca.withnolock> where "ItemCode" = '1111'

 

MSSQL

select "ItemCode" from "OITM" withnolock() where "ItemCode" = '1111'

 

HANA

select "ItemCode" from "OITM" where "ItemCode" = '1111'

 

Note:

If you want to use complex SQL statements, use the withnolock()

This can be slightly slower, but it does not lock tables and make the complete system more stable.