iSeries – AES field level encryption.
I have a need to encrypt 1 field in a file that I’m sending outside the company. I know the file level encryption, but have never dealt with Field level. Is it possible to have AES field level? Possible without purchasing a package? iSeries V5R4M0. Any Help would be greatly appreciated!

Answer Question   |  November 6, 2012  1:27 PM
aes, AS/400, iSeries files, iSeries V5R4MO

Retreving source file names of a library
Hi guys, I need to copy all the objects(both DB file and PGM) from a library to another library except the source file(PF-SRC). I tried DSPFD FILE([file library]/*ALL) TYPE(*BASATR) OUTPUT(*OUTFILE) OUTFILE([outfile library]/[outfile]) then selecting those records where ATDTAT = ‘S’. But the outfile consists of only DB files. But I need RPGLE/CLLE program names also. [...]

Answer Question   |  October 8, 2012  9:20 AM
CLLE, iSeries V5R4MO

How to define a CLOB in SQLRPGLE Stored Procedure
Trying to use SQLRPGLE to create a Stored procedure. When I use a data type of CLOB (OUT: XMLDATA CLOB (64 K)) I get SQL0451 error (Attributes of parameter 9 not valid for procedure or function AVSESPLOAD in *N) Can anyone tell me what I should be doing. I need to define a 64K output [...]

Answer Question   |  March 17, 2012  1:11 PM
iSeries RPG programming, iSeries V5R4MO