DB2 tableCARDDEMO.AUTHFRDS
Who touches it
Definition
CARDDEMO.AUTHFRDS AUTHFRDS.ddl:1
| CARD_NUM | CHAR(16) NOT NULL |
| AUTH_TS | TIMESTAMP NOT NULL |
| AUTH_TYPE | CHAR(4) |
| CARD_EXPIRY_DATE | CHAR(4) |
| MESSAGE_TYPE | CHAR(6) |
| MESSAGE_SOURCE | CHAR(6) |
| AUTH_ID_CODE | CHAR(6) |
| AUTH_RESP_CODE | CHAR(2) |
| AUTH_RESP_REASON | CHAR(4) |
| PROCESSING_CODE | CHAR(6) |
| TRANSACTION_AMT | DECIMAL(12,2) |
| APPROVED_AMT | DECIMAL(12,2) |
| MERCHANT_CATAGORY_CODE | CHAR(4) |
| ACQR_COUNTRY_CODE | CHAR(3) |
| POS_ENTRY_MODE | SMALLINT |
| MERCHANT_ID | CHAR(15) |
| MERCHANT_NAME | VARCHAR(22) |
| MERCHANT_CITY | CHAR(13) |
| MERCHANT_STATE | CHAR(02) |
| MERCHANT_ZIP | CHAR(09) |
| TRANSACTION_ID | CHAR(15) |
| MATCH_STATUS | CHAR(1) |
| AUTH_FRAUD | CHAR(1) |
| FRAUD_RPT_DATE | DATE |
| ACCT_ID | DECIMAL(11) |
| CUST_ID | DECIMAL(9) |
Statements
| COPAUS2C MAIN-PARA | INSERT | INSERT INTO CARDDEMO.AUTHFRDS (CARD_NUM ,AUTH_TS ,AUTH_TYPE ,CARD_EXPIRY_DATE ,MESSAGE_TYPE ,MESSAGE_SOURCE ,AUTH_ID_CODE ,AUTH_RESP_CODE ,AUTH_RESP_REASON ,PROCESSING_CODE ,TRANSACTION_AMT ,APPROVED_AMT ,MERCHANT_CATAGORY_CODE ,ACQR_COUNTRY_CODE ,POS_ENTRY_MODE ,MERCHANT_ID ,MERCHANT_NAME ,MERCHANT_CITY ,MERCHANT_STATE ,MERCHANT_ZIP ,TRANSACTION_ID ,MATCH_STATUS ,AUTH_FRAUD ,FRAUD_RPT_DATE ,ACCT_ | COPAUS2C.cbl:141–198 |
| COPAUS2C FRAUD-UPDATE | UPDATE | UPDATE CARDDEMO.AUTHFRDS SET AUTH_FRAUD = :AUTH-FRAUD FRAUD_RPT_DATE = CURRENT DATE WHERE CARD_NUM = :CARD-NUM AND AUTH_TS = TIMESTAMP_FORMAT (:AUTH-TS 'YY-MM-DD HH24.MI.SSNNNNNN') | COPAUS2C.cbl:222–229 |
| COPAUS2C (DATA DIVISION) | DECLARE TABLE | DECLARE CARDDEMO.AUTHFRDS TABLE ( CARD_NUM CHAR(16) NOT NULL AUTH_TS TIMESTAMP NOT NULL AUTH_TYPE CHAR(4) CARD_EXPIRY_DATE CHAR(4) MESSAGE_TYPE CHAR(6) MESSAGE_SOURCE CHAR(6) AUTH_ID_CODE CHAR(6) AUTH_RESP_CODE CHAR(2) AUTH_RESP_REASON CHAR(4) PROCESSING_CODE CHAR(6) TRANSACTION_AMT DECIMAL(12 2) APPROVED_AMT DECIMAL(12 2) MERCHANT_CATAGORY_CODE CHAR(4) ACQR_COUNTRY_CODE CHAR(3) POS_ENTRY_MODE SMA | AUTHFRDS.dcl:24–51 via COPAUS2C.cbl:68 |