Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Generate DDL DB2

3 posts in General Discussion Last posting was on 2012-08-17 12:42:17.0Z
Huu-Vi TON Posted on 2012-08-09 13:45:09.0Z
Sender: 48bf.5023ade2.1804289383@sybase.com
From: Huu-Vi TON
Newsgroups: sybase.public.powerdesigner.general
Subject: Generate DDL DB2
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5023bee5.4b9b.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub5023bee5"
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 9 Aug 2012 06:45:09 -0700
X-Trace: forums-1-dub 1344519909 172.20.134.41 (9 Aug 2012 06:45:09 -0700)
X-Original-Trace: 9 Aug 2012 06:45:09 -0700, 172.20.134.41
Lines: 152
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30875
Article PK: 834251

Hello,
Our team of DBA DB2 has generated a DDL to create a new DB
but the order of the instructions SQL is not in the right
way. In fact, the instruction "Create Database" is not in
first but in second position. Could you help us to correct
this issue ?

Thanks in advance,

Huu-Vi

--==============================================================
-- DBMS name: IBM DB2 Version 10 for z/OS
-- Created on: 9/08/2012 15:38:41
--==============================================================

--#SET MAXERRORS 0
SET CURRENT SQLID = 'DBA' ;
--

create large tablespace SCCK101
in DCCK1DBA
using stogroup GDB2DATA
priqty 1000
secqty 100
freepage 0
pctfree 5
gbpcache changed
define yes
logged
trackmod no
segsize 64
bufferpool BP1
ccsid ebcdic
close yes
compress yes
lockmax system
locksize any;

create large tablespace SCCK102
in DCCK1DBA
using stogroup GDB2DATA
priqty 100
secqty 12
erase no
freepage 0
pctfree 5
gbpcache changed
define yes
logged
trackmod no
bufferpool BP1
ccsid ebcdic
close yes
compress no
lockmax system
locksize any;

--==============================================================
-- Table: TCCK101
--==============================================================
create table DBA.TCCK101 (
RF_CTR_SAL_MAR CHAR(16) not null,
CD_UTL_MAJ CHAR(8) not null,
TS_MAJ_AUT TIMESTAMP not null
generated always for each row on update as row change timestamp,
CD_UTL_CRN CHAR(8) not null,
TS_UTL_CRN TIMESTAMP not null,
RF_CTR CHAR(35) not null,
NO_IDT_CTR_PMR INTEGER not null,
CD_SYS_ORI_CTR CHAR(8) not null,
RF_CTR_INI CHAR(35),
RF_CTR_BGL CHAR(35),
RF_CTR_CTP CHAR(35),
CD_FML_PRD_SAL_MAR CHAR(4),
CD_PRD_SAL_MAR CHAR(8),
TS_EVT_ORI_CTR TIMESTAMP,
DT_CTR DATE,
DT_DEB_CTR DATE,
DT_ECH_CTR DATE,
TX_CTR DECIMAL(6,3),
TX_CHG DECIMAL(8,5),
RF_SYS_PTM_CEN CHAR(35),
DT_SIG_CTR_CAD DATE,
CD_DEV_ORI CHAR(3),
MT_ORI DECIMAL(17,2),
CD_DEV_DST CHAR(3),
MT_DST DECIMAL(17,2),
LB_CMT VARCHAR(255),
LB_NOM_CLI VARCHAR(255),
LB_EVT_CTR VARCHAR(255),
LB_ETA_CTR VARCHAR(255),
constraint PCCK1011 primary key (RF_CTR_SAL_MAR)
)
in SCCK101
in database DCCK1DBA
audit none
data capture changes
ccsid ebcdic
not volatile
append no;

--==============================================================
-- Index: XCCK1011
--==============================================================
create unique index DBA.XCCK1011 on DBA.TCCK101 (
RF_CTR_SAL_MAR ASC
)
cluster
using stogroup GDB2DATA
priqty 1000
secqty 100
erase no
define yes
bufferpool BP2
close yes
defer no
copy no;

grant INSERT,SELECT,DELETE,UPDATE on DBA.TCCK101 to GDB2AALL;

grant SELECT on DBA.TCCK101 to GDB2SGLB;

--==============================================================
-- View: VCCK101S
--==============================================================
create view DBA.VCCK101S as
select
RF_CTR_SAL_MAR,
CD_UTL_MAJ,
TS_MAJ_AUT,
CD_UTL_CRN,
TS_UTL_CRN,
RF_CTR,
NO_IDT_CTR_PMR,
RF_CTR_INI,
RF_CTR_BGL,
RF_CTR_CTP,
CD_FML_PRD_SAL_MAR,
CD_PRD_SAL_MAR,
TS_EVT_ORI_CTR,
DT_CTR,
DT_DEB_CTR,
DT_ECH_CTR,
TX_CTR,
TX_CHG,
RF_SYS_PTM_CEN,
DT_SIG_CTR_CAD,
CD_DEV_ORI,
MT_ORI,
CD_DEV_DST,
MT_DST,
CD_SYS_ORI_CTR,
LB_CMT,
LB_EVT_CTR,
LB_ETA_CTR
from TCCK101;

grant SELECT on DBA.VCCK101S to GDB2AALL;

grant SELECT on DBA.VCCK101S to GDB2SGLB;

--==============================================================
-- Database: DCCK1DBA
--==============================================================
create database DCCK1DBA
bufferpool bp1
indexbp bp2
stogroup GDB2DATA
ccsid ebcdic;

--==============================================================
-- Table: TCCK102
--==============================================================
create table DBA.TCCK102 (
RF_RLC_CTR_SAL_MAR CHAR(16) not null,
CD_UTL_MAJ CHAR(8) not null,
TS_MAJ_AUT TIMESTAMP not null
generated always for each row on update as row change timestamp,
RF_CTR_SAL_MAR CHAR(16) not null,
CD_UTL_CRN CHAR(8) not null,
TS_UTL_CRN TIMESTAMP not null,
LB_NOM_MDL_RLC CHAR(35) not null,
CD_LAN_MDL_RLC CHAR(3) not null,
constraint PCCK1021 primary key (RF_RLC_CTR_SAL_MAR)
)
in SCCK102
in database DCCK1DBA;

--==============================================================
-- Index: XCCK1021
--==============================================================
create unique index DBA.XCCK1021 on DBA.TCCK102 (
RF_RLC_CTR_SAL_MAR ASC
)
cluster
using stogroup GDB2DATA
priqty 50
secqty 12
erase no
define yes
bufferpool BP2
close yes
defer no
copy no;

--==============================================================
-- Index: XCCK1022
--==============================================================
create index DBA.XCCK1022 on DBA.TCCK102 (
RF_CTR_SAL_MAR ASC
)
using stogroup GDB2DATA
priqty 50
secqty 12
erase no
define no
bufferpool BP2
close yes
defer no
copy no;

grant SELECT,UPDATE,INSERT,DELETE on DBA.TCCK102 to GDB2AALL;

grant SELECT on DBA.TCCK102 to GDB2SGLB;

alter table DBA.TCCK102
add constraint RCKK1011 foreign key (RF_CTR_SAL_MAR)
references DBA.TCCK101 (RF_CTR_SAL_MAR)
on delete cascade;


Ondra D. Posted on 2012-08-10 12:09:24.0Z
Sender: 7026.5024c37b.1804289383@sybase.com
From: Ondra D.
Newsgroups: sybase.public.powerdesigner.general
Subject: Re: Generate DDL DB2
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5024f9f4.7753.1681692777@sybase.com>
References: <5023bee5.4b9b.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 10 Aug 2012 05:09:24 -0700
X-Trace: forums-1-dub 1344600564 172.20.134.41 (10 Aug 2012 05:09:24 -0700)
X-Original-Trace: 10 Aug 2012 05:09:24 -0700, 172.20.134.41
Lines: 252
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30876
Article PK: 834250

Hi,

what is the PD version and exact version of database
definition file (bottom right corner of your PD window)?
Have you tried it with latest EBF? If the
Script\Objects\GenerationOrder in your DBMS file is correct
(database should be at first place) and I suppose it is
correct, then you should report it to Sybase as a bug. Those
two questions above will be the first, that support will be
asking you.

Regards,
Ondrej Divis

> Hello,
> Our team of DBA DB2 has generated a DDL to create a new DB
> but the order of the instructions SQL is not in the right
> way. In fact, the instruction "Create Database" is not in
> first but in second position. Could you help us to correct
> this issue ?
>
> Thanks in advance,
>
> Huu-Vi
>
>
> [Example_DDL.txt]
> --========================================================
> ====== -- DBMS name: IBM DB2 Version 10 for z/OS
> -- Created on: 9/08/2012 15:38:41
> --========================================================
> ======
>
> --#SET MAXERRORS 0
> SET CURRENT SQLID = 'DBA' ;
> --
>
> create large tablespace SCCK101
> in DCCK1DBA
> using stogroup GDB2DATA
> priqty 1000
> secqty 100
> freepage 0
> pctfree 5
> gbpcache changed
> define yes
> logged
> trackmod no
> segsize 64
> bufferpool BP1
> ccsid ebcdic
> close yes
> compress yes
> lockmax system
> locksize any;
>
> create large tablespace SCCK102
> in DCCK1DBA
> using stogroup GDB2DATA
> priqty 100
> secqty 12
> erase no
> freepage 0
> pctfree 5
> gbpcache changed
> define yes
> logged
> trackmod no
> bufferpool BP1
> ccsid ebcdic
> close yes
> compress no
> lockmax system
> locksize any;
>
> --========================================================
> ====== -- Table: TCCK101
> --========================================================
> ====== create table DBA.TCCK101 (
> RF_CTR_SAL_MAR CHAR(16) not null,
> CD_UTL_MAJ CHAR(8) not null,
> TS_MAJ_AUT TIMESTAMP not null
> generated always for each row on update as row change
> timestamp,
> CD_UTL_CRN CHAR(8) not null,
> TS_UTL_CRN TIMESTAMP not null,
> RF_CTR CHAR(35) not null,
> NO_IDT_CTR_PMR INTEGER not null,
> CD_SYS_ORI_CTR CHAR(8) not null,
> RF_CTR_INI CHAR(35),
> RF_CTR_BGL CHAR(35),
> RF_CTR_CTP CHAR(35),
> CD_FML_PRD_SAL_MAR CHAR(4),
> CD_PRD_SAL_MAR CHAR(8),
> TS_EVT_ORI_CTR TIMESTAMP,
> DT_CTR DATE,
> DT_DEB_CTR DATE,
> DT_ECH_CTR DATE,
> TX_CTR DECIMAL(6,3),
> TX_CHG DECIMAL(8,5),
> RF_SYS_PTM_CEN CHAR(35),
> DT_SIG_CTR_CAD DATE,
> CD_DEV_ORI CHAR(3),
> MT_ORI DECIMAL(17,2),
> CD_DEV_DST CHAR(3),
> MT_DST DECIMAL(17,2),
> LB_CMT VARCHAR(255),
> LB_NOM_CLI VARCHAR(255),
> LB_EVT_CTR VARCHAR(255),
> LB_ETA_CTR VARCHAR(255),
> constraint PCCK1011 primary key (RF_CTR_SAL_MAR)
> )
> in SCCK101
> in database DCCK1DBA
> audit none
> data capture changes
> ccsid ebcdic
> not volatile
> append no;
>
> --========================================================
> ====== -- Index: XCCK1011
> --========================================================
> ====== create unique index DBA.XCCK1011 on DBA.TCCK101 (
> RF_CTR_SAL_MAR ASC
> )
> cluster
> using stogroup GDB2DATA
> priqty 1000
> secqty 100
> erase no
> define yes
> bufferpool BP2
> close yes
> defer no
> copy no;
>
> grant INSERT,SELECT,DELETE,UPDATE on DBA.TCCK101 to
> GDB2AALL;
>
> grant SELECT on DBA.TCCK101 to GDB2SGLB;
>
> --========================================================
> ====== -- View: VCCK101S
> --========================================================
> ====== create view DBA.VCCK101S as
> select
> RF_CTR_SAL_MAR,
> CD_UTL_MAJ,
> TS_MAJ_AUT,
> CD_UTL_CRN,
> TS_UTL_CRN,
> RF_CTR,
> NO_IDT_CTR_PMR,
> RF_CTR_INI,
> RF_CTR_BGL,
> RF_CTR_CTP,
> CD_FML_PRD_SAL_MAR,
> CD_PRD_SAL_MAR,
> TS_EVT_ORI_CTR,
> DT_CTR,
> DT_DEB_CTR,
> DT_ECH_CTR,
> TX_CTR,
> TX_CHG,
> RF_SYS_PTM_CEN,
> DT_SIG_CTR_CAD,
> CD_DEV_ORI,
> MT_ORI,
> CD_DEV_DST,
> MT_DST,
> CD_SYS_ORI_CTR,
> LB_CMT,
> LB_EVT_CTR,
> LB_ETA_CTR
> from TCCK101;
>
> grant SELECT on DBA.VCCK101S to GDB2AALL;
>
> grant SELECT on DBA.VCCK101S to GDB2SGLB;
>
> --========================================================
> ====== -- Database: DCCK1DBA
> --========================================================
> ====== create database DCCK1DBA
> bufferpool bp1
> indexbp bp2
> stogroup GDB2DATA
> ccsid ebcdic;
>
> --========================================================
> ====== -- Table: TCCK102
> --========================================================
> ====== create table DBA.TCCK102 (
> RF_RLC_CTR_SAL_MAR CHAR(16) not null,
> CD_UTL_MAJ CHAR(8) not null,
> TS_MAJ_AUT TIMESTAMP not null
> generated always for each row on update as row change
> timestamp,
> RF_CTR_SAL_MAR CHAR(16) not null,
> CD_UTL_CRN CHAR(8) not null,
> TS_UTL_CRN TIMESTAMP not null,
> LB_NOM_MDL_RLC CHAR(35) not null,
> CD_LAN_MDL_RLC CHAR(3) not null,
> constraint PCCK1021 primary key (RF_RLC_CTR_SAL_MAR)
> )
> in SCCK102
> in database DCCK1DBA;
>
> --========================================================
> ====== -- Index: XCCK1021
> --========================================================
> ====== create unique index DBA.XCCK1021 on DBA.TCCK102 (
> RF_RLC_CTR_SAL_MAR ASC
> )
> cluster
> using stogroup GDB2DATA
> priqty 50
> secqty 12
> erase no
> define yes
> bufferpool BP2
> close yes
> defer no
> copy no;
>
> --========================================================
> ====== -- Index: XCCK1022
> --========================================================
> ====== create index DBA.XCCK1022 on DBA.TCCK102 (
> RF_CTR_SAL_MAR ASC
> )
> using stogroup GDB2DATA
> priqty 50
> secqty 12
> erase no
> define no
> bufferpool BP2
> close yes
> defer no
> copy no;
>
> grant SELECT,UPDATE,INSERT,DELETE on DBA.TCCK102 to
> GDB2AALL;
>
> grant SELECT on DBA.TCCK102 to GDB2SGLB;
>
> alter table DBA.TCCK102
> add constraint RCKK1011 foreign key (RF_CTR_SAL_MAR)
> references DBA.TCCK101 (RF_CTR_SAL_MAR)
> on delete cascade;
> [Attachment: Example_DDL.txt]


