Creating Procedures to Set All On

Because of the hierarchal structure of the output parameters of the salesforce methods, the default retrieval methods has to be changed to retrieve results for both records that were loaded successfully and those that were not.

  1. Right-click an application directory and select New, then Procedure.
  2. Enter the following lines in the editor:
    SQL SET SQLTCARTES=OFF; END
    SQL SET EMITALL=NO; END
    SQL SET SQLTOPTTF=OFF; ENDSET
    ALL=ON
  3. Click Save.

    The Save Procedure dialog box opens.

  4. Enter setallon as the name and click Save.

Note: This procedure should be added to the Process Flow tab before the data flow of any data flows created to load data into Salesforce.


WebFOCUS