Re: DDS vs DDL

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