how to unload script in HPSM using command prompt or program external to HPSM server

I want to perform 

db -> Table as “unload” -> Search “CR-PSD.unl” -> Click Proceed

to execute from Command line or program without using HPSM server.


how can I excute this step using command line or HPSM program

  • Verified Answer

    Generally, if you'd like to access SM data from other systems, you can use the web service APIs:|Web%20Services%20Guide|_____0

    Specifically to your question, you can create a script record: db -> scripts -> add like below:

    And then in the windows command line run:

     sm.exe script.execute NULL NULL test.script NULL -bg

    it will export all the records defined in UnitTest into D:\\test3.unl. 

    Hope it helps,


  • lingyanmeng thanks a lot for your sugesstion  hope it will work for me I have to try it out.

    Actually I want to unload a specific .unl file to a folder in unix with different name

    (append with date- basically this  is  for .unl backup for rollback purpose ) without using HPSM UI.

    how this can be done using any api or command line 

  • lingyanmeng

    what is "unit test" parameter under "name" 

  • The "UnitTest" is one of the predefined unload file, you can replace it with your own unload file defination:

    You can find and define new unload files at: db -> unload


  • Hi ling-yan,

    As in the provoided Script is it posssible to pass the parameter "unittest' and "D:\\test3.unl" from command line shomwhere in below syntax

    sm.exe script.execute NULL NULL test.script NULL -bg

     And I also need a Script to purge a unl file.

    this is because if iI want to rollback a loaded file then data should purge.

    Please can you provide some idea or guide path how to do this ?