Job lst job cretaben create

This preview shows page 173 - 176 out of 260 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
CMPTR
The document you are viewing contains questions related to this textbook.
Chapter 16 / Exercise 17
CMPTR
Pinard/Romer/Morley
Expert Verified
* $$ JOB JNM=CRETABEN,DISP=D,CLASS=S,PRI=9* $$ LST DISP=D,CLASS=Q,DEST=(*,SJADM)// JOB CRETABEN CREATE DOUGLAS TABLES WITH ENGLISH DEF'S// LIBDEF *,SEARCH=(PRD2.DB2510,PRD2.CONFIG)// EXEC PGM=ARIDBS,SIZE=AUTO,PARM='DBNAME(SJVSEDB1)'CONNECT DBADMIN IDENTIFIED BY ITSOSJ;SET ISOL(CS);SET AUTOCOMMIT(ON);CREATE TABLE ARTICLE_TXT(BASARTNODECIMAL(13,0) NOT NULL, -- BASIC ARTICLE NUMBERPRODNODECIMAL(3,0)NOT NULL, -- PRODUCT TYPE IDCOMPNODECIMAL(3,0)NOT NULL, -- COMPANY NUMBERPRCRNGNODECIMAL(3,0)NOT NULL, -- PRICE RANGE IDSTORENODECIMAL(3,0)NOT NULL, -- STORE NUMBERTXTTYPNODECIMAL(2,0)NOT NULL, -- TEXT TYPE IDARTICLE_TEXTCHAR(45)NOT NULL,PRIMARY KEY(BASARTNO,PRODNO,COMPNO,PRCRNGNO,STORENO,TXTTYPNO)) IN ARTTXT;CREATE TABLE BASE_ARTICLE(BASARTNODECIMAL(13,0) NOT NULL, -- BASIC ARTICLE NUMBERBASART_TXTCHAR(45)NOT NULL, -- BASIC ARTICLE TEXT
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
CMPTR
The document you are viewing contains questions related to this textbook.
Chapter 16 / Exercise 17
CMPTR
Pinard/Romer/Morley
Expert Verified
158Getting Started with Data Warehouse and Business IntelligenceCONTENSCHAR(7),-- CONTENS OF CONTAINERCREATE_DATEDATENOT NULL, -- CREATION DATECHANGE_DATEDATE,-- CHANGE DATEBASARTDELDATDATE,-- DELETION DATEBASARTSTRTDAT DATENOT NULL, -- START MERCHANDISE DATEMCONTENSDECIMAL(3,0),-- NOT FILLEDHEADARTNODECIMAL(13,0) ,-- NOT FILLEDOWN_BRANDDECIMAL(1,0),-- COMPANY OWN BRANDDISPDECIMAL(1,0),-- DISPOSITIONPG1DECIMAL(5,0),-- PRODUCT GROUPSPG2DECIMAL(5,0),PG3DECIMAL(5,0),PG4DECIMAL(5,0),PG5DECIMAL(5,0),COLORNODECIMAL(3,0)NOT NULL, -- COLOR ID (NOT USED)PRIMARY KEY(BASARTNO)) IN BASART;CREATE UNIQUE INDEX BASARTNO ON BASE_ARTICLE(BASARTNOASC ) ;CREATE TABLE DEPOT(PRODNODECIMAL(3,0)NOT NULL, -- PRODUCT TYPE IDCOMPNODECIMAL(3,0)NOT NULL, -- COMPANY NUMBERPRCRNGNODECIMAL(3,0)NOT NULL, -- PRICE RANGE IDSTORENODECIMAL(3,0)NOT NULL, -- STORE NUMBERSUPPLNODECIMAL(13,0) NOT NULL, -- SUPPLIER NUMBERDEPOTNODECIMAL(7,0)NOT NULL, -- DEPOT NUMBERSORT_DEPOTDECIMAL(3,0)NOT NULL,SORT_LINEDECIMAL(3,0)NOT NULL,TEXT_DEPOTCHAR(30)NOT NULL,TEXT_LINECHAR(30)NOT NULL,CREATE_DATEDATENOT NULL,DELETE_DATEDATE,CALC_FACTORDECIMAL(5,3),-- CALCULATION FACTORPRIMARY KEY(PRODNO,COMPNO,PRCRNGNO,STORENO,SUPPLNO,DEPOTNO)) IN DEPOT;CREATE TABLE SUPPLIERS_ARTICLE(SUPPLNODECIMAL(13,0) NOT NULL, -- SUPPLIER NUMBERBASARTNODECIMAL(13,0) NOT NULL, -- BASE ARTICLE NUMBERPRODNODECIMAL(3,0)NOT NULL, -- PRODUCT TYPE IDCOMPNODECIMAL(3,0)NOT NULL, -- COMPANY NUMBERPRCRNGNODECIMAL(3,0)NOT NULL, -- PRICE RANGE IDSTORENODECIMAL(3,0)NOT NULL, -- STORE NUMBERDEL_MARKCHAR(1),-- DELETION MARKERDELETE_DATEDATE,CHANGE_DATEDATE,CREATE_DATEDATENOT NULL,SORT_IDDECIMAL(13,0) ,ORD_WEEKDECIMAL(2,0),-- ORDERING WEEKSORD_DAYDECIMAL(3,0),-- ORDERING DAYSPRCLISTCHAR(1),-- PRICE LIST IDCONDLISTCHAR(1),-- CONDITION LIST IDBILLACCNTDECIMAL(2,0),-- BILLING ACCOUNTCOMM_IDDECIMAL(2,0),-- COMMISSION IDDELVR_KEYDECIMAL(2,0),-- DELIVERY KEYDELVR_UNITDECIMAL(8,3)NOT NULL, -- DELIVERY UNIT
Implementation159SUPPL_UNITDECIMAL(8,3)NOT NULL, -- SUPPLIED UNITCONTENSCHAR(7),SUPPLARTTXTCHAR(45),-- SUPPL. ARTICLE DESCR.SUPPLPATHDECIMAL(3,0)NOT NULL, -- SUPPLY PATH IDORDERNOCHAR(13),-- ORDER NUMBERSTART_DATEDATENOT NULL,DEPOTNODECIMAL(7,0)NOT NULL, -- DEPOT NUMBERDELVRTIMEDECIMAL(4,1),-- DELIVERY TIMESUPPLARTNOCHAR(20),-- SUPPL. ARTICLE NUMBERPRIMARY KEY(SUPPLNO,BASARTNO,PRODNO,COMPNO,PRCRNGNO,STORENO)) IN SUPPLART;

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture