CCCHECK

The Credit Card Check table stores the length and prefix of credit cards. This information is used by the default CheckCCNumber task command to help determine the validity of the credit card number. Initially, the CCCHECK table is empty. If no entry is found in the table for the credit card brand, the default CheckCCNumber task command calls the DoLuhnCheck task command.

Column Descriptions:

NameTypeDescription
CCRFNBRINTEGER NOT NULLThis is the primary key. The combination of CCTYPE, CCLENGTH and CCPREFIX must be unique.
CCTYPEVARCHAR (40) NOT NULLThe credit card brand. This is a case-sensitive string and is used as a search key for a query to this table.
CCLENGTHINTEGER NOT NULLThis is the credit card number length.
CCPREFIXCHAR (16) NOT NULLThis is the credit card prefix.
CCALGTASKRNVARCHAR (256)The task command interface name called by the default CheckCCNumber task command after passing the length and prefix check. It will perform an algorithmic check of the credit card number. Example: com.ibm.commerce.payment.commands.DoLuhnCheckCmd
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CCRFNBRPrimary Key
I0000069CCTYPE+CCLENGTH+CCPREFIXUnique Index