wxtyrs

PSoS: Import data within same FMS file?

Discussion created by wxtyrs on Aug 23, 2018
Latest reply on Aug 23, 2018 by philmodjunk

I am just now starting to delve into the potential power of FMS.

 

Can PSoS be used to import data from one table to another within the same FMS hosted database?

 

Is it possible if the data were instead split between two different FM files on Server?

 

I have read elsewhere that FMS cannot more data across tables in this way ("import").

 

The routine works great - sequentially - in FMPA with regular scripts.

 

I want to do the imports (data transformations) concurrently, rather than sequentially, using FMS.

 

There is no overlap across import processes - entirely different sets of tables.  Record locking should not be an issue.

 

There is no intervention by the user - it's all scripted.

 

This is a single-user app that transforms lot's of data.  FMPA cannot do concurrent transformations.

 

Thank you ...

Outcomes