RE: Prevent creation of a logical over a physical

SELECT * FROM systables WHERE SYSTEM_TABLE_SCHEMA<>BASE_TABLE_SCHEMA

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Vern Hamberg [mailto:vhamberg@centerfieldtechnology.com]
Sent: Saturday, December 14, 2002 5:30 AM
To: midrange-l@midrange.com
Subject: RE: Prevent creation of a logical over a physical


And DSPDBR gives you a list of the files that are dependent on a file, so
you could run that against each file in the main library. To an outfile.

I had thought you would need to run it against logicals, if they are
SQLtype VIEW, since views can be built over views, not just tables. But it
turns out that views over views get listed under the final base physical.

BTW, views can be created over views but not over normal logical files.

Regards

Vern

At 11:20 PM 12/13/02 -0600, you wrote:
>At 18:12 12/13/2002, Walden H Leverich wrote:
>>Here's the bigger issue, the physicals we're concerned with are in a test
>>environment. The programmers need access to the environment to review test
>>data when there is a problem. However, they have a (nasty) habit of
building
>>logicals in their private library over the physical in the test library,
so
>>when we go to clear that lib to refresh from production we have to find
all
>>the cross-library logicals and delete them first. We were hoping for a
>>simple authority-fix to prevent them from creating the logical.
>
>I don't remember exactly, but I used to run a query over outfiles created
>by a combination of dspfd and dspobjd in order to get a list of files that
>had dependents in other libraries. It shouldn't be too difficult to figure
>out. I'd think a combination of that and gentle persuasion (with a big
>nasty stick) should, at least, make the problem manageable.
>
>
>Pete Hall
>pbhall@ameritech.net
>http://www.pbhall.us/

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.