Re: Problems with WRKQRY command Invoked from BPCS Menu

Hi Venu,

You don't have to create a pgm etc - all you need to do is change the WRKQRY
command (CHGCMD) to 'Allow Limited Capability Users = Yes'.
BUT don't forget that there is more to securing your system than Command
Line Access now that PCs are in the equation!

cheers,

Clare

Clare Holtham
Director, Small Blue Ltd - Archiving for BPCS
Web: www.smallblue.co.uk
IBM Certified iSeries Systems Professional
Email: Clare.Holtham@xxxxxxxxxxxxxxx

----- Original Message ----- 
From: "Venu Gopal" <vgopal@xxxxxxxxxxxxxx>
To: <bpcs-l@xxxxxxxxxxxx>
Sent: Tuesday, August 16, 2005 3:19 PM
Subject: [BPCS-L] Problems with WRKQRY command Invoked from BPCS Menu


> Hello Everybody,
>
> I am trying to eliminate the need for BPCS end-users to access the
> WRKQRY command from the iSeries (AS/400) command-line. I need to have
> their AS/400 user profiles set so that 'Limit Capabilities' is set to
> '*YES'. For this I created a custom CL program that simply has WRKQRY
> command in it. I stuck this CL program in a general purpose BPCS menu
> that is available to all BPCS end users. However, when they access their
> queries through the menu option that I set up, their reports are all
> messed up. The outputs get truncated sometimes, or their run-time print
> settings (such as specific printer to print to) that they specify in the
> query itself at run-time is not honoured. I called up IBM software
> help-desk and reported the problem. Based on their suggestion, I sent
> them trace and debug logs by invoking WRKQRY both ways (i.e. via command
> line and via BPCS menu). The job log showed the following override
> command that was in the standard BPCS CL program:
>
> --------------------------------------------------------------------------
---------------------------------------------------
> OVRPRTF FILE(*PRTF) PAGESIZE(66) LPI(6) CPI(10)
>                  OVRFLW(59) OUTQ(BPCSUSR64/BPCSOUTQ) FORMTYPE('*STD')
> COPIES(01)
>                  SCHEDULE(*FILEEND) HOLD('*YES') SAVE('*NO') OUTPTY('5')
> --------------------------------------------------------------------------
---------------------------------------------------
>
> Apparently, this override was messing up the WRKQRY settings when
> invoked via BPCS menu. Hence I added the DLTOVR FILE (*PRTF) command in
> my CL program just before the WRKQRY command and then tested it.
> However, it did not seem to make a difference. Any ideas, anybody?
>
> Thanks in Advance!
>
> S.R. VenuGopal,
> Programming Manager,
> Information Technology,
> Haynes International, Inc,
> Phone: (765) 456-6770
> E-mail: vgopal@xxxxxxxxxxxxxx
> -- 
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
> Delivered-To: Clare.Holtham@xxxxxxxxxxxxxx
>