LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mw9286

Hello:

I have ten DB Execute Nodes within the same BRE that contains two fields that need to be updated each time I run the data. For example the code below will need to change next month to b.cycle_instance = 8 and B.CYCLE_CODE = 1.

Is there something that can be created where I can make a change in one node that will update all ten nodes versus me having to individually change each node?

b.cycle_instance = 7
and
B.CYCLE_CODE = 28

Thank you,

Mike

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

If I understand your question properly:

Define a graph level parameter (on the menu Graph/Edit Parameters)
Define two string parms: Cycle_Instance and Cycle_Code

then use this in your nodes:

b.cycle_instance = {{^Cycle_Instance^}}
and
B.CYCLE_CODE = {{^Cycle_Code^}}

By clicking Graph/Edit Parameters, you can change the settings before you run each cycle.