I have a scenario where I am calling a business operation which populates and returns an EnsLib.SQL.Snapshot via dynamic SQL to a Business Process. I then want to iterate over this snapshot and call a RecordMap Operation to write those records to a delimited file.
Is this the correct way to do something like this? If so, does anyone have a sample which illustrates its correct usage?
When the snapshot is returned I save it into a context variable with:
set context.Snapshot=callresponse where the pOutput variable of the operation is set to EnsLib.SQL.Snapshot.