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

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.

Thank you.