Fetch on F986110 Table in Server

Hi,

I am Running the Report in Server and In the Report I am doing fetch on F986110 table. It will automatically take the server data source or we need to Override the datasource?
Thanks in Advance.

Hi,
you need to override the datasourse.

Thanks JDEAdmin..

But the Business function to Overide the Datasource B9861101 is client only. Do we need to create copy of this BSFN(Client/Server) to run on server?

Thanks

Don't use a BSFN - use a table handle.

B9861101 works fine on web too, you don't need to copy and define as client / server.

Only client BSFN don't always mean that they run only on client workstation, the web is a client too, so it realy mean that they can run only on a client (fatclient or web client too).

If you look at P986116 app (work with server) you can verify that this appuse the same bsfn you need.

You can use handel too, as Larry suggest; this can be done if you need to fetch the table (as you need). DS Override is more useful if you need to have a business view on the tabel in a report section or grid app; but it works on table IO too.

Regards

Bruno Condemi

I know this is an old post but hopefully someone has used this in the past...

If I use a table handle for F986110 and choose SL LoginEnvironment when I open the handle, will it use the correct data source? Or is there something special that I need to do to point it to the correct data source?

Thanks!
Shannon

Shannon,

technically that should work if you have a override OCM mapping in the user's environment(s) for F986110 (both System and Server maps). In your case F986110 should be mapped to Data Source "System - 900".

So ... if your OCMs are in place it should work without a Table Handle or anything special ... Anyone want to chime in on this?

Hi Shannon

I wrote a UBE (UBE:R550002 ) to read over F9861110 to email out PDFs and I use nothing to get it to read correctly. Possibly as it's run on the server

All my OCMs for that table point to System 900 under *PUBLIC
When searching on that table in databrowser for example, it finds nothing as I have to change the datasource to the actual SERVER name (as shown below in my example ER)

However.....When I was testing this locally I coded this into a test harness UBE:

So one UBE which was ran locally ER below, called my main UBE

00001 -SetF986110DS(B9861101.SetF986110DS)
"GTSAX-JDED1 - 900 Server Map" -> szDatabasepath [DATP]
00002 //
00003 Call UBE:R550002 Version:GTS0001 < main UBE
00004 //
00005 -SetF986110DS(B9861101.SetF986110DS)
<Blank> -> szDatabasepath [DATP]



GTSAX-JDED1 - 900 Server Map is my NO PROD server datasource. I only needed this when running locally. On the web it was fine

Only thing I added to my main UBE was this for the environment

If SL LoginEnvironment is equal to "DV900"
00061 | VA evt_EnvironmentENV [ENV] = "JPY900"
00062 -Else
00063 | VA evt_EnvironmentENV [ENV] = SL LoginEnvironment
00064 End If


Set User Selection(BC Environment Name (F986110)(ENHV), <Equal To>, VA evt_EnvironmentENV, <And>)