Quick on AS/400 -- aliased While Retrieving data looks different from Primary file
Rendell Requiro
rendell@agbus.com
Mon, 15 Oct 2001 17:07:13 -0700
This is a multi-part message in MIME format.
------=_NextPart_000_0009_01C1559B.D5E2FFC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Using PH 6.07F on AS/400. Problem with incorrect data found during =
While Retrieve of aliased Primary file.
If retrieving records from an alias (open 1) of a primary file am =
getting values for aliased fields that do not appear to match the values =
in the primary fields.
I do a 'Put' to the primary file, then I 'alias' the primary with a =
separate open and do a while retrieving to set a value of a field for =
all records that qualify (done to update those records not shown on the =
screen cluster). When I retrieve the 'aliased' file, I get values for =
some 'flag' fields that do not match the same field values in the =
primary file.
I set a field called FLAG02 to Y and do a put to the primary file in the =
Update procedure. Then I do the WR and find that the values of FLAG02 =
are N. Quiz shows the same result. I do not see anywhere in the code =
where FLAG02 is set back to N.
Has anyone else run into this problem? Thanks very much.
Rendell Requiro
AG Business Management, Inc.
rendell@agbus.com
831-455-2355 x101 voice
831-455-2264 fax
www.agbus.com
------=_NextPart_000_0009_01C1559B.D5E2FFC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3401" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Using PH 6.07F on AS/400. Problem with =
incorrect data=20
found during While Retrieve of aliased Primary file.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>If retrieving records from an alias (open 1) of a =
primary file=20
am getting values for aliased fields that do not appear to match the =
values in=20
the primary fields.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>I do a 'Put' to the primary file, then I 'alias' the =
primary=20
with a separate open and do a while retrieving to set a value of a field =
for all=20
records that qualify (done to update those records not shown on the =
screen=20
cluster). When I retrieve the 'aliased' file, I get values for =
some 'flag'=20
fields that do not match the same field values in the primary =
file.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>I set a field called FLAG02 to Y and do a put to the =
primary=20
file in the Update procedure. Then I do the WR and find that the =
values of=20
FLAG02 are N. Quiz shows the same result. I do not see =
anywhere in=20
the code where FLAG02 is set back to N.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Has anyone else run into this problem? Thanks =
very=20
much.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Rendell Requiro<BR>AG Business Management, =
Inc.<BR><A=20
href=3D"mailto:rendell@agbus.com">rendell@agbus.com</A><BR>831-455-2355&n=
bsp; =20
x101 =20
voice<BR>831-455-2264 &nbs=
p; =20
fax<BR><A=20
href=3D"http://www.agbus.com">www.agbus.com</A><BR></FONT></DIV></BODY></=
HTML>
------=_NextPart_000_0009_01C1559B.D5E2FFC0--