Focal Point
[SOLVED] Data flow without a source

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8157029096

November 14, 2018, 09:31 AM
Ronibi
[SOLVED] Data flow without a source
Hai

Normally we build a data flow in Datamigrator with one or multiple source tables and one target table.
We now have a situation with a very complex SQL statement to fill a target table. Is it possible to just copy the statement in the SQL object and only add a target table. So, without source tables attached to the SQL object?

regards
Ron

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS AppStudio 8.2.04
WebFocus Datamanagement Console 8.1M
DMC
November 14, 2018, 09:47 AM
FP Mod Chuck
Ronibi

Yes you can. From the datam anagement console right mouse click on the appropriate
application folder and choose new / DBMS SQL Flow.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 14, 2018, 09:56 AM
Ronibi
Chuck, you're great. Thnx a lot!

regards
Ron


WebFOCUS AppStudio 8.2.04
WebFocus Datamanagement Console 8.1M
DMC