RE: Regarding Decryption of AES128 encrypted data in RPGLE and query regarding CRC 32

System value QCCSID is, well, a system value and not a job value. Your job value defaults to this system value but it can be overridden.
Multiple choices.
My first choice is to change QCCSID to something other than 65535. Once you restart your job then it will use this new value. I realize that some people have a paranoia to changing a system value. However I changed this on our main production server midday with no bad issues. YMMV. Running CHGJOB will NOT change the system value QCCSID. Perhaps you come from another operating system so I'll try to translate to another lingo. Compare it to system versus job environment variables.
Second choice is to change your user profile. Type in DSPUSRPRF USRPRF(your user id). Record the value for " Coded character set identifier". It's way down the list. My value is set to *SYSVAL. *SYSVAL says to get it from QCCSID. If you cannot get a consensus on changing the system value then request that your user id gets changed to another value. You will have to log off and on again to get your 5250 job to use this new value.
Third choice is to run the CHGJOB each and every time that job starts.
Fourth choice is to redesign all your tables. When you use CREATE TABLE specify a CCSID on each character column.
Fifth choice is to use the CHAR function to assign a CCSID. CHAR(variablename, length, ccsid). Sample:
select cmpnam, char(cmpnam, 30, 37),
encrypt_aes(char(cmpnam, 30, 37), 'sampleencryption')
from erplxf.rco;

Only the first choice is in order in 'my' order of preference. After that you can do whatever you prefer.

See also:
select column_name, CCSID, DATA_TYPE, LENGTH, NUMERIC_SCALE
from qsys2.syscolumns
where table_name='RCO' and table_schema='ERPLXF'
;

Rob Berendt