|
Hello Al Mac,"for example, SQL/400 commands can be in Excel cells to get latest BPCS data at the time of opening the spreadsheet. (This was topic at one of our user group meetings.)" Thanks for all your suggestions! In fact we have deployed to end-users Excel sheets with built-in VBA code in them to extract data from the AS/400 system. But the VBA code in the sheets are password protected. I didn't know that SQL/400 commands can be embedded in Excel cells. Is it native Excel feature or is it via VBA? Can you tell me how? "This OVRPRTF must be a standard addition for some version of BPCS ... how do you compile the CL program that has WRKQRY in it? Do you use the IBM PDM 14 or do you use one of the custom BPCS compilers that adds lines of code that may not be desired in this case?" We use BPCS version 6.0.04. Yes, I use IBM PDM 14 to compile the custom CL program, and do not use standard AS/SET generated CL. It puts in a lot of unwanted stuff in the CL program.
Thanks! S.R. VenuGopal, Programming Manager, Information Technology, Haynes International, Inc, Phone: (765) 456-6770 E-mail: vgopal@xxxxxxxxxxxxxx ---------------------------------------------------------------------------------------------------------------------------------------------------------------Be sure to check security for people who access BPCS from a PC since they have access much more powerful than command line, and also make sure they are able to use that power effectively ... for example, SQL/400 commands can be in Excel cells to get latest BPCS data at the time of opening the spreadsheet. (This was topic at one of our user group meetings.) This OVRPRTF must be a standard addition for some version of BPCS ... how do you compile the CL program that has WRKQRY in it? Do you use the IBM PDM 14 or do you use one of the custom BPCS compilers that adds lines of code that may not be desired in this case? We have on a BPCS menu a RUNQRY of the query definition of your choice, and access to a standard query that lists all queries alphabetically by their description, thanks to a nitely replacement of *OUTFILE directory. We also have on a menu a RUNQRY *N dump of the BPCS file of your choice for selective dumps to find specific records not showing up throudh standard inquiry, because they messed up somehow. This is because we want our users to be able to run any query definition without changing or deleting query definitions until they have had relevant training in query creation and management ... otherwise high risk someone will change some query to the detriment of other people using it. Most popularly used queries also end up on BPCS menus in their individual CL programs.
---------------------------------------------------------------------------------------------------------------------------------------------------------------
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
