Bookshelf Home | Contents | Index | PDF |
Implementing Siebel Business Applications on DB2 for z/OS > Installing the Siebel Database on the DB2 Host > Completing the Siebel Schema Installation Using Generated DDL > Setting Up the SQL Delimiter on DB2Because the file schema.sql uses a slash as a delimiter, you must set up the slash as the delimiter in the tool (SPUFI or DSNTEP2) you are using to apply the DDL. Siebel Business Applications ships files with slashes for delimiters because schema.sql might contain triggers for table partitioning that use semicolons. For example: CREATE TRIGGER Q202999.PTH0393 NO CASCADE BEFORE INSERT ON Q202999.S_ACT_EMP REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL WHEN (N.EMP_ID IS NOT NULL) BEGIN ATOMIC SET N.PARTITION_COLUMN=RIGHT(N.EMP_ID, 2); END NOTE: If you are not using table space partitioning, you can replace slashes with semicolons. DSNTEP2If you run the DDL in batch mode, use the DSNTEP2 tool. Perform the following procedure to set the delimiter in DSNTEP2. To set the delimiter in DSNTEP2
SPUFIIf you use SPUFI, perform the following procedure to set the delimiter. To set the SQL delimiter in SPUFI
If you are not using triggers, you can change the slashes back to semicolons. If you use the TSO editor, do this by entering the following: |
Implementing Siebel Business Applications on DB2 for z/OS | Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |