IDUG Links

Mark Labby

IDUG Links
Avram - You seen to be one of the biggest proponents of pointing people to the IDUG website. Thank you! We're trying to make it easy for people to jump from the list to the website. If you look at the list messages, the footer was changed in the past week to have the IDUG links. IDUG.ORG is the only URL you need to get information on all IDUG features - Listserv, Code Place, Tech Library, Solutions Journal, Conferences, etc. There is even a special link at the bottom for people who haven't gotten their free memebership to go directly to the registration page. On Wed, 19 Dec 2007 19:25:33 +0000, Avram Friedman wrote: >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 > 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. >> >>------------------------------------------------------------------------ >>--------- 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". The IDUG DB2-L FAQ is at >>http://www.idugdb2-l.org. 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 >>The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L >>list archives, the FAQ, and delivery preferences are at www.idug.org >> 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 >> >>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 >> > >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
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org 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