× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I usually create a new file for the user to download from a library that
they have authority too using a query, running a CL with programmer
'owners rights' over the GEAC files, then use the STRPCCMD
PCCMD('"C:\mydocs\excel\xxxx.xls"') + PAUSE(*NO) which opens
an excel sheet with an Auto-Run macro that downloads the data from the
file created by the CL

You need the Microsoft query loaded and to have create an ODBC
connection first.



*************** Beginning of data
*************************************
0001.00 EXCELCNAME: PGM

0001.01 IWS4010: MONMSG MSGID(IWS4010) EXEC(GOTO CMDLBL(TAG3))

0002.00 STRPCO PCTA(*NO)

0002.01 TAG3: RUNQRY QRY(CURQUERY/CUSTERMS) QRYFILE((*SAME))
+
0002.02 OUTTYPE(*RUNOPT)
OUTFILE(*RUNOPT/*RUNOPT +
0002.03 *RUNOPT *RUNOPT) AUT(*RUNOPT)

0002.05 STRPCCMD PCCMD('"C:\mydocs\excel\xxxx.xls"') +

0002.06 PAUSE(*NO)

0003.00 ENDPGM

****************** End of data
****************************************


Steve Dodkins
I.T Manager

ebm-papst UK Ltd
Chelmsford Business Park,
CM2 5EZ Chelmsford,
UK
Tel: +44 (0) 1245 468555
Dir: +44 (0) 1245 456510
steve.dodkins@xxxxxxxxxxxxxxx
www.ebmpapst.co.uk/index2.htm

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of
richard_caldicott@xxxxxxxxxxxxxxx
Sent: 30 July 2007 22:29
To: System 21 Users
Subject: Re: [SYSTEM21] PC Uplift

PC Uplift is a S/21 product that allows the importing of data from a
spreadsheet into System 21. You probably mean Client Access Data
Transfer. Sounds like a SOX issue here with *ALLOBJ, but as far as I am
aware, as long as you have access to the files you are accessing there
should be no problem PC File transfer is just the same as Query. Are
you using the Excel plug-in?

Richard Caldicott
Director of Implementations
& Efficiency
Tandy Brands Accessories
817-548-0090 extn 146



beachboy3340@xxxxxxx
Sent by: system21-bounces@xxxxxxxxxxxx
07/30/2007 01:56 PM
Please respond to
System 21 Users <system21@xxxxxxxxxxxx>


To
system21@xxxxxxxxxxxx
cc

Subject
[SYSTEM21] PC Uplift






I have a client that wants to use PC Uplift to allow uses to download
System 21 data into a spreadsheet.? The problem is that to get it to
work
the use has to have *ALLOBJ authority on the AS400.? They would like to
limit the user's authority to certain files and data.?


Chuck P. Beach
Beach Consulting
AS400 Services/Specialist


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.