Sample output from generating SQL
When you use the GEN command, Db2 Admin Tool generates DDL statements for the specified object or objects.
The following figures show examples of the generated SQL:
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5655-W34 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Input prepared on : DSNA (1015 ) Extract time : 2013-05-14 07:37 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=N DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=N CM=N FK=N --
-- TG=Y UT=N UF=N SP=N SQ=N RO=N TC=N MK=Y PM=Y AC=Y --
-- Grants : SG=N DB=N TS=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Database DSNDB06 --
-- --
------------------------------------------------------------------------
--
--
------------------------------------------------------------------------
------------------------------------------------------------------------
--
SET CURRENT SQLID='SYSIBM';
--
--#SET ACCEPT_RC 0 -618
--
CREATE DATABASE DSNDB06
INDEXBP BP0
CCSID EBCDIC;
-- ------------------------------------------------------------------------
-- Table space=DSNDB06.SYSALTER
------------------------------------------------------------------------
--
CREATE TABLESPACE SYSALTER
IN DSNDB06
-- VCAT "00000001" -- DB2 catalog tablespace
FREEPAGE 0 PCTFREE 7
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
SEGSIZE 4
BUFFERPOOL BP32K
LOCKSIZE ROW
LOCKMAX SYSTEM
CLOSE NO
COMPRESS NO
CCSID UNICODE
DEFINE YES
MAXROWS 255;
-- ------------------------------------------------------------------------
– View=XXXXX.VWEMPLOY1
------------------------------------------------------------------------
SET CURRENT SCHEMA='XXXXX';
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","XXXXX" ;
SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M506 ';
CREATE VIEW TSLHC.VWEMPLOY1(EMPNO, FIRSTNME, LASTNAME) AS
SELECT EMPNO, FIRSTNME, LASTNAME
FROM TSLHC.EMPLOYEE;
SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M507 ';
COMMIT;
------------------------------------------------------------------------ If you specified that REBIND commands were to be generated, the REBIND output is also included, as shown in the following figure:
-------------------------------------------------------------------------------
EDIT SYS01311.T012717.RA000.ISTJE.R0215994 Columns 00001 00072
Command ===> Scroll ===> PAGE
****** ***************************** Top of Data ******************************
000001 REBIND PACKAGE(DSN8ES81.DSN8ES1)
****** **************************** Bottom of Data ****************************
Note: In some cases, data-partitioned secondary indexes might be included in the output, because the
process to generate the SQL supports these indexes.