Hi do a sample program SQLRPGLE,
it has to clear some record from a dds where the user is "DUFFYDUCK".
It works, it doesn't give me any error, but it doesn't delete these record.
There will be something I don't know to do before using SQLRPGLE..
DPUSER S 10A INZ('DUFFYDUCK')
C* CLEAR FROM CLCINV USER'S RECORDS
C EVAL PUSER='DUFFYDUCK'
C+ DELETE FROM CLCINV WHERE USER = :PUSER
C SETON LR