data source for given table

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?
 

peterbruce

Legendary Poster
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
 

Gov

Guest
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
 

jolly

Reputable Poster
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?
 
Discover how to build no-code data integrations and business process automations.

johndanter

Legendary Poster
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
 
Top