SQLCHECK Rexx

Bill Brown

SQLCHECK Rexx
I have posted a new Rexx procedure on DB2-L-DOCUENTS. The procedure will
sequentially process a sequential dataset or pds member, segregate
individual SQL statements by looking for the termination character, and then
prepare the statement. The SQLCODE is then processed and the appropriate
message displayed. The output is placed in a temporary spf dataset and you
are put into browse mode. The procedure will handle --#SET TERMINATOR
statements and there is even commit processing in the procedure. Don't know
why I put this in there other than to learn how to handle commits using the
Rexx time interval. I have even used the proc to check out DDL using the
logic that if you receive a -204 telling you that the object does not exist
there are no syntax errors. Hope it is useful.



Vern LaMar

Re: SQLCHECK Rexx
(in response to Bill Brown)
I thought your SQLCHECK Rexx would be usefull so I copied in my libraries.
I have a problem whith the BROWSE. I get a message that the dataset is not
cataloged. Any thoughts?

Vern LaMar
NSRI (USA), Inc.



Peter Nancollis

Re: SQLCHECK Rexx
(in response to Vern LaMar)
What ho!
Try replacing
ADDRESS ISPEXEC "BROWSE DATASET('&ZTEMPF') PANEL(ISREFR01)"
with
Address ISPEXEC
"LMINIT DATAID(MYDID) DDNAME(&ZTEMPN)"
"BROWSE DATAID(&MYDID) PANEL(ISREFR01)"

Sorry if this has been answered, digest = delay !


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

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
----------------------------------------------------------------------------------------



Paul Fazio

REXX
(in response to Peter Nancollis)
One of our applications people has requested that we install the REXX
software. My questions to the group are:
Do you have this on your system?
Who can use it?
What do they use it for?
Can they use something else?


Thanks,
Paul

---------------------------------------------------------------------------------
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

Tina Hilton

Re: REXX
(in response to Paul Fazio)
I assume you mean install the DB2 feature DSNREXX. Rexx itself is part of
TSO. DSNREXX is an interface for rexx code to connect to DB2. Rexx is an
interpretive language, like clist but much better in my opinion. All SQL
using DSNREXX is dynamic. It's a very handy way to write some quick code,
but doesn't perform well enough to replace Cobol programs. I'm a systems
DBA and write a lot of rexx utilities to help me manage DB2. I've also
written a small ISPF application (only used by tech support) using rexx to
maintain our software inventory. Some of the things I've written in rexx
could be done in Cobol, but I'm not as fluent in that any more so rexx is
both quicker for me to write as well as to debug (no compiling, binding,
etc.).

Basically, rexx is just another application language. I wouldn't hesitate
to install it. If your application programmers have any sense at all,
they'll quickly figure out it's for quick-and-dirty stuff and they won't use
it a lot for production.

Tina Hilton

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]

Sent: Friday, December 05, 2003 9:27 AM
To: [login to unmask email]
Subject: REXX



One of our applications people has requested that we install the REXX
software. My questions to the group are:
Do you have this on your system?
Who can use it?
What do they use it for?
Can they use something else?


Thanks,
Paul

----------------------------------------------------------------------------
----- 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


---------------------------------------------------------------------------------
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

Avram Friedman

Re: REXX
(in response to Tina Hilton)
REXX is a programming language.
In MVS and its newer variants it is often used as the TSO command
language although older CLIST processing is still supported.
REXX is not distributed with DB2, I am not sure of the packaging details
but it is almost always present so as part of a pretty basic operating
system component.
To allow REXX EXECs to access DB2 there is a DB2 instalation job that
needs to be run SDSNSAMP(DSNTIJRX) I think.
We use REXX scripts in DB2 for generating backups recoveries reorgs
repairs, manageing stored procedures, migrations, multiple DB2s per
LPAR, etc etc.
Most shops that write there own system support routines (DB2 or other
product) do it in REXX or CLIST.
Avram Friedman

[login to unmask email] wrote:

>
>
> One of our applications people has requested that we install the REXX
> software. My questions to the group are:
> Do you have this on your system?
> Who can use it?
> What do they use it for?
> Can they use something else?
>
> Thanks,
> Paul
>
> --------------------------------------------------------------------------------
> 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

--
NOTICE: If received in error, please destroy and notify sender. Sender
does not waive confidentiality or privilege, and use is prohibited.


---------------------------------------------------------------------------------
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

Paul Pennock

Re: REXX
(in response to Avram Friedman)
Paul,

I use REXX quite a lot on udb LUW mainly because I'm familiar with
it's use (from mainframe days). It can be very useful for writing
complex scripts to perform utility type operations
(load,import,export,runstats,reorgs) you can also use it to perform
table updates, deletes, inserts etc.

