Re: DDS vs DDL

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

Why not use Navigator to generate the SQL needed to define the file?  Then
you would know exactly what IBM recommends as the SQL method to create it.

In Navigator:  (http://yoursystemname:2001
Open Database, then Databases
Schemas  (if the library is in your library list it'll show up, otherwise
use Actions, Select Schemas to add your library.)
tables
select your table .then under actions use "Generate SQL"

You'll get something like this:

--  Generate SQL
--  Version:                   V7R3M0 160422
--  Generated on:               09/03/21 09:05:16
--  Relational Database:       V7R3PRD
--  Standards Option:           Db2 for i
CREATE TABLE IDEVTEST.FEATURE_CODE FOR SYSTEM NAME FEATCODE (
FEATURE_CODE FOR COLUMN FEATCODE   CHAR(4) CCSID 37 NOT NULL ,
DESCRIPTION FOR COLUMN "DESC" CHAR(60) CCSID 37 NOT NULL ,
BASE_PRICE FOR COLUMN PRICE      DECIMAL(4, 2) NOT NULL ,
UNIT_OF_MEASURE FOR COLUMN UOM        CHAR(4) CCSID 37 NOT NULL ,
CONSTRAINT IDEVTEST.PK_FEATURE_CODE PRIMARY KEY( FEATURE_CODE ) )

RCDFMT FEATCODE   ;

ALTER TABLE IDEVTEST.FEATURE_CODE
ADD CONSTRAINT IDEVTEST.FK_FEATURE_CODE_RI_UNIT_OF_MEASURE
FOREIGN KEY( UNIT_OF_MEASURE )
REFERENCES IDEVTEST.RI_UNIT_OF_MEASURE ( UNIT_OF_MEASURE )
ON DELETE NO ACTION
ON UPDATE NO ACTION ;

LABEL ON TABLE IDEVTEST.FEATURE_CODE
IS 'Feature Code' ;

GRANT ALTER , DELETE , INDEX , INSERT , REFERENCES , SELECT , UPDATE
ON IDEVTEST.FEATURE_CODE TO JIM WITH GRANT OPTION ;

;




Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On Fri, Sep 3, 2021 at 9:02 AM DEnglander--- via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> Birgitta,
>
> Thank you for sharing that response from Rochester. I agree with that when
> you are designing a system from scratch. However, in most shops where I
> have worked, there is a mixture of new and old code, and having the use of
> referenced fields helps alot in reducing the hardcoding of field sizes
> differently depending on who wrote the application.
>
> I did not think I could define a PF with a 12 position timestamp, but
> thought I'd ask anyway.
>
> In reference to packed versus zoned, the IBM DDS Manual at V7R2 on page 23
> says this: "Note: The system performs arithmetic operations more
> efficiently for a packed decimal than for a zoned decimal data type."
>
> That is the only reason I asked.
>
> Thank you again.
>
> Doug
>
>
>
> "CONFIDENTIALITY NOTICE:  This e-mail transmission (and/or the attachments
> accompanying it) contain confidential information belonging to the sender.
> The information is intended only for the use of the intended recipient.  If
> you are not the intended recipient, you are hereby notified that any
> disclosure, copying, distribution or the taking of any action in reliance
> on the contents of the information is strictly prohibited.  Any
> unauthorized interception of this transmission is illegal under the law.
> If you have received this transmission in error, please promptly notify the
> sender by reply e-mail, and then destroy all copies of the transmission."
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com