Prev
Next
Forums Lawson Landmark

Landmark node (create/update) vs SQL Transaction(insert command)

Sort:
You are not authorized to post a reply.
Author
Messages
cymaano
Basic Member
Posts: 13
Basic Member
9/8/2016 1:08 PM

    Hi,

    I am trying to convert PFI flow to IPA version.

    The current PFI is using SQL transaction node to insert work unit variables(LOGAN tables) and there are a lot of insert commands. Now, I would like to convert this to IPA version and I am sure the recommended step is to use Landmark node create action.

     

    is it possible to use SQL transaction to create PF related tables such as PFWORKUNITS,PfiWorkunitVariable instead of using Landmark node?

     

    ex. PFI version

    INSERT INTO .dbo.WFVARIABLE (
    WORKUNIT, VARIABLE_NAME, WF_SEQ_NBR,
    VARIABLE_VALUE, VARIABLE_TYPE ) values (
    , 'AccountName', 10, '', '3')

     

    Can we convert this to and use SQL transaction as well in IPA?


    INSERT INTO .PFIWORKUNITVARIABLE (
    PFIWORKUNIT, PFIWORKUNITVARIABLE, SEQNBR, 
    VARIABLEVALUE, VARIABLETYPE) values (
    , 'Country', 0, '', 3)

     

    Hoping for a quick response.

     


     

     

    You are not authorized to post a reply.