bankmast is the encrypted file - pool# is the encrypted column...
how come this returns results...
select * from ldataj08/bankmast
where pool# = 357560
but this won't?
select pool# from ldataj08/bankmast
where pool# = 357560
yes, if i do the following, the first query works... but what does it matter whether i select all columns or just the encrypted column?
update ls#jhv/qaqqini set qqval = '*ALL'
where qqparm = 'FIELDPROC_ENCODED_COMPARISON'
CHGQRYA QRYOPTLIB(LS#JHV)
how come this returns results...
select * from ldataj08/bankmast
where pool# = 357560
but this won't?
select pool# from ldataj08/bankmast
where pool# = 357560
yes, if i do the following, the first query works... but what does it matter whether i select all columns or just the encrypted column?
update ls#jhv/qaqqini set qqval = '*ALL'
where qqparm = 'FIELDPROC_ENCODED_COMPARISON'
CHGQRYA QRYOPTLIB(LS#JHV)