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.
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,
NOM_LOT_NUMRIS CHAR(40) NOT NULL,
NB_PAGE_DOC SMALLINT NOT NULL,
UTIL_NUMRIS CHAR(8) NOT NULL,
DATE_CREATION DATE NOT NULL
UTIL_CREATION CHAR(8) NOT NULL,
DATE_MAJ DATE NOT NULL
UTIL_MAJ CHAR(8) NOT NULL
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.