On an AS/400, I need to add a column to an existing DDS-defined physical file to hold an encrypted credit-card number. Unfortunately, I cannot change this one into SQL-defined.
If this was an SQL-defined table, I'd simply add the "FOR BIT DATA" qualifier to the column definition so it could hold the encrypted data.
encryptedCreditCard char(32) for bit data
But, since this table is DDS-defined, how do I add the "FOR BIT DATA" portion to the column? I've searched the manuals, but I must be missing it.
Thanks in advance!
A R RSTUFF
A ENCCCARD 32 COLHDG('ENC CREDIT CARD #')