Information Statement Problem
Landers, Dianne
DLanders@pcc-structurals.com
Fri, 27 Dec 2002 09:27:28 -0800
This is a multi-part message in MIME format.
------_=_NextPart_001_01C2ADCD.3A778278
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Its a batch quick, called from another batch quick program, so I can't =
figure out how to use debug effectively. As I step thru the first =
screen, it never executes the RUN SCREEN command to get me into the =
program that is actually not working. I keep getting TRAP Encountered =
messages. Thats why I'm fiddling around with INFO statements. =
Visibility creates quick screens that run in batch mode, and this is a =
customized quick screen. I thought about trying to make it interactive =
just to see if I can somehow use debug, but that will probably be a =
useless exercise as well.
=20
The correct data does get written to the database. The info statements =
are in the same procedure. I don't think there is anything special =
about the columns that display compared to the columns that don't =
display. I'm displaying CHAR(4), Dates, etc. DEPT_CODE of =
labour_history is char(4).
=20
I think i'm just going to have to rethink the methodology that is being =
used to accomplish summarizing the data before it posts to the Database, =
and try something different.
=20
thanks for your help.
=20
=20
=20
-----Original Message-----
From: Edis, Bob [mailto:BEdis@usbnc.org]
Sent: Thursday, December 26, 2002 5:25 PM
To: PowerHouse List (E-mail)
Subject: RE: Information Statement Problem
What are the column definitions/properties? Are the other INFO =
statements in the same procedure? Have you tried using DEBUG to examine =
the data step by step? Is there anything special about the column? =
E.g. is there a PHD definition that may mask the Oracle metadata? Does =
this happen for every row in the table? Is anything actually written to =
the column in the database?
-----Original Message-----
From: Landers, Dianne [mailto:DLanders@pcc-structurals.com]
Sent: Thursday, December 26, 2002 7:15 PM
To: Edis, Bob; PowerHouse List (E-mail)
Subject: RE: Information Statement Problem
That is what I'm saying.....when the information statements are =
executed, the values aren't what I expect. I thought the
LET DEPT_CODE OF LABOUR_HISTORY =3D DEPT_CODE OF TIME_ATTEND =
statement would plug the value into the variable, so I should be able to =
display it, and use it. Are you saying that you think that it is just =
putting it into the record buffer? But other columns of the table =
LABOUR_HISTORY have the expected values in them when I display them with =
an INFO statement.
=20
=20
-----Original Message-----
From: Edis, Bob [mailto:BEdis@usbnc.org]
Sent: Thursday, December 26, 2002 4:36 PM
To: PowerHouse List (E-mail)
Subject: RE: Information Statement Problem
Dear Dianne
=20
I'm not sure if I understand your question correctly. =20
Are you saying that the information statements, when executed, do not =
display the values you are expecting?
=20
I.e. when the code segment is executed you get something like:
dept code of time_att=3Dxyz
dept code of lab_hist=3D
=20
Is the code example you provide the exact syntax from the program code? =
If it is then I think the problem is that the LABOUR_HISTORY record has =
not yet been updated/committed so the change is still in a buffer. Try =
running the program and then check the row values in a PL/SQL SELECT =
statement. If the LABOUR_HISTORY row still has no value then there is a =
problem.
=20
Regards,
Blue
=20
-----Original Message-----
From: Landers, Dianne [mailto:DLanders@pcc-structurals.com]
Sent: Thursday, December 26, 2002 5:53 PM
To: Powerh-L (E-mail)
Subject: Information Statement Problem
Platform: Oracle 8.1.7, HPUX Version 11.0, PH 8.23.d7, VISIBILITY/6.36 =
Anyone out there experienced this problem:=20
LET DEPT_CODE OF LABOUR_HISTORY =3D DEPT_CODE OF =
TIME_ATTEND=20
info =3D 'dept code of time_att=3D ' + dept_code of time_attend now resp =
info =3D 'dept code of lab_hist=3D ' + dept_code of labour_history now =
resp=20
when I try to display the value of Dept_code of labour_history it is =
blank. But Dept_code of Time_attend has the correct value. if I hard =
code something in the let statement, it displays. And other columns in =
the Labour_History table have the correct value.
whats the deal?=20
Dianne Landers=20
PCC Structurals=20
------_=_NextPart_001_01C2ADCD.3A778278
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 HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Information Statement Problem</TITLE>
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV>
<DIV><SPAN class=3D560080817-27122002><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2>Its a batch quick, called from another batch quick program, so =
I can't=20
figure out how to use debug effectively. <SPAN=20
class=3D860382417-27122002>As I step thru the first screen, it never =
executes the=20
RUN SCREEN command to get me into the program that is actually not=20
working. I keep getting TRAP Encountered messages. =
</SPAN>Thats why=20
I'm fiddling around with INFO statements.<SPAN=20
class=3D860382417-27122002> Visibility creates quick screens that =
run in=20
batch mode, and this is a customized quick screen. I thought about =
trying=20
to make it interactive just to see if I can somehow use debug, but that =
will=20
probably be a useless exercise as =
well.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D560080817-27122002><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2><SPAN=20
class=3D860382417-27122002></SPAN></FONT></FONT></FONT></SPAN> </DIV=
>
<DIV><SPAN class=3D560080817-27122002><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2><SPAN class=3D860382417-27122002>The correct data does get =
written to the=20
database. The info statements are in the same procedure. I =
don't=20
think there is anything special about the columns that display compared =
to the=20
columns that don't display. I'm displaying CHAR(4), Dates, =
etc. =20
DEPT_CODE of labour_history is =
char(4).</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D560080817-27122002><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2><SPAN=20
class=3D860382417-27122002></SPAN></FONT></FONT></FONT></SPAN> </DIV=
>
<DIV><SPAN class=3D560080817-27122002><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2><SPAN class=3D860382417-27122002>I think i'm just going to have =
to rethink=20
the methodology that is being used to accomplish summarizing the data =
before it=20
posts to the Database, and try something=20
different.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D560080817-27122002><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2><SPAN=20
class=3D860382417-27122002></SPAN></FONT></FONT></FONT></SPAN> </DIV=
>
<DIV><SPAN class=3D560080817-27122002><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2><SPAN class=3D860382417-27122002>thanks for your=20
help.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D560080817-27122002><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2><SPAN=20
class=3D860382417-27122002></SPAN></FONT></FONT></FONT></SPAN> </DIV=
>
<DIV><SPAN class=3D560080817-27122002><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2><SPAN=20
class=3D860382417-27122002></SPAN></FONT></FONT></FONT></SPAN> </DIV=
><SPAN=20
class=3D560080817-27122002><FONT face=3DArial><FONT =
color=3D#0000ff><FONT size=3D2><SPAN=20
class=3D860382417-27122002></SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D560080817-27122002><FONT face=3DArial><FONT =
color=3D#0000ff><FONT=20
size=3D2><SPAN =
class=3D860382417-27122002></SPAN></FONT></FONT></FONT></SPAN><FONT=20
face=3DTahoma>
<DIV><BR></DIV><FONT size=3D2><SPAN =
class=3D860382417-27122002></SPAN></FONT>
<DIV><FONT size=3D2><SPAN =
class=3D860382417-27122002></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN =
class=3D860382417-27122002> </SPAN>-----Original=20
Message-----<BR><B>From:</B> Edis, Bob =
[mailto:BEdis@usbnc.org]<BR><B>Sent:</B>=20
Thursday, December 26, 2002 5:25 PM<BR><B>To:</B> PowerHouse List=20
(E-mail)<BR><B>Subject:</B> RE: Information Statement=20
Problem<BR><BR></DIV></FONT></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV><SPAN class=3D747511901-27122002><FONT face=3DArial =
color=3D#0000ff size=3D2>What=20
are the column definitions/properties? Are the other INFO =
statements in=20
the same procedure? Have you tried using DEBUG to examine the =
data step=20
by step? Is there anything special about the column? E.g. =
is there=20
a PHD definition that may mask the Oracle metadata? Does this =
happen for=20
every row in the table? Is anything actually written to the =
column in=20
the database?</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Landers, Dianne=20
[mailto:DLanders@pcc-structurals.com]<BR><B>Sent:</B> Thursday, =
December 26,=20
2002 7:15 PM<BR><B>To:</B> Edis, Bob; PowerHouse List=20
(E-mail)<BR><B>Subject:</B> RE: Information Statement=20
Problem<BR><BR></FONT></DIV>
<DIV><SPAN class=3D140270801-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>That is what I'm saying.....when the information statements =
are=20
executed, the values aren't what I expect. I thought=20
the</FONT></SPAN></DIV>
<DIV><SPAN class=3D140270801-27122002><FONT face=3DArial=20
size=3D2> <STRONG>LET DEPT_CODE OF=20
LABOUR_HISTORY =3D DEPT_CODE OF=20
TIME_ATTEND</STRONG> <FONT color=3D#0000ff>statement =
would plug=20
the value into the variable, so I should be able to display it, and =
use=20
it. Are you saying that you think that it is just putting it =
into the=20
record buffer? But other columns of the table LABOUR_HISTORY =
have the=20
expected values in them when I display them with an INFO=20
statement.</FONT></FONT></SPAN></DIV><SPAN=20
class=3D140270801-27122002></SPAN><FONT face=3DTahoma>
<DIV><BR><SPAN class=3D140270801-27122002></SPAN> </DIV>
<DIV><FONT size=3D2><SPAN =
class=3D140270801-27122002></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN =
class=3D140270801-27122002> </SPAN>-----Original=20
Message-----<BR><B>From:</B> Edis, Bob=20
[mailto:BEdis@usbnc.org]<BR><B>Sent:</B> Thursday, December 26, 2002 =
4:36=20
PM<BR><B>To:</B> PowerHouse List (E-mail)<BR><B>Subject:</B> RE: =
Information=20
Statement Problem<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Dear Dianne</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>I'm not sure if I understand your question =
correctly. =20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Are you saying that the information statements, when =
executed, do=20
not display the values you are expecting?</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>I.e. when the code segment is executed you get something=20
like:</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>dept code of time_att=3Dxyz</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>dept code of lab_hist=3D</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Is the code example you provide the exact syntax from the =
program=20
code? If it is then I think the problem is that the =
LABOUR_HISTORY=20
record has not yet been updated/committed so the change is still =
in a=20
buffer. Try running the program and then check the row =
values in a=20
PL/SQL SELECT statement. If the LABOUR_HISTORY row still has =
no=20
value then there is a problem.</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Blue</FONT></SPAN></DIV>
<DIV><SPAN class=3D749382800-27122002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Landers, =
Dianne=20
[mailto:DLanders@pcc-structurals.com]<BR><B>Sent:</B> Thursday, =
December=20
26, 2002 5:53 PM<BR><B>To:</B> Powerh-L =
(E-mail)<BR><B>Subject:</B>=20
Information Statement Problem<BR><BR></FONT></DIV><!-- Converted =
from text/rtf format -->
<P><FONT face=3DArial size=3D2>Platform: Oracle 8.1.7, =
HPUX =20
Version 11.0, PH 8.23.d7, VISIBILITY/6.36</FONT> </P>
<P><FONT face=3DArial size=3D2>Anyone out there experienced this =
problem:</FONT> </P>
<P><FONT face=3DArial size=3D2> =
LET=20
DEPT_CODE OF LABOUR_HISTORY =3D=20
DEPT_CODE OF TIME_ATTEND</FONT> =
<BR><FONT=20
face=3DArial size=3D2>info =3D 'dept code of time_att=3D ' + =
dept_code of=20
time_attend now resp</FONT> <BR><FONT face=3DArial size=3D2>info =
=3D 'dept=20
code of lab_hist=3D ' + dept_code of labour_history now =
resp</FONT> </P>
<P><FONT face=3DArial size=3D2>when I try to display the value =
of Dept_code=20
of labour_history it is blank. But Dept_code of =
Time_attend has=20
the correct value. if I hard code something in the let =
statement,=20
it displays. And other columns in the Labour_History table =
have=20
the correct value.</FONT></P>
<P><FONT face=3DArial size=3D2>whats the deal?</FONT> </P>
<P><FONT face=3DArial size=3D2>Dianne Landers</FONT> <BR><FONT =
face=3DArial=20
size=3D2>PCC Structurals</FONT>=20
</P></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C2ADCD.3A778278--