One of the major problems is, as newer releases of udb appear on all
platforms it becomes more out of date because IBM in their wisdom
decided to to consolidate at version 5.2 - which means the newer newer
API's are not available to REXX. This was a real shame (my opinion)
because there are a lot of mainframe guys out there who are extremely
good with REXX and it allowed thenm to get up and running on the
windows platform quite quickly. If this is the case with your
colleague then give him rexx ( I use reginald, others like Regina).
But they will need to look at using somthing like java script in the
future or perl - there are many others available.

-----Original Message-----
From: [login to unmask email]
[mailto:[login to unmask email]
Sent: Friday, December 05, 2003 2:27 PM
To: [login to unmask email]
Subject: REXX



One of our applications people has requested that we install the REXX
software. My questions to the group are:
Do you have this on your system?
Who can use it?
What do they use it for?
Can they use something else?


Thanks,
Paul

----------------------------------------------------------------------
----------- 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


################################################################

This e-mail may contain confidential information and/or copyright material. This e-mail is intended for the use of the addressee only. Any unauthorised use may be unlawful.

If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software.

Friends Provident Marketing Group consists of the following
incorporated companies which are limited by shares:

Friends Provident Life and Pensions Limited.
Registered number 4096141
Friends Provident Pensions Limited.
Registered number 475201

FP Life Assurance Limited.
Registered number 782698
Registered in England.

Registered and Head Office:
Pixham End, Dorking, Surrey RH4 1QA.


Companies within this Group transact life assurance, pension, income protection and investment business.

All are authorised and regulated by the Financial Services Authority.

Ultimate holding company: Friends Provident plc.
Registered and Head Office: Pixham End, Dorking, Surrey, RH4 1QA. Incorporated company limited by shares and registered in England number 4113107.

The Marketing Group also includes certain ISIS Asset Management plc subsidiary companies.

################################################################

---------------------------------------------------------------------------------
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

Roger Miller

Re: REXX
(in response to Paul Pennock)
There were two good presentations on REXX with DB2 at IDUG North America
this year - one by Rich Fazio of TransUnion and another by Lori Ann
Galluzzo of EDS. See if you have a friend who got to IDUG this year.

Roger Miller

On Fri, 5 Dec 2003 09:26:31 -0500, [login to unmask email] wrote:

>One of our applications people has requested that we install the REXX
>software. My questions to the group are:
> Do you have this on your system?
>Who can use it?
>What do they use it for?
>Can they use something else?

>
>Thanks,
>Paul

---------------------------------------------------------------------------------
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

Steve Grimes

Re: REXX
(in response to Roger Miller)
Hello,

I use Rexx for a number of things, including quick testing of Stored
Procedures. It's an easy way to vary the parameters and display the
results to the screen. I also use it look up the error message for SQL
codes. (I probably got that program from someone on this list.) But
mostly I use Rexx to extend the capabilities of TSO/ISPF in the form of
macros that can issue DB2 commands, display Buffer Pool information, etc.

Stg

---------------------------------------------------------------------------------
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

Edward Long

Re: REXX
(in response to Steve Grimes)
We use REXX extensively.
Our experience with its performance is that for
non-DB2 stuff performance is no better or worse than
equivalent programs.

For DB2, Dynamic SQL caching has eliminated much of
the penalty Tina alludes to.

Its wicked quick to develop in, which of course, is
both the good news and the bad.

As another respondent alluded to, its fabulous for
testing SP's.

The install of the DB2 interface is plenty painless.

--- [login to unmask email] wrote:
> I assume you mean install the DB2 feature DSNREXX.
> Rexx itself is part of
> TSO. DSNREXX is an interface for rexx code to
> connect to DB2. Rexx is an
> interpretive language, like clist but much better in
> my opinion. All SQL
> using DSNREXX is dynamic. It's a very handy way to
> write some quick code,
> but doesn't perform well enough to replace Cobol
> programs. I'm a systems
> DBA and write a lot of rexx utilities to help me
> manage DB2. I've also
> written a small ISPF application (only used by tech
> support) using rexx to
> maintain our software inventory. Some of the things
> I've written in rexx
> could be done in Cobol, but I'm not as fluent in
> that any more so rexx is
> both quicker for me to write as well as to debug (no
> compiling, binding,
> etc.).
>
> Basically, rexx is just another application
> language. I wouldn't hesitate
> to install it. If your application programmers have
> any sense at all,
> they'll quickly figure out it's for quick-and-dirty
> stuff and they won't use
> it a lot for production.
>
> Tina Hilton
>
> -----Original Message-----
> From: [login to unmask email]
> [mailto:[login to unmask email]
>
> Sent: Friday, December 05, 2003 9:27 AM
> To: [login to unmask email]
> Subject: REXX
>
>
>
> One of our applications people has requested that we
> install the REXX
> software. My questions to the group are:
> Do you have this on your system?
> Who can use it?
> What do they use it for?
> Can they use something else?
>
>
> Thanks,
> Paul
>
>
----------------------------------------------------------------------------
> ----- 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
>
>
>
---------------------------------------------------------------------------------
> 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
>


=====
Edward Long

---------------------------------------------------------------------------------
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

Tim Curley

Re: REXX
(in response to Edward Long)
Since this is a db2 forum I assume that you are talking about DSNREXX.

>>Do you have this on your system?

DSNREXX is shipped with DB2, however, it is an optional installation step.

>>Who can use it?
Once installed it is just another way of accessing db2.
Security can be controlled at the DB2 table level, dsnrexx plan level,
or via racf.....if you choose.

>What do they use it for?
They can use it for quick dynamic sql programs to be used in a tso/ispf
envirnoment.

>Can they use something else?
Other options would include cobol, PLI, assembler, or C.
When you code ispf panels, or interactive tso/ispf programs that
go against DB2, REXX is the best solution.



>From: [login to unmask email]
>Reply-To: DB2 Database Discussion list at IDUG <[login to unmask email]>
>To: [login to unmask email]
>Subject: REXX
>Date: Fri, 5 Dec 2003 09:26:31 -0500
>
>One of our applications people has requested that we install the REXX
>software. My questions to the group are:
> Do you have this on your system?
>Who can use it?
>What do they use it for?
>Can they use something else?
>
>
>Thanks,
>Paul
>
>---------------------------------------------------------------------------------
>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

_________________________________________________________________
Take advantage of our best MSN Dial-up offer of the year — six months
@$9.95/month. Sign up now! http://join.msn.com/?page=dept/dialup

---------------------------------------------------------------------------------
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

Richard Humphris

Re: REXX
(in response to Tim Curley)
Hi Paul,

Just an fyi

Although DSNREXX is free, it is truly an "optional feature" of DB2.
When ordering your next version of DB2 make sure you also "order" this
feature as well (so that it comes with your installation tapes).

I assume you can order DSNREXX for Vx after the fact (as long as you
can still order DB2 Vx itself). Thus, you can currently get DSNREXX for
V7; but you won't be able to order DSNREXX for V5. And DSNREXX for V7
won't run on V5 (nor V6 for that matter). However I have run DSNXREXX
for V6 on V7 (but without the v7 enhancements of course) until all my
DB2 sub-systems were at V7... at which point I upgraded to DSNREXX V7
everywhere.

Rich Humphris

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of [login to unmask email]
Sent: Friday, December 05, 2003 8:27 AM
To: [login to unmask email]
Subject: REXX



One of our applications people has requested that we install the
REXX software. My questions to the group are:
Do you have this on your system?
Who can use it?
What do they use it for?
Can they use something else?


Thanks,
Paul


------------------------------------------------------------------------
--------- 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


---------------------------------------------------------------------------------
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
(in response to Richard Humphris)
Paul

>Do you have this on your system?

Yes I installed V6 DSNREXX when I migrated from V5 to V6 but I use it very
little. For admin purpose (ie for small programs) it easy to use, but I
prefer to use something else like DB2WWWX for DBA's or DB2 sysprog
activity. I used DSNREXX for testing DTTs, triggers & identity columns with
small programs.

>Who can use it?

DBAs, Sysprogs and some programmers.

>What do they use it for?

Very small programs doing simply activities or for testing.

>Can they use something else?

If you have QMF you can use QMF DSQCIX interface or as I said before
DB2WWWX, which is good for REXX (it gaves rows in STEM variables for
instance). Someone doesn't like it because you can use it to select 'only'
about 32000 rows, but DB2WWWX was not written to do big queries and I never
suggested to use it for this purpose. But for admin purposes (building
reorg JCLs after catalog queries for example)it is goood. We use it
extensively and AFAIK many people use it as well.

HTH

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

Tina Hilton

Re: REXX
(in response to Max Scarpa)
Max,

Where can I find DB2WWWX? Or is it something you have to pay for?

Tina

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Tuesday, December 09, 2003 3:47 AM
To: [login to unmask email]
Subject: Re: REXX


Paul

>Do you have this on your system?

Yes I installed V6 DSNREXX when I migrated from V5 to V6 but I use it very
little. For admin purpose (ie for small programs) it easy to use, but I
prefer to use something else like DB2WWWX for DBA's or DB2 sysprog activity.
I used DSNREXX for testing DTTs, triggers & identity columns with small
programs.

>Who can use it?

DBAs, Sysprogs and some programmers.

>What do they use it for?

Very small programs doing simply activities or for testing.

>Can they use something else?

If you have QMF you can use QMF DSQCIX interface or as I said before
DB2WWWX, which is good for REXX (it gaves rows in STEM variables for
instance). Someone doesn't like it because you can use it to select 'only'
about 32000 rows, but DB2WWWX was not written to do big queries and I never
suggested to use it for this purpose. But for admin purposes (building reorg
JCLs after catalog queries for example)it is goood. We use it extensively
and AFAIK many people use it as well.

HTH

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

---------------------------------------------------------------------------------
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

Lisa Bates

Re: REXX
(in response to Tina Hilton)
Tina,
The USS Tools and Toys page
http://www-1.ibm.com/servers/eserver/zseries/zos/unix/bpxa1ty2.html

It is so powerful and useful I never learned how to use DSNREXX.
Look for the link db2imsrx .
The downside is it can only execute single SQL statements. Running blocks of
SQL in a UOW is not supported. I have not had success it getting it to
call Stored Procedures.

Lisa


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of [login to unmask email]
Sent: Tuesday, December 09, 2003 8:09 AM
To: [login to unmask email]
Subject: Re: REXX


Max,

Where can I find DB2WWWX? Or is it something you have to pay for?

Tina

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Tuesday, December 09, 2003 3:47 AM
To: [login to unmask email]
Subject: Re: REXX


Paul

>Do you have this on your system?

Yes I installed V6 DSNREXX when I migrated from V5 to V6 but I use it very
little. For admin purpose (ie for small programs) it easy to use, but I
prefer to use something else like DB2WWWX for DBA's or DB2 sysprog activity.
I used DSNREXX for testing DTTs, triggers & identity columns with small
programs.

>Who can use it?

DBAs, Sysprogs and some programmers.

>What do they use it for?

Very small programs doing simply activities or for testing.

>Can they use something else?

If you have QMF you can use QMF DSQCIX interface or as I said before
DB2WWWX, which is good for REXX (it gaves rows in STEM variables for
instance). Someone doesn't like it because you can use it to select 'only'
about 32000 rows, but DB2WWWX was not written to do big queries and I never
suggested to use it for this purpose. But for admin purposes (building reorg
JCLs after catalog queries for example)it is goood. We use it extensively
and AFAIK many people use it as well.

HTH

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

---------------------------------------------------------------------------------
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

---------------------------------------------------------------------------------
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

cliff boley

Re: REXX
(in response to Lisa Bates)
Since REXX is free most everyone has it and you find a lot of usefully
programs (also free) that other DB2 folks have written.
This list has a good selection of REXX programs.
cliff:-)

-----Original Message-----
From: Humphris,Richard P. [mailto:[login to unmask email]
Sent: Monday, December 08, 2003 12:35 PM
To: [login to unmask email]
Subject: Re: REXX


Hi Paul,

Just an fyi

Although DSNREXX is free, it is truly an "optional feature" of DB2. When
ordering your next version of DB2 make sure you also "order" this feature as
well (so that it comes with your installation tapes).

I assume you can order DSNREXX for Vx after the fact (as long as you can
still order DB2 Vx itself). Thus, you can currently get DSNREXX for V7; but
you won't be able to order DSNREXX for V5. And DSNREXX for V7 won't run on
V5 (nor V6 for that matter). However I have run DSNXREXX for V6 on V7 (but
without the v7 enhancements of course) until all my DB2 sub-systems were at
V7... at which point I upgraded to DSNREXX V7 everywhere.

Rich Humphris

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of [login to unmask email]
Sent: Friday, December 05, 2003 8:27 AM
To: [login to unmask email]
Subject: REXX



One of our applications people has requested that we install the REXX
software. My questions to the group are:
Do you have this on your system?
Who can use it?
What do they use it for?
Can they use something else?


Thanks,
Paul

----------------------------------------------------------------------------
----- 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

----------------------------------------------------------------------------
----- 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


---------------------------------------------------------------------------------
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 Ruddy

Re: REXX
(in response to cliff boley)
In V8, DSNREXX no longer has to be ordered seperately - it is shipped as
part of the base product. As such, it does not have a separate SMP/E install
procedure. You will still have to Bind the packages and plan if want to use it.

Jim Ruddy
DB2 for z/OS Development

---------------------------------------------------------------------------------
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