Hi Woozy,
My question is similar to SQL vs Landmark nodes.
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 instead of using Landmark node (create action)?
INSERT INTO .PFIWORKUNITVARIABLE ( PFIWORKUNIT, PFIWORKUNITVARIABLE, SEQNBR, VARIABLEVALUE, VARIABLETYPE) values ( , 'Country', 0, '', 3)
Hoping for your reply