3 Replies Latest reply on Mar 5, 2013 12:42 PM by SriniVEERAVALLI

    pass a parameter to SAPurgeCacheByDatabase()

      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