Re: Embedded SQL weirdness

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>]

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: rbruceh@ibm.net
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