• Subject: Re: Embedded SQL weirdness
  • From: "R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>
  • Date: Thu, 14 Jan 1999 08:38:35 -0500

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


This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].