Hi ,
Unix.com has been life saver for me I admit 
I am trying to extract a paragraph based on matching pattern "CREATE TABLE " from a ddl file . The paragraphs are seperated by blank line .
Input file is
#cat zip.20080604.sql1
CONNECT TO TST103
SET SESSION_USER OPSDM002
SET CURRENT SCHEMA OPSDM002
CREATE TABLE "OPSDM002"."DIM_ZIP" (
"ZIP_CD" CHAR(5) NOT NULL ,
"ZIP_TYP_SRC_CD" CHAR(1) NOT NULL ,
"ZIP_TYP_CD" CHAR(1) NOT NULL ,
"ZIP_ROW_END_DT" DATE NOT NULL ,
"ZIP_ROW_EFF_DT" DATE NOT NULL ,
"ZIP_LST_2_CD" CHAR(2) NOT NULL ,
"ZIP_FST_3_CD" CHAR(3) NOT NULL ,
"UPDT_DT" DATE NOT NULL WITH DEFAULT CURRENT DATE ,
"ST_NUM_CD" CHAR(2) NOT NULL ,
"ST_ABBR_CD" CHAR(2) NOT NULL ,
"PST_CNTY_NM" VARCHAR(25) NOT NULL ,
"PST_CNTY_CD" CHAR(3) NOT NULL ,
"LOAD_DT" DATE NOT NULL WITH DEFAULT CURRENT DATE ,
"HCFA_CNTY_NM" VARCHAR(30) NOT NULL ,
"HCFA_CNTY_CD" CHAR(4) NOT NULL ,
"CTY_NM" VARCHAR(28) NOT NULL )
COMPRESS YES
IN "TSOPS03" INDEX IN "TSOPIX03"
CREATE INDEX "OPSDM002"."IDX1_ST_CD" ON "OPSDM002"."DIM_ZIP"
("ST_ABBR_CD" ASC)
ALLOW REVERSE SCANS
CREATE UNIQUE INDEX "OPSDM002"."PK1_ZIP_CD" ON "OPSDM002"."DIM_ZIP"
("ZIP_CD" ASC)
CLUSTER ALLOW REVERSE SCANS
ALTER TABLE "OPSDM002"."DIM_ZIP"
ADD CONSTRAINT "PK1_ZIP_CD" PRIMARY KEY
("ZIP_CD")
CREATE ALIAS "OPSDM002"."ZIP" FOR "OPSDM002"."DIM_ZIP"
CREATE VIEW "OPSDM002"."ZIP_CUSTOMER_SEGMENT" ("CUST_ZIP_CD", "CUST_CTY_NM",
"CUST_HCFA_CNTY_CD", "CUST_HCFA_CNTY_NM", "CUST_PST_CNTY_CD", "CUST_PST_CNTY_NM",
"CUST_ST_ABBR_CD", "CUST_ST_NUM_CD", "CUST_ZIP_FST_3_CD", "CUST_ZIP_LST_2_CD",
"CUST_ZIP_ROW_EFF_DT", "CUST_ZIP_ROW_END_DT", "CUST_ZIP_TYP_CD", "CUST_ZIP_TYP_SRC_CD",
"LOAD_DT", "UPDT_DT") AS SELECT DIM_ZIP.ZIP_CD, DIM_ZIP.CTY_NM, DIM_ZIP.HCFA_CNTY_CD,
DIM_ZIP.HCFA_CNTY_NM, DIM_ZIP.PST_CNTY_CD, DIM_ZIP.PST_CNTY_NM, DIM_ZIP.ST_ABBR_CD,
DIM_ZIP.ST_NUM_CD, DIM_ZIP.ZIP_FST_3_CD, DIM_ZIP.ZIP_LST_2_CD, DIM_ZIP.ZIP_ROW_EFF_DT,
DIM_ZIP.ZIP_ROW_END_DT, DIM_ZIP.ZIP_TYP_CD, DIM_ZIP.ZIP_TYP_SRC_CD, DIM_ZIP.LOAD_DT,
DIM_ZIP.UPDT_DT FROM DIM_ZIP
CREATE VIEW "OPSDM002"."ZIP_MEMBER" ("MBR_ZIP_CD", "MBR_CTY_NM", "MBR_HCFA_CNTY_CD",
"MBR_HCFA_CNTY_NM", "MBR_PST_CNTY_CD", "MBR_PST_CNTY_NM", "MBR_ST_ABBR_CD",
"MBR_ST_NUM_CD", "MBR_ZIP_FST_3_CD", "MBR_ZIP_LST_2_CD", "MBR_ZIP_ROW_EFF_DT",
"MBR_ZIP_ROW_END_DT", "MBR_ZIP_TYP_CD", "MBR_ZIP_TYP_SRC_CD", "LOAD_DT",
"UPDT_DT") AS SELECT DIM_ZIP.ZIP_CD, DIM_ZIP.CTY_NM, DIM_ZIP.HCFA_CNTY_CD,
DIM_ZIP.HCFA_CNTY_NM, DIM_ZIP.PST_CNTY_CD, DIM_ZIP.PST_CNTY_NM, DIM_ZIP.ST_ABBR_CD,
DIM_ZIP.ST_NUM_CD, DIM_ZIP.ZIP_FST_3_CD, DIM_ZIP.ZIP_LST_2_CD, DIM_ZIP.ZIP_ROW_EFF_DT,
DIM_ZIP.ZIP_ROW_END_DT, DIM_ZIP.ZIP_TYP_CD, DIM_ZIP.ZIP_TYP_SRC_CD, DIM_ZIP.LOAD_DT,
DIM_ZIP.UPDT_DT FROM DIM_ZIP
CREATE VIEW "OPSDM002"."ZIP_PROVIDER" ("PROV_ZIP_CD", "PROV_CTY_NM", "PROV_HCFA_CNTY_CD",
"PROV_HCFA_CNTY_NM", "PROV_PST_CNTY_CD", "PROV_PST_CNTY_NM", "PROV_ST_ABBR_CD",
"PROV_ST_NUM_CD", "PROV_ZIP_FST_3_CD", "PROV_ZIP_LST_2_CD", "PROV_ZIP_ROW_EFF_DT",
"PROV_ZIP_ROW_END_DT", "PROV_ZIP_TYP_CD", "PROV_ZIP_TYP_SRC_CD", "LOAD_DT",
"UPDT_DT") AS SELECT DIM_ZIP.ZIP_CD, DIM_ZIP.CTY_NM, DIM_ZIP.HCFA_CNTY_CD,
DIM_ZIP.HCFA_CNTY_NM, DIM_ZIP.PST_CNTY_CD, DIM_ZIP.PST_CNTY_NM, DIM_ZIP.ST_ABBR_CD,
DIM_ZIP.ST_NUM_CD, DIM_ZIP.ZIP_FST_3_CD, DIM_ZIP.ZIP_LST_2_CD, DIM_ZIP.ZIP_ROW_EFF_DT,
DIM_ZIP.ZIP_ROW_END_DT, DIM_ZIP.ZIP_TYP_CD, DIM_ZIP.ZIP_TYP_SRC_CD, DIM_ZIP.LOAD_DT,
DIM_ZIP.UPDT_DT FROM DIM_ZIP
CREATE VIEW "OPSDM002"."ZIP_PROVIDER_MBR_PRI" ("MBR_PRI_PROV_ZIP_CD", "MBR_PRI_CTY_NM",
"MBR_PRI_HCFA_CNTY_CD", "MBR_PRI_HCFA_CNTY_NM", "MBR_PRI_PST_CNTY_CD",
"MBR_PRI_PST_CNTY_NM", "MBR_PRI_ST_ABBR_CD", "MBR_PRI_ST_NUM_CD", "MBR_PRI_ZIP_FST_3_CD",
"MBR_PRI_ZIP_LST_2_CD", "MBR_PRI_ZIP_ROW_EFF_DT", "MBR_PRI_ZIP_ROW_END_DT",
"MBR_PRI_ZIP_TYP_CD", "MBR_PRI_ZIP_TYP_SRC_CD", "LOAD_DT", "UPDT_DT") AS
SELECT DIM_ZIP.ZIP_CD, DIM_ZIP.CTY_NM, DIM_ZIP.HCFA_CNTY_CD, DIM_ZIP.HCFA_CNTY_NM,
DIM_ZIP.PST_CNTY_CD, DIM_ZIP.PST_CNTY_NM, DIM_ZIP.ST_ABBR_CD, DIM_ZIP.ST_NUM_CD,
DIM_ZIP.ZIP_FST_3_CD, DIM_ZIP.ZIP_LST_2_CD, DIM_ZIP.ZIP_ROW_EFF_DT, DIM_ZIP.ZIP_ROW_END_DT,
DIM_ZIP.ZIP_TYP_CD, DIM_ZIP.ZIP_TYP_SRC_CD, DIM_ZIP.LOAD_DT, DIM_ZIP.UPDT_DT
FROM DIM_ZIP
CREATE VIEW "OPSDM002"."ZIP_PROVIDER_REF" ("REF_PROV_ZIP_CD", "REF_CTY_NM",
"REF_HCFA_CNTY_CD", "REF_HCFA_CNTY_NM", "REF_PST_CNTY_CD", "REF_PST_CNTY_NM",
"REF_ST_ABBR_CD", "REF_ST_NUM_CD", "REF_ZIP_FST_3_CD", "REF_ZIP_LST_2_CD",
"REF_ZIP_ROW_EFF_DT", "REF_ZIP_ROW_END_DT", "REF_ZIP_TYP_CD", "REF_ZIP_TYP_SRC_CD",
"LOAD_DT", "UPDT_DT") AS SELECT DIM_ZIP.ZIP_CD, DIM_ZIP.CTY_NM, DIM_ZIP.HCFA_CNTY_CD,
DIM_ZIP.HCFA_CNTY_NM, DIM_ZIP.PST_CNTY_CD, DIM_ZIP.PST_CNTY_NM, DIM_ZIP.ST_ABBR_CD,
DIM_ZIP.ST_NUM_CD, DIM_ZIP.ZIP_FST_3_CD, DIM_ZIP.ZIP_LST_2_CD, DIM_ZIP.ZIP_ROW_EFF_DT,
DIM_ZIP.ZIP_ROW_END_DT, DIM_ZIP.ZIP_TYP_CD, DIM_ZIP.ZIP_TYP_SRC_CD, DIM_ZIP.LOAD_DT,
DIM_ZIP.UPDT_DT FROM DIM_ZIP
CREATE VIEW "OPSDM002"."ZIP_PROVIDER_SRVC" ("SRVC_PROV_ZIP_CD", "SRVC_CTY_NM",
"SRVC_HCFA_CNTY_CD", "SRVC_HCFA_CNTY_NM", "SRVC_PST_CNTY_CD", "SRVC_PST_CNTY_NM",
"SRVC_ST_ABBR_CD", "SRVC_ST_NUM_CD", "SRVC_ZIP_FST_3_CD", "SRVC_ZIP_LST_2_CD",
"SRVC_ZIP_ROW_EFF_DT", "SRVC_ZIP_ROW_END_DT", "SRVC_ZIP_TYP_CD", "SRVC_ZIP_TYP_SRC_CD",
"LOAD_DT", "UPDT_DT") AS SELECT DIM_ZIP.ZIP_CD, DIM_ZIP.CTY_NM, DIM_ZIP.HCFA_CNTY_CD,
DIM_ZIP.HCFA_CNTY_NM, DIM_ZIP.PST_CNTY_CD, DIM_ZIP.PST_CNTY_NM, DIM_ZIP.ST_ABBR_CD,
DIM_ZIP.ST_NUM_CD, DIM_ZIP.ZIP_FST_3_CD, DIM_ZIP.ZIP_LST_2_CD, DIM_ZIP.ZIP_ROW_EFF_DT,
DIM_ZIP.ZIP_ROW_END_DT, DIM_ZIP.ZIP_TYP_CD, DIM_ZIP.ZIP_TYP_SRC_CD, DIM_ZIP.LOAD_DT,
DIM_ZIP.UPDT_DT FROM DIM_ZIP
GRANT SELECT ON TABLE "OPSDM002"."DIM_ZIP" TO GROUP "DSDBDEV "
GRANT SELECT ON TABLE "OPSDM002"."DIM_ZIP" TO GROUP "UHCDMTST"
GRANT SELECT ON TABLE "OPSDM002"."DIM_ZIP" TO GROUP "CLOSEL01"
GRANT SELECT ON TABLE "OPSDM002"."DIM_ZIP" TO GROUP "CLOSEL02"
GRANT CONTROL ON TABLE "OPSDM002"."DIM_ZIP" TO GROUP "UHCDMDBA"
GRANT SELECT ON TABLE "OPSDM002"."DIM_ZIP" TO GROUP "CLOSEL04"
GRANT SELECT ON TABLE "OPSDM002"."DIM_ZIP" TO GROUP "CLOSEL05"
GRANT SELECT ON TABLE "OPSDM002"."DIM_ZIP" TO GROUP "SELCOE01"
GRANT CONTROL ON TABLE "OPSDM002"."DIM_ZIP" TO USER "ESHIRLE "
GRANT CONTROL ON TABLE "OPSDM002"."DIM_ZIP" TO USER "SNIETER "
GRANT CONTROL ON TABLE "OPSDM002"."DIM_ZIP" TO USER "LTREXL1 "
GRANT CONTROL ON TABLE "OPSDM002"."DIM_ZIP" TO USER "RSMIT11 "
GRANT CONTROL ON TABLE "OPSDM002"."DIM_ZIP" TO USER "KJOHNS5 "
GRANT CONTROL ON TABLE "OPSDM002"."DIM_ZIP" TO USER "AMENSEY "
COMMIT WORK
CONNECT RESET
TERMINATE
Desired output is
CREATE TABLE "OPSDM002"."DIM_ZIP" (
"ZIP_CD" CHAR(5) NOT NULL ,
"ZIP_TYP_SRC_CD" CHAR(1) NOT NULL ,
"ZIP_TYP_CD" CHAR(1) NOT NULL ,
"ZIP_ROW_END_DT" DATE NOT NULL ,
"ZIP_ROW_EFF_DT" DATE NOT NULL ,
"ZIP_LST_2_CD" CHAR(2) NOT NULL ,
"ZIP_FST_3_CD" CHAR(3) NOT NULL ,
"UPDT_DT" DATE NOT NULL WITH DEFAULT CURRENT DATE ,
"ST_NUM_CD" CHAR(2) NOT NULL ,
"ST_ABBR_CD" CHAR(2) NOT NULL ,
"PST_CNTY_NM" VARCHAR(25) NOT NULL ,
"PST_CNTY_CD" CHAR(3) NOT NULL ,
"LOAD_DT" DATE NOT NULL WITH DEFAULT CURRENT DATE ,
"HCFA_CNTY_NM" VARCHAR(30) NOT NULL ,
"HCFA_CNTY_CD" CHAR(4) NOT NULL ,
"CTY_NM" VARCHAR(28) NOT NULL )
COMPRESS YES
IN "TSOPS03" INDEX IN "TSOPIX03"
Thanks ,