****************************************************************** * DCLGEN TABLE(LED_PROJECTS) * * LIBRARY(OAAMS.DWUNIT.DCLGEN(ODWTS066)) * * ACTION(REPLACE) * * LANGUAGE(COBOL) * * NAMES(TS066-) * * STRUCTURE(LED-PROJECTS) * * QUOTE * * DBCSDELIM(NO) * * COLSUFFIX(YES) * * ... IS THE DCLGEN COMMAND THAT MADE THE FOLLOWING STATEMENTS * ****************************************************************** EXEC SQL DECLARE LED_PROJECTS TABLE ( INT_LED_KEY CHAR(12) NOT NULL, TRANS_CODE CHAR(2) NOT NULL, TRANS_NUM_AGCY CHAR(3) NOT NULL, TRANS_NUM_NUM CHAR(11) NOT NULL, ACCEPTANCE_DATE CHAR(8) NOT NULL, FISC_YEAR CHAR(4) NOT NULL, FISC_QUARTER CHAR(1) NOT NULL, FISC_MONTH CHAR(2) NOT NULL, BUDGET_FISC_YEAR CHAR(4) NOT NULL, PROJECT_5 CHAR(5) NOT NULL, SUB_PROJECT CHAR(2) NOT NULL, PHASE CHAR(1) NOT NULL, FUND CHAR(4) NOT NULL, AGENCY CHAR(3) NOT NULL, ORGANIZATION CHAR(4) NOT NULL, SUB_ORG CHAR(2) NOT NULL, APPR_UNIT CHAR(9) NOT NULL, ACTIVITY CHAR(4) NOT NULL, OBJECT CHAR(4) NOT NULL, SUB_OBJECT CHAR(2) NOT NULL, FUNCTION CHAR(4) NOT NULL, ACCOUNT_TYPE CHAR(2) NOT NULL, CHARGE_CLS_OBLPGM CHAR(4) NOT NULL, CHARGE_UNITS DECIMAL(7, 2) NOT NULL, PROJECTS_AMT DECIMAL(15, 2) NOT NULL, LINE_ACTION CHAR(1) NOT NULL, DOC_ACTION CHAR(1) NOT NULL, DOC_DESC CHAR(12) NOT NULL, RECORD_DATE CHAR(8) NOT NULL ) END-EXEC. ****************************************************************** * COBOL DECLARATION FOR TABLE LED_PROJECTS * ****************************************************************** 01 LED-PROJECTS. * INT_LED_KEY 10 TS066-INT-LED-KEY PIC X(12). * TRANS_CODE 10 TS066-TRANS-CODE PIC X(2). * TRANS_NUM_AGCY 10 TS066-TRANS-NUM-AGCY PIC X(3). * TRANS_NUM_NUM 10 TS066-TRANS-NUM-NUM PIC X(11). * ACCEPTANCE_DATE 10 TS066-ACCEPTANCE-DATE PIC X(8). * FISC_YEAR 10 TS066-FISC-YEAR PIC X(4). * FISC_QUARTER 10 TS066-FISC-QUARTER PIC X(1). * FISC_MONTH 10 TS066-FISC-MONTH PIC X(2). * BUDGET_FISC_YEAR 10 TS066-BUDGET-FISC-YEAR PIC X(4). * PROJECT_5 10 TS066-PROJECT-5 PIC X(5). * SUB_PROJECT 10 TS066-SUB-PROJECT PIC X(2). * PHASE 10 TS066-PHASE PIC X(1). * FUND 10 TS066-FUND PIC X(4). * AGENCY 10 TS066-AGENCY PIC X(3). * ORGANIZATION 10 TS066-ORGANIZATION PIC X(4). * SUB_ORG 10 TS066-SUB-ORG PIC X(2). * APPR_UNIT 10 TS066-APPR-UNIT PIC X(9). * ACTIVITY 10 TS066-ACTIVITY PIC X(4). * OBJECT 10 TS066-OBJECT PIC X(4). * SUB_OBJECT 10 TS066-SUB-OBJECT PIC X(2). * FUNCTION 10 TS066-FUNCTION PIC X(4). * ACCOUNT_TYPE 10 TS066-ACCOUNT-TYPE PIC X(2). * CHARGE_CLS_OBLPGM 10 TS066-CHARGE-CLS-OBLPGM PIC X(4). * CHARGE_UNITS 10 TS066-CHARGE-UNITS PIC S9(5)V9(2) USAGE COMP-3. * PROJECTS_AMT 10 TS066-PROJECTS-AMT PIC S9(13)V9(2) USAGE COMP-3. * LINE_ACTION 10 TS066-LINE-ACTION PIC X(1). * DOC_ACTION 10 TS066-DOC-ACTION PIC X(1). * DOC_DESC 10 TS066-DOC-DESC PIC X(12). * RECORD_DATE 10 TS066-RECORD-DATE PIC X(8). ****************************************************************** * THE NUMBER OF COLUMNS DESCRIBED BY THIS DECLARATION IS 29 * ******************************************************************