sqlca.getwithnolock

Return keyword name for "GetWithNoLock()" command for current used Database

 

This command allow 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, then use the withnolock()

This can be little slower, but don't lock tables and make the complete system more stable