Re: SQL DDL

[Charles Wilt <charles.wilt@xxxxxxxxx>]

You actually need one more clause there if you want to use WITH DATA

ON REPLACE DELETE ROWS

Charles





On Mon, Mar 14, 2016 at 10:12 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

> With Release 7.2 TR2 we got the CREATE OR REPLACE feature.
>
> Example:
> Create or Replace Table YourSchema/YourTable
>        (ColumnId,
>         Column_Customer_No  For CustNo,
>         Column_Name_Long_1 For Name1,
>         Column_Name_Long_2 For Name2,
>         Column_Name_Long_3 For Name3,,
>         Contact,
>         Country,
>         Street,
>         PostBox,
>         ZipCode,
>         City)
>  as (Select Id,      CustNo, Name,    Name, Name, Name,
>             Country, Street, ZipCode, ZipCode, City
>        From Schema/YourRefFile)
> INCLUDING Identity Column attributes
>  With No Data;;
>
> If your reference file get modified or, just rerun the CREATE or REPLACE
> Table Statement.
> If you want to add and additional column, just put it in the SQL Script and
> rerun the CREATE OR REPLACE table statement.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
> Gad
> Miron
> Gesendet: Monday, 14.3 2016 11:57
> An: midrange-l@xxxxxxxxxxxx
> Betreff: SQL DDL
>
> Hello SQL-ians
>
> When considering defining files/tables using SQL instead of DDS I was asked
> whether SQL has the DDS REF File feature -  REF(LIB/FILE)
>
> Is there?
>
> TIA
> Gad
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.