‎

To run SQL queries, either Green Screen command line or the IBM i Access Client solutions Run SQL Scripts function can be used -

To get to SQL in Green Screen, on a command line type STRSQL and press enter. 

XA PDM - 

SELECT * FROM AMFLIBy.WRKCTR WHERE WKCTR = 'workcentername'

Note:  'y' is the second character of the XA env designation, but is blank if the second character is M. 

workcentername is the name of the workcenter 

XA EPDM - 

SELECT * FROM AMFLIBy.FACMST WHERE WKCTR = 'workcentername'

MDCC - 

SELECT * FROM PPLBPRxy.DCWRK WHERE WWKCTR = 'workcentername'

Note: xy is the 2 character MDCC environment name