Information Statement Problem
Edis, Bob
BEdis@usbnc.org
Thu, 26 Dec 2002 19:24:36 -0600
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C2AD46.B7BD55F0
Content-Type: text/plain;
charset="iso-8859-1"
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 = 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.
-----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
I'm not sure if I understand your question correctly.
Are you saying that the information statements, when executed, do not
display the values you are expecting?
I.e. when the code segment is executed you get something like:
dept code of time_att=xyz
dept code of lab_hist=
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.
Regards,
Blue
-----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:
LET DEPT_CODE OF LABOUR_HISTORY = DEPT_CODE OF TIME_ATTEND
info = 'dept code of time_att= ' + dept_code of time_attend now resp
info = 'dept code of lab_hist= ' + dept_code of labour_history now resp
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?
Dianne Landers
PCC Structurals
------_=_NextPart_001_01C2AD46.B7BD55F0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Information Statement Problem</TITLE>
<META content="MSHTML 5.50.4919.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=747511901-27122002><FONT face=Arial color=#0000ff size=2>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?</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Landers, Dianne
[mailto:DLanders@pcc-structurals.com]<BR><B>Sent:</B> Thursday, December 26,
2002 7:15 PM<BR><B>To:</B> Edis, Bob; PowerHouse List
(E-mail)<BR><B>Subject:</B> RE: Information Statement
Problem<BR><BR></FONT></DIV>
<DIV><SPAN class=140270801-27122002><FONT face=Arial color=#0000ff size=2>That
is what I'm saying.....when the information statements are executed, the
values aren't what I expect. I thought the</FONT></SPAN></DIV>
<DIV><SPAN class=140270801-27122002><FONT face=Arial size=2> <STRONG>LET
DEPT_CODE OF LABOUR_HISTORY =
DEPT_CODE OF TIME_ATTEND</STRONG> <FONT
color=#0000ff>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.</FONT></FONT></SPAN></DIV><SPAN
class=140270801-27122002></SPAN><FONT face=Tahoma>
<DIV><BR><SPAN class=140270801-27122002></SPAN> </DIV>
<DIV><FONT size=2><SPAN class=140270801-27122002></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=140270801-27122002> </SPAN>-----Original
Message-----<BR><B>From:</B> Edis, Bob
[mailto:BEdis@usbnc.org]<BR><B>Sent:</B> Thursday, December 26, 2002 4:36
PM<BR><B>To:</B> PowerHouse List (E-mail)<BR><B>Subject:</B> RE: Information
Statement Problem<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>Dear Dianne</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>I'm not sure if I understand your question correctly.
</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>Are you saying that the information statements, when executed, do not
display the values you are expecting?</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>I.e. when the code segment is executed you get something
like:</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>dept code of time_att=xyz</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>dept code of lab_hist=</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2>Blue</FONT></SPAN></DIV>
<DIV><SPAN class=749382800-27122002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Landers, Dianne
[mailto:DLanders@pcc-structurals.com]<BR><B>Sent:</B> Thursday, December
26, 2002 5:53 PM<BR><B>To:</B> Powerh-L (E-mail)<BR><B>Subject:</B>
Information Statement Problem<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Platform: Oracle 8.1.7, HPUX
Version 11.0, PH 8.23.d7, VISIBILITY/6.36</FONT> </P>
<P><FONT face=Arial size=2>Anyone out there experienced this
problem:</FONT> </P>
<P><FONT face=Arial size=2> LET
DEPT_CODE OF LABOUR_HISTORY =
DEPT_CODE OF TIME_ATTEND</FONT> <BR><FONT
face=Arial size=2>info = 'dept code of time_att= ' + dept_code of
time_attend now resp</FONT> <BR><FONT face=Arial size=2>info = 'dept code
of lab_hist= ' + dept_code of labour_history now resp</FONT> </P>
<P><FONT face=Arial size=2>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.</FONT></P>
<P><FONT face=Arial size=2>whats the deal?</FONT> </P>
<P><FONT face=Arial size=2>Dianne Landers</FONT> <BR><FONT face=Arial
size=2>PCC Structurals</FONT>
</P></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C2AD46.B7BD55F0--