rexx/spufi clerification

Bill Brown

rexx/spufi clerification
i have seen a lot of good info reguarding my original request. let me
explain what i am attempting to do.
on occasion our users need to process production data via spufi. we require
a user sign off and an it vp signoff to do this. the sql code is generated
and sent to us. we execute it logging the it vp, user, person coding the
sql, input dataset, output dataset, total number of update type sql
statements, and total rows affected. this is all logged in an excell
spreadsheet. we also retain the output datasets from these requests. i am
trying to automate the process as much as possible.

i have written a rexx procedure that does a syntax check on the sql. works
great and the requesters use it prior to sending us the sql to insure that
it is correct. i would like to run this rexx exec myself just prior to
excecuting the sql, if it is successful i will build an output dataset name
and invoke spufi providing it with the db2 subsystem, input dataset, output
dataset, etc and then have the first spufi panel display. from there i can
hit enter and then process my spufi. we normally process these requests
with autocommit off to enable us to back out changes if any problems occur.

any assistance with this process would be greatly appreciated.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Max Scarpa

Re: rexx/spufi clerification
(in response to Bill Brown)
But is it really necessary to display panel only to hit enter ? Actually
you don't need it (per my example) to run spufi via REXX. Anyway I think
it's possible to display panel DSNESP01 and (maybe) even simple, even if I
don't see the need for it.
I did something similar using some standard IBM ISPF panels for creating
CONTROL-M 'chains' dinamically to schedule DB2 reorgs.

Max Scarpa

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jim Addison

Re: rexx/spufi clerification
(in response to Max Scarpa)
I have seen this thread a bit late, but let me know if you do not have the
info you were looking for. This is something that I have done in the past
with rexx i.e. some pre-processing, set up spufi panel variables (in
particular input/output datasets and autocommit=no) then invoke spufi.
Once the user exits spufi some post-processing takes place.

Jim.




Bill Brown
<[login to unmask email] To: [login to unmask email]
uth.net> cc: (bcc: Jim Addison/IS/SLC/StandardLifeGroup)
Sent by: bcc: Jim Addison/IS/SLC/StandardLifeGroup
DB2 Data Base Subject: rexx/spufi clerification
Discussion List
<[login to unmask email]
l.org>


19/12/2003
14:01
Please respond
to DB2 Database
Discussion list
at IDUG






i have seen a lot of good info reguarding my original request. let me
explain what i am attempting to do.
on occasion our users need to process production data via spufi. we
require
a user sign off and an it vp signoff to do this. the sql code is generated
and sent to us. we execute it logging the it vp, user, person coding the
sql, input dataset, output dataset, total number of update type sql
statements, and total rows affected. this is all logged in an excell
spreadsheet. we also retain the output datasets from these requests. i am
trying to automate the process as much as possible.

i have written a rexx procedure that does a syntax check on the sql. works
great and the requesters use it prior to sending us the sql to insure that
it is correct. i would like to run this rexx exec myself just prior to
excecuting the sql, if it is successful i will build an output dataset name
and invoke spufi providing it with the db2 subsystem, input dataset, output
dataset, etc and then have the first spufi panel display. from there i can
hit enter and then process my spufi. we normally process these requests
with autocommit off to enable us to back out changes if any problems occur.

any assistance with this process would be greatly appreciated.

---------------------------------------------------------------------------------

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm






For more information on Standard Life, visit our website
http://www.standardlife.co.uk/

The Standard Life Assurance Company, Standard Life House, 30 Lothian Road,
Edinburgh EH1 2DH, is registered in Scotland (No. SZ4) and regulated by the
Financial Services Authority. Tel: 0131 225 2552 - calls may be recorded or
monitored. This confidential e-mail is for the addressee only. If received
in error, do not retain/copy/disclose it without our consent and please
return it to us. We virus scan and monitor all e-mails but are not
responsible for any damage caused by a virus or alteration by a third party
after it is sent.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm