Toad World® Forums

Export DDL not exporting SP's


#1

Export of selected schema is not exporting SP’s (only 1 was exported why?)

– Script created by Quest Extract DDL at 1/29/2010 1:40:29 PM for DB2PLOC
(mark)

– System Objects may have been excluded from this script.

SET SCHEMA = ‘MARK’ ;

SET CURRENT SQLID = ‘MARK’ ;

CREATE TABLE “FDBHRA”.“AUDIT_ALL_TRANSACTI ON_HRA” (

“ALL_HRA_ID” INTEGER NOT NULL ,

“FAMILY_ID” INTEGER WITH DEFAULT NULL ,

“RELATION_ID” INTEGER WITH DEFAULT NULL ,

“PART_SSNO” INTEGER WITH DEFAULT NULL ,

“TRANSACTION_ TYPE” INTEGER WITH DEFAULT NULL ,

“TRANSACTION_ DESCRIPTION” VARCHAR ( 55 ) FOR SBCS DATA WITH DEFAULT NULL ,

“EFFECTIVE_DATE” DATE WITH DEFAULT NULL ,

“EXPIRATION_DATE” DATE WITH DEFAULT NULL ,

“HRA_QUAL_AMT” DECIMAL ( 9 , 4 ) WITH DEFAULT NULL ,

“TRANSACTION_ AMT” DECIMAL ( 9 , 4 ) WITH DEFAULT NULL ,

“TRANSACTION_ DATE” DATE WITH DEFAULT NULL ,

“CLAIM_ID” INTEGER WITH DEFAULT NULL ,

“LINE_NBR” INTEGER WITH DEFAULT NULL ,

“RX_CLAIM_NBR” DECIMAL ( 15 , 0 ) WITH DEFAULT NULL ,

“RX_CLAIM_NBR_ SEQ” DECIMAL ( 5 , 0 ) WITH DEFAULT NULL ,

“DISPENSE_DATE” DATE WITH DEFAULT NULL ,

“CHECK_NBR” INTEGER WITH DEFAULT NULL ,

“LASTUPDT” DATE WITH DEFAULT NULL ,

“COMMENTS” VARCHAR ( 55 ) FOR SBCS DATA WITH DEFAULT NULL ,

“TRANS_ID” INTEGER WITH DEFAULT NULL ,

CONSTRAINT “ALL_HRA_ID” PRIMARY KEY

(“ALL_HRA_ID”)

)

IN “FDBHRA”.“FTSPAUD3”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“AUDIT_CLAIMS_ HRA” (

“AUD1_ID” INTEGER NOT NULL ,

“FAMILY_ID” INTEGER NOT NULL ,

“RELATION_ID” INTEGER WITH DEFAULT NULL ,

“PROCESSED_DATE” DATE WITH DEFAULT NULL ,

“CLAIM_ELIG_STATUS” VARCHAR ( 15 ) FOR SBCS DATA WITH DEFAULT NULL ,

“ELIG_STATUS” VARCHAR ( 15 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MED_PLAN” VARCHAR ( 15 ) FOR SBCS DATA WITH DEFAULT NULL ,

“CLAIM_ID” INTEGER WITH DEFAULT NULL ,

“LINE_NBR” INTEGER WITH DEFAULT NULL ,

“PAY_STATUS” VARCHAR ( 10 ) FOR SBCS DATA WITH DEFAULT NULL ,

“PROC_CODE” VARCHAR ( 10 ) FOR SBCS DATA WITH DEFAULT NULL ,

“DIAG1” VARCHAR ( 10 ) FOR SBCS DATA WITH DEFAULT NULL ,

“DIAG2” VARCHAR ( 10 ) FOR SBCS DATA WITH DEFAULT NULL ,

“REASON1” VARCHAR ( 5 ) FOR SBCS DATA WITH DEFAULT NULL ,

“REASON2” VARCHAR ( 5 ) FOR SBCS DATA WITH DEFAULT NULL ,

“REASON3” VARCHAR ( 5 ) FOR SBCS DATA WITH DEFAULT NULL ,

“REASON4” VARCHAR ( 5 ) FOR SBCS DATA WITH DEFAULT NULL ,

“REASON5” VARCHAR ( 5 ) FOR SBCS DATA WITH DEFAULT NULL ,

“OCC_FROM_DATE” DATE WITH DEFAULT NULL ,

“OCC_TO_DATE” DATE WITH DEFAULT NULL ,

“ALLOWED_AMT” DECIMAL ( 9 , 2 ) WITH DEFAULT NULL ,

“OTH_INS_AMT” DECIMAL ( 9 , 2 ) WITH DEFAULT NULL ,

“PAID_AMT” DECIMAL ( 9 , 2 ) WITH DEFAULT NULL ,

“POSSIBLE_HRA” DECIMAL ( 9 , 2 ) WITH DEFAULT NULL ,

“HRA_EXCLUDE” DECIMAL ( 1 , 0 ) WITH DEFAULT NULL ,

“HRA_AMT” DECIMAL ( 9 , 2 ) WITH DEFAULT NULL ,

“MNC” DECIMAL ( 9 , 2 ) WITH DEFAULT NULL ,

“HRA_TRANS_ID” INTEGER WITH DEFAULT NULL ,

CONSTRAINT “AUD1_ID” PRIMARY KEY

(“AUD1_ID”)

)

IN “FDBHRA”.“FTSPAUD1”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“AUDIT_PRESCRIPTION_ HRA” (

“FAMILY_ID” INTEGER NOT NULL ,

“RELATION_ID” INTEGER NOT NULL ,

“PAT_ID” INTEGER WITH DEFAULT NULL ,

“RX_CLAIM_NBR” DECIMAL ( 15 , 0 ) WITH DEFAULT NULL ,

“RX_CLAIM_NBR_ SEQ” DECIMAL ( 3 , 0 ) WITH DEFAULT NULL ,

“DISPENSE_DATE” DATE WITH DEFAULT NULL ,

“PATIENT_PAY_ AMT” DECIMAL ( 9 , 2 ) WITH DEFAULT NULL ,

“CLAIM_STATUS” VARCHAR ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“HRA_TRANS_ID” INTEGER WITH DEFAULT NULL ,

“TRANSACTION_ AMT” DECIMAL ( 9 , 2 ) WITH DEFAULT NULL ,

“TRANS_STATUS” INTEGER WITH DEFAULT NULL ,

“DESCRIPTION” VARCHAR ( 60 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LASTUPDT” DATE WITH DEFAULT NULL

)

IN “FDBHRA”.“FTSPAUD2”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“BOSS_ONLY_HRA” (

“BOSS_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0 , INCREMENT BY 1 , CACHE 20 ,

MINVALUE - 2147483648 , NO MAXVALUE, CYCLE, NO ORDER ),

“FAMILY_ID” INTEGER WITH DEFAULT NULL ,

“EFFECTIVE_DATE” DATE WITH DEFAULT NULL ,

“TRANSACTION_ AMT” DECIMAL ( 13 , 4 ) WITH DEFAULT NULL ,

“EXPIRATION_DATE” DATE WITH DEFAULT NULL ,

CONSTRAINT “BOSS_ID” PRIMARY KEY

(“BOSS_ID”)

)

IN “FDBHRA”.“FTSBOSSH”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRA_BYPASS_VALUES” (

“TRANS_CODE” INTEGER NOT NULL ,

“DESCRIPTION” VARCHAR ( 60 ) FOR SBCS DATA NOT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL ,

CONSTRAINT “TRANS_CODE” PRIMARY KEY

(“TRANS_CODE”)

)

IN “FDBHRA”.“FTSHRANV”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRA_FUNDING_ AMOUNT” (

“FROM_DATE” DATE NOT NULL ,

“THRU_DATE” DATE NOT NULL ,

“PLANTYPE” CHARACTER ( 8 ) FOR SBCS DATA NOT NULL ,

“COVERAGE” CHARACTER ( 10 ) FOR SBCS DATA NOT NULL ,

“FUND_AMT” DECIMAL ( 13 , 4 ) NOT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL

)

IN “FDBHRA”.“FTSHRAMT”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRA_HOLD” (

“HRA_HOLD_DAYS” INTEGER NOT NULL ,

“LASTUPDT” TIMESTAMP NOT NULL WITH DEFAULT

)

IN “FDBHRA”.“FTSHRAHD”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRA_LIFE_EVENT” (

“EVENT_CODE” CHARACTER ( 2 ) FOR SBCS DATA NOT NULL ,

“ISSUE_CODE” CHARACTER ( 1 ) FOR SBCS DATA NOT NULL ,

“EVENT_DESC” VARCHAR ( 30 ) FOR SBCS DATA NOT NULL ,

“ISSUE_DESC” VARCHAR ( 60 ) FOR SBCS DATA NOT NULL ,

“LIFE_EVENT” CHARACTER ( 3 ) FOR SBCS DATA NOT NULL ,

“LIFE_CHANGE” CHARACTER ( 3 ) FOR SBCS DATA NOT NULL ,

“PRO_RATE_FUNDING” CHARACTER ( 3 ) FOR SBCS DATA NOT NULL ,

“HRQ_ADDL_FUNDING” CHARACTER ( 3 ) FOR SBCS DATA NOT NULL ,

“FORFEIT_BALANCE” CHARACTER ( 3 ) FOR SBCS DATA NOT NULL ,

“BALANCE_AVAILABLE” CHARACTER ( 3 ) FOR SBCS DATA NOT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL

)

IN “FDBHRA”.“FTSHRALE”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRA_REPORTING_ FAMILY_IDS” (

“FAMILY_ID” INTEGER NOT NULL ,

CONSTRAINT “FAMILY_ID” PRIMARY KEY

(“FAMILY_ID”)

)

IN “FDBHRA”.“FTSHRAFI”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRA_STATMENT_ BYPASS” (

“HRA_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0 , INCREMENT BY 1 , CACHE 20 ,

MINVALUE - 2147483648 , NO MAXVALUE, CYCLE, NO ORDER ),

“FAMILY_ID” INTEGER NOT NULL ,

“RELATION_ID” INTEGER NOT NULL ,

“TRANS_CODE” INTEGER NOT NULL ,

“QRT_END_DATE” DATE NOT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL ,

CONSTRAINT “HRA_ID” PRIMARY KEY

(“HRA_ID”)

)

IN “FDBHRA”.“FTSHRANP”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRA_TRANSACTIONS” (

“TRANS_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0 , INCREMENT BY 1 , CACHE 20 ,

MINVALUE - 2147483648 , NO MAXVALUE, CYCLE, NO ORDER ),

“FAMILY_ID” INTEGER NOT NULL ,

“RELATION_ID” SMALLINT NOT NULL ,

“EFFECTIVE_DATE” DATE NOT NULL ,

“TRANSACTION_ TYPE” INTEGER NOT NULL ,

“TRANSACTION_ AMT” DECIMAL ( 13 , 4 ) WITH DEFAULT NULL ,

“TRANSACTION_ DATE” TIMESTAMP NOT NULL ,

“CLAIM_ID” INTEGER WITH DEFAULT NULL ,

“PRESCRIPTION_ NBR” VARCHAR ( 9 ) FOR SBCS DATA WITH DEFAULT NULL ,

“DISPENSE_DATE” DATE WITH DEFAULT NULL ,

“HRA_QUAL_AMT” DECIMAL ( 13 , 4 ) WITH DEFAULT NULL ,

“RX_CLAIM_NBR” DECIMAL ( 15 , 0 ) WITH DEFAULT NULL ,

“RX_CLAIM_NBR_ SEQ” DECIMAL ( 3 , 0 ) WITH DEFAULT NULL ,

“CHECK_NBR” INTEGER WITH DEFAULT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL ,

“USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“LASTUPDT” TIMESTAMP NOT NULL ,

“EXPIRATION_DATE” DATE DEFAULT ‘9999-12-31’ ,

“COMMENTS” VARCHAR ( 1000 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LINE_NBR” SMALLINT WITH DEFAULT NULL ,

“PRINT_SUPPRESS_ SW” DECIMAL ( 1 , 0 ) DEFAULT 0 ,

CONSTRAINT “TRANS_ID” PRIMARY KEY

(“TRANS_ID”)

)

IN “FDBHRA”.“FTSHRATR”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRA_TRANSACTION_ TYPES” (

“TRANSACTION_ TYPE” SMALLINT NOT NULL ,

“TRANSACTION_ DESCRIPTION” VARCHAR ( 150 ) FOR SBCS DATA NOT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL ,

“PROCESS_DESCRIPTION” VARCHAR ( 500 ) FOR SBCS DATA WITH DEFAULT NULL ,

“TRANSACTION_ TYPE_USEDBY” INTEGER DEFAULT 0 ,

“FUNDING_TYPE” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

CONSTRAINT “TRANSACTION_ TYPE” PRIMARY KEY

(“TRANSACTION_ TYPE”)

)

IN “FDBHRA”.“FTSHRATP”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

COMMENT ON “FDBHRA”.“HRA_TRANSACTION_ TYPES” (

“TRANSACTION_ TYPE_USEDBY” IS ‘Indicates if this Transaction is for System use
(Tri State NULL = Both, 0 = System Only, 1 = User)’ ) ;

CREATE TABLE “FDBHRA”.“HRA_TRANSIENT_ DATA” (

“TRANS_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0 , INCREMENT BY 1 , CACHE 20 ,

MINVALUE - 2147483648 , NO MAXVALUE, CYCLE, NO ORDER ),

“FAMILY_ID” INTEGER NOT NULL ,

“RELATION_ID” SMALLINT NOT NULL ,

“EFFECTIVE_DATE” DATE NOT NULL ,

“EVENT_DATE” DATE NOT NULL ,

“TRANS_CODE” CHARACTER ( 3 ) FOR SBCS DATA NOT NULL ,

“MEMTYPE” CHARACTER ( 3 ) FOR SBCS DATA NOT NULL ,

“PROCESS_STATUS” VARCHAR ( 20 ) FOR SBCS DATA NOT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL ,

“BATCH_USERID” VARCHAR ( 40 ) FOR SBCS DATA WITH DEFAULT NULL ,

“BATCH_DATE” TIMESTAMP WITH DEFAULT NULL ,

“ONLINE_USERID” VARCHAR ( 40 ) FOR SBCS DATA WITH DEFAULT NULL ,

“ONLINE_DATE” TIMESTAMP WITH DEFAULT NULL ,

CONSTRAINT “TRANS_ID” PRIMARY KEY

(“TRANS_ID”)

)

IN “FDBHRA”.“FTSHRATS”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRA_TRIGGER_ EVENT_XREF” (

“TRIGGER_ID” CHARACTER ( 3 ) FOR SBCS DATA NOT NULL ,

“TRIGGER_DESC” VARCHAR ( 60 ) FOR SBCS DATA NOT NULL ,

“EVENT_CODE” CHARACTER ( 2 ) FOR SBCS DATA NOT NULL ,

“ISSUE_CODE” CHARACTER ( 1 ) FOR SBCS DATA NOT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL ,

“MANUAL_USE_SW” DECIMAL ( 1 , 0 ) NOT NULL WITH DEFAULT

)

IN “FDBHRA”.“FTSHRATE”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRQ_FUNDING_ AMOUNT” (

“FROM_DATE” DATE NOT NULL ,

“THRU_DATE” DATE NOT NULL ,

“PLANTYPE” CHARACTER ( 8 ) FOR SBCS DATA NOT NULL ,

“FUNDTYPE” CHARACTER ( 15 ) FOR SBCS DATA NOT NULL ,

“RELTYPE” CHARACTER ( 1 ) FOR SBCS DATA NOT NULL ,

“FUND_AMT” DECIMAL ( 13 , 4 ) NOT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL

)

IN “FDBHRA”.“FTSHRQAM”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRQ_IN” (

“HRQ_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0 , INCREMENT BY 1 , CACHE 20 ,

MINVALUE - 2147483648 , NO MAXVALUE, CYCLE, NO ORDER ),

“FAMILY_ID” INTEGER NOT NULL ,

“RELATION_ID” INTEGER NOT NULL ,

“FIRST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LAST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“RELATION” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“RECEIVE_DATE” DATE WITH DEFAULT NULL ,

“EFFECTIVE_DATE” DATE WITH DEFAULT NULL ,

“MEMTYPE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“PROCESS_STATUS” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“LASTUPDT” TIMESTAMP NOT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL WITH DEFAULT ,

“CREATE_DATE” TIMESTAMP NOT NULL WITH DEFAULT ,

“DATE_FIRST_SENT” DATE DEFAULT ‘9999-12-31’ ,

“DEADLINE_DATE” DATE DEFAULT ‘9999-12-31’ ,

CONSTRAINT “HRQ_ID” PRIMARY KEY

(“HRQ_ID”)

)

IN “FDBHRA”.“FTSHRQIN”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRQ_IN_LATE” (

“HRQ_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0 , INCREMENT BY 1 , CACHE 20 ,

MINVALUE - 2147483648 , NO MAXVALUE, CYCLE, NO ORDER ),

“FAMILY_ID” INTEGER NOT NULL ,

“RELATION_ID” INTEGER NOT NULL ,

“FIRST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LAST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“RELATION” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“RECEIVE_DATE” DATE WITH DEFAULT NULL ,

“EFFECTIVE_DATE” DATE WITH DEFAULT NULL ,

“MEMTYPE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“PROCESS_STATUS” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“LASTUPDT” TIMESTAMP NOT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL ,

“DATE_FIRST_SENT” DATE NOT NULL ,

“DEADLINE_DATE” DATE NOT NULL ,

CONSTRAINT “HRQ_ID” PRIMARY KEY

(“HRQ_ID”)

)

IN “FDBHRA”.“FTSHRQIL”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRQ_OUT” (

“HRQ_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0 , INCREMENT BY 1 , CACHE 20 ,

MINVALUE - 2147483648 , NO MAXVALUE, CYCLE, NO ORDER ),

“HRQ_STATUS” CHARACTER ( 1 ) FOR SBCS DATA NOT NULL ,

“FIRST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LAST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MIDDLE_INITIAL” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“COMPANY_NAME” VARCHAR ( 50 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STREET1” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STREET2” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“CITY” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STATE” VARCHAR ( 10 ) FOR SBCS DATA WITH DEFAULT NULL ,

“ZIP” INTEGER WITH DEFAULT NULL ,

“COUNTRY” VARCHAR ( 15 ) FOR SBCS DATA WITH DEFAULT NULL ,

“FAMILY_ID” INTEGER NOT NULL ,

“RELATION_ID” INTEGER NOT NULL ,

“MARITAL_STATUS” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“GENDER” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“BIRTH_DATE” VARCHAR ( 8 ) FOR SBCS DATA WITH DEFAULT NULL ,

“RELATION” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LOCALNO” INTEGER WITH DEFAULT NULL ,

“EMPLOYER_NAME” VARCHAR ( 255 ) FOR SBCS DATA WITH DEFAULT NULL ,

“COVERAGE_LEVEL” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“PLANTYPE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MEMTYPE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“HA_ELIGIBLE” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MEM_STATUS” VARCHAR ( 255 ) FOR SBCS DATA WITH DEFAULT NULL ,

“DUAL_COVERAGE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“SSNO” INTEGER WITH DEFAULT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL ,

“BATCH_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“BATCH_DATE” TIMESTAMP NOT NULL ,

“DATE_FIRST_SENT” DATE WITH DEFAULT NULL ,

“DEADLINE_DATE” DATE WITH DEFAULT NULL ,

“CREATE_DATE_ 2” DATE WITH DEFAULT NULL ,

CONSTRAINT “HRQ_ID” PRIMARY KEY

(“HRQ_ID”)

)

IN “FDBHRA”.“FTSHRQOT”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRQ_OUT2” (

“HRQ_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0 , INCREMENT BY 1 , CACHE 20 ,

MINVALUE - 2147483648 , NO MAXVALUE, CYCLE, NO ORDER ),

“HRQ_STATUS” CHARACTER ( 1 ) FOR SBCS DATA NOT NULL ,

“FIRST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LAST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MIDDLE_INITIAL” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“COMPANY_NAME” VARCHAR ( 50 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STREET1” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STREET2” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“CITY” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STATE” VARCHAR ( 10 ) FOR SBCS DATA WITH DEFAULT NULL ,

“ZIP” INTEGER WITH DEFAULT NULL ,

“COUNTRY” VARCHAR ( 15 ) FOR SBCS DATA WITH DEFAULT NULL ,

“FAMILY_ID” INTEGER NOT NULL ,

“RELATION_ID” INTEGER NOT NULL ,

“MARITAL_STATUS” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“GENDER” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“BIRTH_DATE” VARCHAR ( 8 ) FOR SBCS DATA WITH DEFAULT NULL ,

“RELATION” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LOCALNO” INTEGER WITH DEFAULT NULL ,

“EMPLOYER_NAME” VARCHAR ( 255 ) FOR SBCS DATA WITH DEFAULT NULL ,

“COVERAGE_LEVEL” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“PLANTYPE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MEMTYPE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“HA_ELIGIBLE” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MEM_STATUS” VARCHAR ( 255 ) FOR SBCS DATA WITH DEFAULT NULL ,

“DUAL_COVERAGE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“SSNO” INTEGER WITH DEFAULT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL ,

“BATCH_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“BATCH_DATE” TIMESTAMP NOT NULL ,

CONSTRAINT “HRQ_ID” PRIMARY KEY

(“HRQ_ID”)

)

IN “FDBHRA”.“FTSHRQO2”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRQ_OUT2_OLD” (

“HRQ_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0 , INCREMENT BY 1 , CACHE 20 ,

MINVALUE - 2147483648 , NO MAXVALUE, CYCLE, NO ORDER ),

“HRQ_STATUS” CHARACTER ( 1 ) FOR SBCS DATA NOT NULL ,

“FIRST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LAST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MIDDLE_INITIAL” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“COMPANY_NAME” VARCHAR ( 50 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STREET1” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STREET2” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“CITY” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STATE” VARCHAR ( 10 ) FOR SBCS DATA WITH DEFAULT NULL ,

“ZIP” INTEGER WITH DEFAULT NULL ,

“COUNTRY” VARCHAR ( 15 ) FOR SBCS DATA WITH DEFAULT NULL ,

“FAMILY_ID” INTEGER NOT NULL ,

“RELATION_ID” INTEGER NOT NULL ,

“MARITAL_STATUS” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“GENDER” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“BIRTH_DATE” VARCHAR ( 8 ) FOR SBCS DATA WITH DEFAULT NULL ,

“RELATION” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LOCALNO” INTEGER WITH DEFAULT NULL ,

“EMPLOYER_NAME” VARCHAR ( 255 ) FOR SBCS DATA WITH DEFAULT NULL ,

“COVERAGE_LEVEL” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“PLANTYPE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MEMTYPE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“HA_ELIGIBLE” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MEM_STATUS” VARCHAR ( 255 ) FOR SBCS DATA WITH DEFAULT NULL ,

“DUAL_COVERAGE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“SSNO” INTEGER WITH DEFAULT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL ,

“BATCH_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“BATCH_DATE” TIMESTAMP NOT NULL ,

CONSTRAINT “HRQ_ID” PRIMARY KEY

(“HRQ_ID”)

)

IN “FDBHRA”.“FSTHRQO2”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRQ_OUT_HEADER” (

“HRQ_YEAR” INTEGER NOT NULL ,

“MIN_HRQ_ID” INTEGER NOT NULL ,

“FIRST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LAST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MIDDLE_INITIAL” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“COMPANY_NAME” VARCHAR ( 50 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STREET1” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STREET2” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“CITY” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STATE” VARCHAR ( 10 ) FOR SBCS DATA WITH DEFAULT NULL ,

“ZIP” INTEGER WITH DEFAULT NULL ,

“COUNTRY” VARCHAR ( 15 ) FOR SBCS DATA WITH DEFAULT NULL ,

“FAMILY_ID” INTEGER NOT NULL ,

“RELATION_ID” INTEGER NOT NULL ,

“MARITAL_STATUS” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“GENDER” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“BIRTH_DATE” VARCHAR ( 8 ) FOR SBCS DATA WITH DEFAULT NULL ,

“RELATION” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LOCALNO” INTEGER WITH DEFAULT NULL ,

“EMPLOYER_NAME” VARCHAR ( 255 ) FOR SBCS DATA WITH DEFAULT NULL ,

“COVERAGE_LEVEL” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“PLANTYPE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MEMTYPE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“HA_ELIGIBLE” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MEM_STATUS” VARCHAR ( 255 ) FOR SBCS DATA WITH DEFAULT NULL ,

“DUAL_COVERAGE” VARCHAR ( 25 ) FOR SBCS DATA WITH DEFAULT NULL ,

“SSNO” INTEGER WITH DEFAULT NULL ,

“CREATE_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“CREATE_DATE” TIMESTAMP NOT NULL ,

“BATCH_USERID” VARCHAR ( 40 ) FOR SBCS DATA NOT NULL ,

“BATCH_DATE” TIMESTAMP NOT NULL ,

“DATE_FIRST_SENT” DATE WITH DEFAULT NULL ,

“DEADLINE_DATE” DATE WITH DEFAULT NULL ,

“CREATE_DATE_ 2” DATE WITH DEFAULT NULL ,

CONSTRAINT “HRQ_YEAR” PRIMARY KEY

(“HRQ_YEAR”, “MIN_HRQ_ID”)

)

IN “FDBHRA”.“FTSHRQOH”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC ;

CREATE TABLE “FDBHRA”.“HRQ_OUT_OLD” (

“HRQ_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0 , INCREMENT BY 1 , CACHE 20 ,

MINVALUE - 2147483648 , NO MAXVALUE, CYCLE, NO ORDER ),

“HRQ_STATUS” CHARACTER ( 1 ) FOR SBCS DATA NOT NULL ,

“FIRST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“LAST_NAME” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“MIDDLE_INITIAL” CHARACTER ( 1 ) FOR SBCS DATA WITH DEFAULT NULL ,

“COMPANY_NAME” VARCHAR ( 50 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STREET1” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“STREET2” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

“CITY” VARCHAR ( 30 ) FOR SBCS DATA WITH DEFAULT NULL ,

"STAT
image002.jpeg


#2

Mark,

I’m currently looking into this issue and will get back to you soon.

— On Fri, 1/29/10, Stone, Mark wrote:

Mark,

I’m currently looking into this issue and will get back to you soon.

— On Fri, 1/29/10, Stone, Mark wrote:
image002.jpeg


#3

Mark,

I’m currently looking into this issue and will get back to you soon.

— On Fri, 1/29/10, Stone, Mark wrote:

Mark,

I’m currently looking into this issue and will get back to you soon.

— On Fri, 1/29/10, Stone, Mark wrote:
image003.jpeg


#4

Mark,

A couple of questions.

Is the subsystem in question z/OS V9?

If so were the missing procedures Native SQL procedures?

— On Fri, 1/29/10, Stone, Mark wrote:

Mark,

A couple of questions.

Is the subsystem in question z/OS V9?

If so were the missing procedures Native SQL procedures?

— On Fri, 1/29/10, Stone, Mark wrote:
image003.jpeg


#5

Mark,

A couple of questions.

Is the subsystem in question z/OS V9?

If so were the missing procedures Native SQL procedures?

— On Fri, 1/29/10, Stone, Mark wrote:

Mark,

A couple of questions.

Is the subsystem in question z/OS V9?

If so were the missing procedures Native SQL procedures?

— On Fri, 1/29/10, Stone, Mark wrote:
image002.jpeg


#6

Yes, DB2 9, and yes Native, 95% of my SP’s are native at this point to
take advantage of the zip
image003.jpeg


#7

Yes, DB2 9, and yes Native, 95% of my SP’s are native at this point to
take advantage of the zip
image002.jpeg


#8

Mark,

I think that explains it. We do not yet have full support for z/OS V9 Native SQL Procedures in Toad for DB2 V4.6. This effort is scheduled for Toad for DB2 V5.0.

— On Mon, 2/1/10, Stone, Mark wrote:

Mark,

I think that explains it. We do not yet have full support for z/OS V9 Native SQL
Procedures in Toad for DB2 V4.6. This effort is scheduled for Toad for DB2 V5.0.

— On Mon, 2/1/10, Stone, Mark wrote:
image002.jpeg


#9

Mark,

I think that explains it. We do not yet have full support for z/OS V9 Native SQL Procedures in Toad for DB2 V4.6. This effort is scheduled for Toad for DB2 V5.0.

— On Mon, 2/1/10, Stone, Mark wrote:

Mark,

I think that explains it. We do not yet have full support for z/OS V9 Native SQL
Procedures in Toad for DB2 V4.6. This effort is scheduled for Toad for DB2 V5.0.

— On Mon, 2/1/10, Stone, Mark wrote:
image003.jpeg


#10

Helene, that’s really a huge disappointment, DB2 9 is hardly new at this
point and I asked a question earlier in the beta about DB2 9 support, the
response being “Yes” we do.

IMHO, it would be more valuable for full DB2 v9 support to be implemented in
Toad, than meaningless enhancements like color coding tabs.

Mark.
image003.jpeg


#11

Helene, that’s really a huge disappointment, DB2 9 is hardly new at this
point and I asked a question earlier in the beta about DB2 9 support, the
response being “Yes” we do.

IMHO, it would be more valuable for full DB2 v9 support to be implemented in
Toad, than meaningless enhancements like color coding tabs.

Mark.
image002.jpeg


#12

Hi,

I can’t help but agree with Mark. There seems to be too little emphasis on
adding stuff that would be really useful to developers such as full support for
9.7 features and functionality. It has been the same in the past - look how long
it has taken to get the debugger to work properly. Perhaps you could publish
your roadmap for forthcoming releases and what is scheduled for each release.

Regards,

John.


#13

John,

Thank you for your comments. We really do appreciate them and take them very
seriously. Our product manager would be the appropriate responder to these
concerns and he is currently on vacation until next week. I’m sure he will take
up this issue as soon as he returns.

— On Wed, 2/3/10, el28787 wrote:


#14

Hello Helen!

And i to agreed with Mark and John.

Could you advice me in which cases Toad do not supported sp? On z/OS and on LUW?

2010/2/3 Helene Rantz

John,

Thank you for your comments. We really do appreciate them and take them very
seriously. Our product manager would be the appropriate responder to these
concerns and he is currently on vacation until next week. I'm sure he
will take up this issue as soon as he returns.

--- On Wed, 2/3/10, el28787 wrote:

#15

Support is incomplete for Native SQL procedures which are new in z/OS V9 and
PL/SQL procedure which are new in LUW V9.7. We expect to complete this support
early in the Toad for DB2 V5.0 Beta cycle.

— On Thu, 2/4/10, Danny Utro wrote: