I am trying to query a PF to get back all records where fields OWNER1 and OWNER2 have an entered user value (ie; JOHN - I would want to return JOHN, JOHNATHON, JOHNS, ARJOHNS, etc)
The best so far I have been able to come up with is:
DCL VAR(&CF03) TYPE(*CHAR)
DCL VAR(&INOWN) TYPE(*CHAR) LEN(10)
DCL VAR(&OWNX) TYPE(*CHAR)LEN(15)
DCLF FILE(NJCF/CON050FM) RCDFMT(SCRN01)
CHGVAR VAR(&OWNX)VALUE(&INOWN *cat '*')
OVRDBF FILE(CONNAM)TOFILE(TEST/CONNAM) SHARE(*YES)
OPNQRYF FILE((TEST/CONNAM)) QRYSLT(' +
OWNER1 *EQ %WLDCRD (''*CAT &OWNX *CAT'') ')
But I still cannot get the syntax right.
I hope someone can show me what I am doing wrong or if there is a better way.
October 23, 2008 2:07 PM
October 24, 2008 6:59 PM