Re: PC Uplift

We use XL400 and StarQuery (from Symtrax) to create queries that users can
run as needed against any iSeries file. Our users make very good use of
these.

Jan Mazereeuw
Mountain Equipment Co-op

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Steve Dodkins
Sent: Tuesday, July 31, 2007 2:51 AM
To: System 21 Users
Subject: Re: [SYSTEM21] PC Uplift

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