Huu-Vi TON Posted on 2012-08-17 12:42:17.0Z
Sender: 6370.502e2b27.846930886@sybase.com
From: Huu-vi TON
Newsgroups: sybase.public.powerdesigner.general
Subject: Re: Generate DDL DB2
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <502e3c29.6625.1681692777@sybase.com>
References: <5024f9f4.7753.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 17 Aug 2012 05:42:17 -0700
X-Trace: forums-1-dub 1345207337 172.20.134.41 (17 Aug 2012 05:42:17 -0700)
X-Original-Trace: 17 Aug 2012 05:42:17 -0700, 172.20.134.41
Lines: 281
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30886
Article PK: 834262

Hi,

Pd Version is 16.1.0.3637
Version of database definition file is IBM DB2 Version 10
for z/OS. Is it right ?
No information about this problem in the latest EBF.
The DBMS file is correct with database at first position.

Next step : Case-Express

Thanks

> Hi,
>
> what is the PD version and exact version of database
> definition file (bottom right corner of your PD window)?
> Have you tried it with latest EBF? If the
> Script\Objects\GenerationOrder in your DBMS file is
> correct (database should be at first place) and I suppose
> it is correct, then you should report it to Sybase as a
> bug. Those two questions above will be the first, that
> support will be asking you.
>
> Regards,
> Ondrej Divis
>
> > Hello,
> > Our team of DBA DB2 has generated a DDL to create a new
> > DB but the order of the instructions SQL is not in the
> > right way. In fact, the instruction "Create Database" is
> > not in first but in second position. Could you help us
> > to correct this issue ?
> >
> > Thanks in advance,
> >
> > Huu-Vi
> >
> >
> > [Example_DDL.txt]
> >
> >
> --========================================================
> > ====== -- DBMS name: IBM DB2 Version 10 for z/OS --
> > Created on: 9/08/2012 15:38:41
> >
> --========================================================
> ====== >
> > --#SET MAXERRORS 0
> > SET CURRENT SQLID = 'DBA' ;
> > --
> >
> > create large tablespace SCCK101
> > in DCCK1DBA
> > using stogroup GDB2DATA
> > priqty 1000
> > secqty 100
> > freepage 0
> > pctfree 5
> > gbpcache changed
> > define yes
> > logged
> > trackmod no
> > segsize 64
> > bufferpool BP1
> > ccsid ebcdic
> > close yes
> > compress yes
> > lockmax system
> > locksize any;
> >
> > create large tablespace SCCK102
> > in DCCK1DBA
> > using stogroup GDB2DATA
> > priqty 100
> > secqty 12
> > erase no
> > freepage 0
> > pctfree 5
> > gbpcache changed
> > define yes
> > logged
> > trackmod no
> > bufferpool BP1
> > ccsid ebcdic
> > close yes
> > compress no
> > lockmax system
> > locksize any;
> >
> >
> >
> --========================================================
> > ====== -- Table: TCCK101
> >
> --========================================================
> > ====== create table DBA.TCCK101 ( RF_CTR_SAL_MAR
> > CHAR(16) not null, CD_UTL_MAJ
> > CHAR(8) not null, TS_MAJ_AUT
> > TIMESTAMP not null generated always
> > for each row on update as row change timestamp,
> > CD_UTL_CRN CHAR(8) not null,
> > TS_UTL_CRN TIMESTAMP not null,
> > RF_CTR CHAR(35) not null,
> > NO_IDT_CTR_PMR INTEGER not null,
> > CD_SYS_ORI_CTR CHAR(8) not null,
> > RF_CTR_INI CHAR(35),
> > RF_CTR_BGL CHAR(35),
> > RF_CTR_CTP CHAR(35),
> > CD_FML_PRD_SAL_MAR CHAR(4),
> > CD_PRD_SAL_MAR CHAR(8),
> > TS_EVT_ORI_CTR TIMESTAMP,
> > DT_CTR DATE,
> > DT_DEB_CTR DATE,
> > DT_ECH_CTR DATE,
> > TX_CTR DECIMAL(6,3),
> > TX_CHG DECIMAL(8,5),
> > RF_SYS_PTM_CEN CHAR(35),
> > DT_SIG_CTR_CAD DATE,
> > CD_DEV_ORI CHAR(3),
> > MT_ORI DECIMAL(17,2),
> > CD_DEV_DST CHAR(3),
> > MT_DST DECIMAL(17,2),
> > LB_CMT VARCHAR(255),
> > LB_NOM_CLI VARCHAR(255),
> > LB_EVT_CTR VARCHAR(255),
> > LB_ETA_CTR VARCHAR(255),
> > constraint PCCK1011 primary key (RF_CTR_SAL_MAR)
> > )
> > in SCCK101
> > in database DCCK1DBA
> > audit none
> > data capture changes
> > ccsid ebcdic
> > not volatile
> > append no;
> >
> >
> >
> --========================================================
> > ====== -- Index: XCCK1011
> >
> --========================================================
> > ====== create unique index DBA.XCCK1011 on
> > DBA.TCCK101 ( RF_CTR_SAL_MAR ASC )
> > cluster
> > using stogroup GDB2DATA
> > priqty 1000
> > secqty 100
> > erase no
> > define yes
> > bufferpool BP2
> > close yes
> > defer no
> > copy no;
> >
> > grant INSERT,SELECT,DELETE,UPDATE on DBA.TCCK101 to
> > GDB2AALL;
> >
> > grant SELECT on DBA.TCCK101 to GDB2SGLB;
> >
> >
> >
> --========================================================
> > ====== -- View: VCCK101S
> >
> --========================================================
> > ====== create view DBA.VCCK101S as select
> > RF_CTR_SAL_MAR,
> > CD_UTL_MAJ,
> > TS_MAJ_AUT,
> > CD_UTL_CRN,
> > TS_UTL_CRN,
> > RF_CTR,
> > NO_IDT_CTR_PMR,
> > RF_CTR_INI,
> > RF_CTR_BGL,
> > RF_CTR_CTP,
> > CD_FML_PRD_SAL_MAR,
> > CD_PRD_SAL_MAR,
> > TS_EVT_ORI_CTR,
> > DT_CTR,
> > DT_DEB_CTR,
> > DT_ECH_CTR,
> > TX_CTR,
> > TX_CHG,
> > RF_SYS_PTM_CEN,
> > DT_SIG_CTR_CAD,
> > CD_DEV_ORI,
> > MT_ORI,
> > CD_DEV_DST,
> > MT_DST,
> > CD_SYS_ORI_CTR,
> > LB_CMT,
> > LB_EVT_CTR,
> > LB_ETA_CTR
> > from TCCK101;
> >
> > grant SELECT on DBA.VCCK101S to GDB2AALL;
> >
> > grant SELECT on DBA.VCCK101S to GDB2SGLB;
> >
> >
> >
> --========================================================
> > ====== -- Database: DCCK1DBA
> >
> --========================================================
> > ====== create database DCCK1DBA bufferpool bp1
> > indexbp bp2
> > stogroup GDB2DATA
> > ccsid ebcdic;
> >
> >
> >
> --========================================================
> > ====== -- Table: TCCK102
> >
> --========================================================
> > ====== create table DBA.TCCK102 ( RF_RLC_CTR_SAL_MAR
> > CHAR(16) not null, CD_UTL_MAJ
> > CHAR(8) not null, TS_MAJ_AUT
> > TIMESTAMP not null generated always
> > for each row on update as row change timestamp,
> > RF_CTR_SAL_MAR CHAR(16) not null,
> > CD_UTL_CRN CHAR(8) not null,
> > TS_UTL_CRN TIMESTAMP not null,
> > LB_NOM_MDL_RLC CHAR(35) not null,
> > CD_LAN_MDL_RLC CHAR(3) not null,
> > constraint PCCK1021 primary key (RF_RLC_CTR_SAL_MAR)
> > )
> > in SCCK102
> > in database DCCK1DBA;
> >
> >
> >
> --========================================================
> > ====== -- Index: XCCK1021
> >
> --========================================================
> > ====== create unique index DBA.XCCK1021 on
> > DBA.TCCK102 ( RF_RLC_CTR_SAL_MAR ASC )
> > cluster
> > using stogroup GDB2DATA
> > priqty 50
> > secqty 12
> > erase no
> > define yes
> > bufferpool BP2
> > close yes
> > defer no
> > copy no;
> >
> >
> >
> --========================================================
> > ====== -- Index: XCCK1022
> >
> --========================================================
> > ====== create index DBA.XCCK1022 on DBA.TCCK102 (
> > RF_CTR_SAL_MAR ASC )
> > using stogroup GDB2DATA
> > priqty 50
> > secqty 12
> > erase no
> > define no
> > bufferpool BP2
> > close yes
> > defer no
> > copy no;
> >
> > grant SELECT,UPDATE,INSERT,DELETE on DBA.TCCK102 to
> > GDB2AALL;
> >
> > grant SELECT on DBA.TCCK102 to GDB2SGLB;
> >
> > alter table DBA.TCCK102
> > add constraint RCKK1011 foreign key (RF_CTR_SAL_MAR)
> > references DBA.TCCK101 (RF_CTR_SAL_MAR)
> > on delete cascade;
> > [Attachment: Example_DDL.txt]