Creating a Flow to Check Job Status
  1. Right-click an application directory and select New, then Flow.
  2. Right-click the SQL object and select Add, then Join.
  3. Right-click the Join object and select Add, then Source.

    The Select synonym panel opens.

  4. Select checkjob and click Select.
  5. Right-click on Join object and select Add, then Source.

    The Select synonym panel opens.

    Select the target synonym for the flow you created to load data, such as jobbatch, and click Select.

  6. Double-click the Join object to open it. Under Left Source, right-click Name and select Field View. Scroll down and select the JOBID field. Under Right Source, select the JOBID field. Click the button. The Join Editor should look like the following image.

    Click OK.

  7. Double-click the SQL object to open it.

    The Column Selection window opens.

    Select all seven fields in the segment BATCHINFO.

  8. Click OK to close the window.
  9. Right-click the workspace to the right of the SQL object and select Add Target, then New. The data flow should look like the following image.

  10. Right-click the target object and select Properties.

    The target properties window opens.

  11. Select an available adapter, such as Delimited Flat file. Enter an application directory and synonym name, such as salesforce/jobresp.
  12. Enter a location for the table or file, such as salesforce/jobresp.ftm. Enter a comma (,) for the field delimiter and select Yes for the Header.
  13. Click the Save button to save the flow.

    The Save Procedure as window opens.

    Enter a name for the flow, such as check_job_request. Click Save.


WebFOCUS