Re: BPCS-L Digest, Vol 3, Issue 227

[Venu Gopal <vgopal@xxxxxxxxxxxxxx>]

This response is for the below mentioned question ...

CAUTION:- TRY OUT ALL THESE SQL STATEMENTS IN A 'DEVELOPMENT' OR 'TEST' 
ENVIRONMENT BEFORE TRYING IN PRODUCTION.

I have done this in the past in the following manner:

1. Create a general purpose menu - XXXGPM (say) with the new program 
option and give access to all users to this menu and program. The quick, 
easy, and dirty way of doing this is 'behind-the-scenes' using SQL. You 
would need to INSERT records into the following BPCS menu/user 
management database files:

a) ZMA - CONTAINS MENU NAMES & USERS AGAINST THESE MENUS
         You would need to create unique Menu/User combo records here. 
Obtain a unique list of Menu/User and Insert this list into ZMA using 
SQL. I am hoping you or one of your colleagues is well-versed in SQL and 
can help out in this.

b) ZXO - BPCS OBJECT MASTER. (SYS MENU - OPTION # 55)  

            Example:- INSERT INTO ZXO VALUES ('AS', '06.00.04', 
'UTL21AD', 'RPG', 'O', '0', '1', 'UR1')

SSA has given BPCS customers the product code of 'UR?' (where ? can be 
any number) to define user defined products and add to BPCS object 
master table.

c) ZX2 - BPCS User/Product X-Reference

You would need to create 'unique' records for User/Product combo in ZX2 
file.

Example:-
INSERT INTO BPCSF64/ZX2                                     
   (SELECT XUUSER,'UR1','1' FROM BPCSF64/ZXU WHERE XUUSER NOT IN 
(SELECT X2USER FROM BPCSF64/ZX2 WHERE X2PROD='UR1'))        

After these SQL statements are completed successfully, you can verify 
that every user has access to the GPM menu, UR? product, and the new 
program option.

Hope this helps!

============================================================================================================================================

I asked a question similar to this before, but not for all users. I want to add 
a new program to a menu and let it be available to all users. Do I have to go 
into each users security and add them to this program or is there one place for 
all users?

Daniel

============================================================================================================================================