[RBASE-L] - Re: Cascading keys - Razzak's Reply

[A. Razzak Memon]

Karen,

CASCADE option is added on the same line where
CREATE TABLE `TableName` command is issued.
So, when you UNLOAD STRUCTURE or SCHEMA, you will
see that CASCADE option on the same line where
CREATE TABLE `TableName` command is.
Try the following simple steps to understand:

01.     Start R:BASE 6.5++ or 7.0

02.     At the mighty R> prompt:

        CONNect Concomp
        ALTER TABLE Customer ADD CASCADE
        OUTP Customer.STR
        UNLOAD STRUCTURE FOR Customer
        OUTP SCREEN
03.     RBEDIT Customer.STR

        After the initial information about the SETtings
        and CREATE SCHEMA AUTHOR Concomp NONE, you'll
        notice the following:
        CREATE TABLE `Customer` CASCADE  +
        (`Custid` INTEGER  NOT NULL  +
        ('Customer id number cannot be NULL.') ,  +
        `Company` TEXT (40), +
        `Custaddress` TEXT (30), +
        `Custcity` TEXT (20), +
        `Custstate` TEXT (2), +
        `Custzip` TEXT (10), +
        `Custphone` TEXT (12), +
        `Modlevel` INTEGER, +
        `LastUpdateDate` DATE, +
        `LastUpdateTime` TIME, +
        `LastOrderDate` DATE, +
        `CustURL` TEXT (90), +
        `CustEMail` TEXT (60), +
        `CustStatus` TEXT (1))
Have Fun!

Now, you should be the expert on CASCADE!

Very Best R:egards,

Razzak.

At 02:15 PM 6/28/2003 -0400, Karen Tellef wrote:

Razzak:

Yep!  There it is!  I see it now.

One question, though.  When I do an unload of the structure
of the table, I see the primary key but I don't see any lines
regarding the 'cascade'.  So if I'm bringing a table over to
a client and I need to cascade it, I would need to include
the alter table command with it?
Karen


At the mighty R> prompt, type:

LIST Loads

After the Table name and Description, you'll
notice the additional option of Flags: CASCADE