data source for given table

nkuebelbeck

nkuebelbeck

VIP Member
I am trying to determine which as400 library a given table resides in via an interactive program. I've search through BSFN documentation but can't find what I'm looking for.

So i've started looking through F98* tables but can't find exactly what I'm looking for.

So for instance if I were to try and return the as400 library that F4201 resides in via an interactive program, how would I go about doing this?
 
nkuebelbeck,

You will need to use the OCM (F986101) to get the data source for the table, remembering that if a specific line is not there for a table, then use the default for tables, and then get the definition of the data source from the data source master F98611.

Other tables that may be of use are:
-Object Librarian - F9860
-Table Header - F98710
-Table Columns - F98711
-Primary Index Header - F98712
-Primary Index Detail - F98713
 
F98611.DATB2 has AS400 library. But this table gives based on one world data source. You can figure out one world data source from UTB/ Databrowser and also there is a table (dont remember what it is) stores this info
 
Do you mean an interactive JDE program or on the iSeries itself?

I usually just

WRKOBJ */F986110 (or whatever table)

on the iSeries if I want to see where a table is.

Otherwise if writing something in JDE maybe you could use GetValidDataSource() BSFN?
 
I echo all the above but just to add, I usually make sure of my findings by using UTB (see what datasource comes back as you tabe out) and I also use JDEObjectBrowser from Patwel (Craig's baby)
That too pops the datasource in by default from your OCMs

Your OCMs maybe different to the enterprise servers though
 
Awesome. Between the business function and F98611 I was able to get the information I needed.

Thanks everyone
 
Back
Top