Results 1 to 3 of 3

Thread: create Table

  1. #1
    Join Date
    Aug 2004
    Posts
    5

    Unanswered: create Table

    Hello,
    I'm beginning with DB2 and I need to execute a script which create a table. However I don't fully understand the script:
    Could anyone tell me what is 'UMS' in my script as well as 'TSUMSNR'?
    Thanks very much in advance.

    thomas

    Script :

    CREATE TABLE UMS.NR_NUMRIS_RETOUR
    (
    CODE_BARRE CHAR(14) NOT NULL,
    TS_RETOUR TIMESTAMP NOT NULL,
    CODE_DOC_CLASSMT CHAR(3) NOT NULL,
    DATE_NUMRIS DATE NOT NULL,
    DATE_RECPT_DOC DATE,
    NOM_LOT_NUMRIS CHAR(40) NOT NULL,
    TOP_ACCUSE_RECPT CHAR(1),
    NB_PAGE_DOC SMALLINT NOT NULL,
    UTIL_NUMRIS CHAR(8) NOT NULL,
    TOP_PEC_APPLI CHAR(1),
    DATE_CREATION DATE NOT NULL
    WITH DEFAULT,
    UTIL_CREATION CHAR(8) NOT NULL,
    DATE_MAJ DATE NOT NULL
    WITH DEFAULT,
    UTIL_MAJ CHAR(8) NOT NULL
    )
    IN TSUMSNR

  2. #2
    Join Date
    Jun 2004
    Posts
    57

    schema and tablespace

    UMS is the schema and TSUMSNR is the tablespace of the table.
    If you have a sql script with many tables and want to use the same schema you can set in the script SET CURRENT SCHEMA = 'UMS ' and then create the tables without mentioning the schema.
    All the tables will have the UMS schema.
    Anyway look for tablespaces and schema's.

  3. #3
    Join Date
    Aug 2004
    Posts
    5
    Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •