****************************************************************** * DCLGEN TABLE(ODWOWN01.LED_APPROPRIATIONS) * * LIBRARY(OAAMS.DWUNIT.DCLGEN(ODWTS083)) * * ACTION(REPLACE) * * LANGUAGE(COBOL) * * NAMES(TS083-) * * STRUCTURE(LED-APPROPRIATIONS) * * QUOTE * * DBCSDELIM(NO) * * COLSUFFIX(YES) * * ... IS THE DCLGEN COMMAND THAT MADE THE FOLLOWING STATEMENTS * ****************************************************************** EXEC SQL DECLARE LED_APPROPRIATIONS 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, FUND CHAR(4) NOT NULL, AGENCY CHAR(3) NOT NULL, APPR_UNIT CHAR(9) NOT NULL, LINE_ACTION CHAR(1) NOT NULL, ACCOUNT_TYPE CHAR(2) NOT NULL, APPR_ORIG_AMT DECIMAL(15, 2) NOT NULL, REVERTED_AMT DECIMAL(15, 2) NOT NULL, APPR_TR_IN_AMT DECIMAL(15, 2) NOT NULL, APPR_TR_OUT_AMT DECIMAL(15, 2) NOT NULL, DEBIT_CREDIT_IND CHAR(1) NOT NULL, REVRT_BEG_CASH_IND CHAR(1) NOT NULL, RESTRICTED_AMT DECIMAL(15, 2) NOT NULL ) END-EXEC. ****************************************************************** * COBOL DECLARATION FOR TABLE ODWOWN01.LED_APPROPRIATIONS * ****************************************************************** 01 LED-APPROPRIATIONS. * INT_LED_KEY 10 TS083-INT-LED-KEY PIC X(12). * TRANS_CODE 10 TS083-TRANS-CODE PIC X(2). * TRANS_NUM_AGCY 10 TS083-TRANS-NUM-AGCY PIC X(3). * TRANS_NUM_NUM 10 TS083-TRANS-NUM-NUM PIC X(11). * ACCEPTANCE_DATE 10 TS083-ACCEPTANCE-DATE PIC X(8). * FISC_YEAR 10 TS083-FISC-YEAR PIC X(4). * FISC_QUARTER 10 TS083-FISC-QUARTER PIC X(1). * FISC_MONTH 10 TS083-FISC-MONTH PIC X(2). * BUDGET_FISC_YEAR 10 TS083-BUDGET-FISC-YEAR PIC X(4). * FUND 10 TS083-FUND PIC X(4). * AGENCY 10 TS083-AGENCY PIC X(3). * APPR_UNIT 10 TS083-APPR-UNIT PIC X(9). * LINE_ACTION 10 TS083-LINE-ACTION PIC X(1). * ACCOUNT_TYPE 10 TS083-ACCOUNT-TYPE PIC X(2). * APPR_ORIG_AMT 10 TS083-APPR-ORIG-AMT PIC S9(13)V9(2) USAGE COMP-3. * REVERTED_AMT 10 TS083-REVERTED-AMT PIC S9(13)V9(2) USAGE COMP-3. * APPR_TR_IN_AMT 10 TS083-APPR-TR-IN-AMT PIC S9(13)V9(2) USAGE COMP-3. * APPR_TR_OUT_AMT 10 TS083-APPR-TR-OUT-AMT PIC S9(13)V9(2) USAGE COMP-3. * DEBIT_CREDIT_IND 10 TS083-DEBIT-CREDIT-IND PIC X(1). * REVRT_BEG_CASH_IND 10 TS083-REVRT-BEG-CASH-IND PIC X(1). * RESTRICTED_AMT 10 TS083-RESTRICTED-AMT PIC S9(13)V9(2) USAGE COMP-3. ****************************************************************** * THE NUMBER OF COLUMNS DESCRIBED BY THIS DECLARATION IS 21 * ******************************************************************