Test Data Manager

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

How can we invoke a process using Javelin to run a BCP command in the Command prompt .

  • 1.  How can we invoke a process using Javelin to run a BCP command in the Command prompt .

    Posted Apr 05, 2018 08:22 AM

    Hi ,  We have got a file (CARDS) with BCP command after running the Test matching JCL in Mainframe . I need to run the BCP command available in the file on the Command prompt to get the data loaded into my target Database . Can someone help me to know what action/process could invoke/used in Javelin to run BCP command from the command prompt to automatically load this data into our target SQL db . (We manually ran it command prompt and data's were loaded into the table) 

     

    Thank you in advance  Suhail Ahmed



  • 2.  Re: How can we invoke a process using Javelin to run a BCP command in the Command prompt .
    Best Answer

    Posted Apr 05, 2018 10:01 AM

    You can use Invoke Process:

    Visual Work Flow Actions - CA Test Data Manager - 4.5 - CA Technologies Documentation 

     

    ExecutableName would be the full path to bcp.exe

    Arguments would be all of the args that you need to pass into BCP.

     

    The args string can be built with VB.Net syntax:

    "-a something -b ""this needs quotes"" -c" & variable & "-d moreArgs"

     

    Hope that helps.



  • 3.  Re: How can we invoke a process using Javelin to run a BCP command in the Command prompt .

    Posted Apr 05, 2018 03:07 PM

    Thanks. It worked