ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

query behavior with encryption and FIELDPROC

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • query behavior with encryption and FIELDPROC

    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)

Working...
X