Tips & Tricks: Finding JDE Libraries for SQLs

If you are a business analyst, you probably already know all the libraries for your system for SQL statements for the business data. They're typically PRODDTA, CRPDTA, and TESTDTA for PD, PY, and DV, respectively.

Today I wanted to see if I could find this information without bothering my CNC. In Databrowser, I took the Visual Assist on the Data Source field below the Table:

In this new Search application, it's got another Tools -> Databrowser:

This opens a databrowser tab of the databrowser! I can now see a full list of the named Data Sources with the library 'name' for purposes of SQLing. I was on the hunt for the DV Control Table, and I found it here! It's TESTCTL!

My SQL is now complete with TESTCTL.F0004, and I didn't have to interrupt the CNC or a developer.

 

Are you a business analyst for your company? Do you have other cool tips you'd like shared here in a future Ask Denovo posting? Let us know!