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

Parents
  • Verified Answer

    Generally, if you'd like to access SM data from other systems, you can use the web service APIs:

    https://s3.amazonaws.com/smhelpcenter/smhelp941/codeless/index.html#webservicesguide/concepts/purpose.htm?TocPath=Guides%20and%20reference|Web%20Services%20Guide|_____0

    Specifically to your question, you can create a script record: db -> scripts -> add like below:
    2016-09-18_14-23-10.jpg2016-09-18_14-21-04.jpg2016-09-18_14-21-04.jpg

    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,

    Ling-Yan

  • 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

    Ling-Yan

  • 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 ?

Reply
  • 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 ?

Children
No Data