Like a lot of folks, our applications where built in metaphoric "silos". We have spent a good deal of time trying to make data accessible from one silo to the next. I feel that I am close to accomplishing that goal, but I am not quite there yet.

I can run a SPUFI command from my OS/390 session and access data on Windows servers (accomplished by
a) adding the appropriate entry to SYSIBM.IPNAMES,
b) adding the appropriate entry to SYSIBM.LOCATIONS,
c) binding DSNESPCS.DSNESM68 to that location
d) changing the "LOCATION" in SPUFI
e) running the select query via SPUFI

I am happy with those results, but I need to be able to automate this procedure. Running SELECT NAME FROM LOCATION.SYSIBM.SYSTABLES through the plan DSNTEP71 results in a RC=12, but no more information than that. There is no DB2-related code to research, so I am stuck.

What am I missing?

Maybe issuing the SELECT from within a COBOL program (as static SQL) works?

COBOL is not my forte, but that may be an option for my developers. I'll get back to you