PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 09/08/2016 9:08 AM by  cymaano
Landmark node (create/update) vs SQL Transaction(insert command)
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
cymaano
Technical Consultant
Infor
Basic Member
(23 points)
Basic Member
Posts:13


Send Message:

--
09/08/2016 9:08 AM

    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.