Unable to lock a location with my custom script

Hi All,

i am able to lock the locations by passing a "wild card" value in my query in custom script.

i need to lock only the current location, so i need to pull the location name and pass it to this script.

how can i do that, i tried many ways, but the SQL query is messing up.

please help.

strUpdate = "update tlogprocess set intlockstate='60' where partitionkey in(select partitionkey from  tpovpartition where partname like 'Sales_%')"

strBuf = strUpdate + "\n"

Params = []

fdmAPI.executeDML(strUpdate, Params, False)

rc = writeToFile(strPath, strBuf, "a")

fdmAPI.commitTransaction()

fdmAPI.closeConnection()