Mark Lazarus wrote: > 1) If DBFLD is defined as 4 alpha and WRKFLD is 2 alpha, but the right 2 > positions are always blank (i.e. DBFLD = 'ZZ ' and WRKFLD = 'ZZ'), should > this get a hit? You bet. Padding takes place. > 2) If the program is not under commitment control but the program is > compiled with the default COMMIT( *CHANGE ), should this affect the results > of the update? Only if the transaction is rolled back instead of commited. Best to define in the program your intention with EXEC COMMIT WORK.If the file is not journaled, it won't work anyway. If it was created by CREATE TABLE in a *real* collection, the journal will be there. -- =========================================================== R. Bruce Hoffman, Jr. -- IBM Certified AS/400 Administrator -- The sum of all human knowledge is a fixed constant. It's the population that keeps growing!
begin: vcard fn: R. Bruce Hoffman, Jr. n: ;R. Bruce Hoffman, Jr. adr: 991 Lucon Road;;;Schwenksville;PA;19473;USA email;internet: email@example.com title: Independant AS/400 Consultant tel;work: 610-222-9707 tel;fax: 610-222-9717 x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard