This discussion is archived
3 Replies Latest reply: Mar 5, 2013 4:42 AM by Srini VEERAVALLI RSS

pass a parameter to SAPurgeCacheByDatabase()

953265 Newbie
Currently Being Moderated
Hi Experts,

Is there any way to pass a parameter to the funtion SAPurgeCacheByDatabase() . if so how to do it?
I tried:
DEFINE var="DB";
Call SAPurgeCacheByDatabase(&var);

but it's throwing a syntax error

I have a bat file that calls PurgeCache.sql and I need to parameterise it in order to pass the DB name that I need to purge the cache for.
nqcmd -d coreapplication1 -u X -p Y -s PurgeCache.sql

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points