• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

How to SQL JDELOCAL_PY910.DBF

ccornagg

Well Known Member
Hello JDE experts,

I would like to ask you what's the suggested approach to access fat client local database like JDELOCAL_PY910.DBF

The reason of my question is to try manual cleanup of F989999 and F989998 to force localweb specs refresh.

Thank you very much for your hints.

Kind regards,

Carlo
E1 9.1 TR 9.1.4.4
 

Stewart Schatz

Well Known Member
Hey, Carlo.

The easiest way to do this is to just use OMW to generate those 2 files to the LOCAL datasource.

If you wanted to get fancy and your local database is Oracle, then you could use Oracle's SQLDeveloper tool to do the job. I wrote an article about it here: http://e1tips.com/2013/10/30/use-oracle-sql-developer-to-modify-the-jde-local-database/

If your local database is SQL Express then you can use SQL Management Studio.

Hope that helps,

Stewart
 
Top