Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Start a flow from a different reporting server
Go
New
Search
Notify
Tools
Reply
  
Start a flow from a different reporting server
 Login/Join
 
Silver Member
posted
I am looking to execute a foreign flow on a foreign reporting server to run within that reporting server.

I have played with the CMRUN enough to find out that it actually runs the foreign flow from the reporting server that originates the CMRUN command. This leaves me without a flow log on the foreign server.

The situation is I have a DM reporting server on USS z/os (v7.11) and another one on windows (v7.6.10). We want to start creating new flows on the windows DM reporting server that trigger after the completion of flows that run currently on the z/os box.

In the past when encountered with similar issues I would have the z/os ETL update a reportcaster repository which would fire off a webfocus job. However, the DM's scheduler doesn't work in the same manner. I have even tried to remotely edit the DM_SCHDCODE variable in a flow, but the fex is slash delimited which made typical updates, modify's, or -WRITES complicated at best.

Is there any way to achieve this?


wf 767 running on w2k3 srvr
 
Posts: 46 | Registered: September 22, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Can you FTP a file from the z/os to the windows server when the z/os flows are done? If so, check out case number 31732547. Not exactly the same as your situation but I think you could apply the technique.


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
 
Posts: 126 | Registered: January 18, 2007Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks Jessica. That is an interesting alternative, but I don't know how confident I am in the sleep function. I am going to play with it for other things.

I did find a solution in running a sql server stored procedure using xp_cmdshell. That runs a .bat file which contains the cmrun. Somewhat sketchy, but least painful of the two.

Thanks


wf 767 running on w2k3 srvr
 
Posts: 46 | Registered: September 22, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Start a flow from a different reporting server

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.