Re: CASE*Dict V5.0 - Newbie needs help

From: Jeff Jacobs <jmjacobs_at_ix.netcom.com>
Date: 1996/05/09
Message-ID: <3190cb9f.2853413_at_nntp.ix.netcom.com>#1/1


Ismael Matos <matos.ismael.ia_at_bhp.com.au> wrote:

>Hi everyone,
>
>I need you advice in updating some CASE*Dict
>tables:
>
>I've got hundreds of simple changes to Oracle
>tables (ALTER TABLE blablabla MODIFY (...)).
>While the SQL DDL script is a trivial thing to
>prepare, I don't like the idea of going thru
>hundreds and hundreds of interactions with
>CASE*Dict screens to update ATTRIBUTES and
>COLUMNS...
>
>Have any of you ever tried to update those tables
>using some sort of batch/script/import/CDIF
>facilty?

This has been done, although its not supported.

You must be **very** careful what you update. If you are updating simple properties of elemenets, you should be ok (such as a format mask), but if you are trying to update foreign keys, or names of primary elements, its very dangerous.

-JJ

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 415-571-7092, FAX: 800-665-1379 CompuServe: 76702,456  Internet: 76702.456_at_compuserve.com     Received on Thu May 09 1996 - 00:00:00 CEST

Original text of this message