Program Migration REXX

Omar Ali

Program Migration REXX
Thanks you all for the Advise,
Thanks Avram that was some useful info I can Definitely use
I've also figure out that you can GEN DDL against the System Catalog,
If you tab down to the table, index, views, etc. and type GEN against
that object a batch job will be generate that you can use to capture the
structure of the table, views, indexes etc.
You can also pipe this to a PDS output
Thanks Everyone
Omar
CITY OF BOSTON

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Avram Friedman
Sent: Wednesday, December 19, 2007 2:26 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Program Migration REXX

Omar,
You might want to review DB2LOOK which can be obtainied from the IDUG
code page

Go to http://idug.org
Sign in as a member (if you are not a member yet registration / basic
membership is free)
Select the Code Place
You can browse through the entries (lots to see)
or use the search box to look for DDL

IBM has a service aid that will generate DDL as well. I have not had to
use it
for some time so I can not give you instructions for obtaining it ...
perhaps
one of the other list members can.

Peoplesoft is very complex in terms of number of tablespaces, tables,
views
etc. It is unfortunate that you dropped your license for BMC (Catalog
Manager I assume) There are many products that reverse engineer DDL.
In
the case of a Peoplesoft site having something is highly recomended.

Best Wishes
Avram Friedman

On Wed, 19 Dec 2007 10:06:24 -0500, Ali, Omar
<[login to unmask email]> wrote:

>Hi Group Happy holidays to you all,>
>I have a question that I'm hoping someone can help out,>
>We are a peopsoft environment running in z/OS DB2 v8, and will like
some
>Advise on a REXX program that will help capture the DDL's
>
>On Migrations from the catalog, (we have developers, PsAdmins) that
>scripts comes in on a daily basis to ALTER tables/views, we currently
>don't have a tool>
>To capture object that these migrations will impact. (At one point in
>time we had BMC, now that's gone)>
>This is an example:>
>CREATE TABLE PSOFT.PSYCTXPRC_PARAMS (BALANCE_ID CHAR(2) NOT NULL,
> BALANCE_YEAR SMALLINT NOT NULL,
> BALANCE_QTR SMALLINT NOT NULL,
> COMPANY CHAR(3) NOT NULL,
> ALIGN_COUNT SMALLINT NOT NULL,
>SUBMISSION_REF_ID INTEGER NOT NULL) IN DATABASE.TABLESPACE
>INSERT INTO PSHRSP1.PSYCTXPRC_PARAMS (
> BALANCE_ID,
> BALANCE_YEAR,
> BALANCE_QTR,
> COMPANY,
> ALIGN_COUNT,
> SUBMISSION_REF_ID)
>SELECT
> BALANCE_ID,
> BALANCE_YEAR,
> BALANCE_QTR
> COMPANY
> ALIGN_COUNT
>FROM PSOFT. PSYCTXPRC_PARAMS
>DROP TABLE PSOFT. PSYCTXPRC_PARAMS;
>COMMIT;
>RENAME TABLE PSOFT. PSYCTXPRC_PARAMS TO PS_CTXPRC_PARAMS>
>Under this there are Indexes and views>
>Do anyone have a REXX Program that will capture the related objects
such
>as (index, views etc)? Thanks in advance >
>Omar Ali>
>Senior Data Processing Systems Analysis>
>E-Mail [login to unmask email]
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms