Rdb field comments.
David Gray
grayd@extenza-turpin.com
Mon, 23 Feb 2004 11:52:41 -0000
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_01C3FA03.8AD64550
Content-Type: text/plain
Greetings,
OpenVMS V7.3-2
Oracle Rdb V7.1-221
Powerhouse V7.10.G1
Is it possible to have Rdb field comments show up in QSHOW?
E.g.
$ SQL Show table sales_analysis;
ROW_IDENT BIGINT ROW_IDENT_DO
Comment: ---> This column is updated by the trigger SA_ADD_INDENT.
DO NOT UPDATE
Qshow> show rec sales_analysis in database
ROW_IDENT NUM 0 0 0 ^,^^^,^^^,^...
Thanks in advance.
David.
David Gray
Oracle DBA / OpenVMS Systems Manager Extenza Turpin
Blackhorse Road
Letchworth
Herts
SG6 3BE
david.gray@extenza-turpin.com <mailto:david.gray@extenza-turpin.com>
http://www.extenza-turpin.com/ <http://www.extenza-turpin.com/>
tel:
fax:
mobile: +44 1462 687531
+44 1462 480947
+44 778 926 3270
<http://www.plaxo.com/signature> Powered by Plaxo
<http://www.plaxo.com/signature> Want a signature like this?
<https://www.plaxo.com/add_me?u=21474892575&v0=104759&k0=1015963815> Add me
to your address book...
------_=_NextPart_001_01C3FA03.8AD64550
Content-Type: text/html
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=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2737.800" name=3DGENERATOR></HEAD>
<BODY>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT =
face=3DArial>Greetings,=20
</FONT></SPAN></STRONG></DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT=20
face=3DArial></FONT></SPAN></STRONG> </DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT=20
face=3DArial>OpenVMS =
V7.3-2=20
</FONT></SPAN></STRONG></DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT face=3DArial>Oracle =
Rdb =
V7.1-221</FONT></SPAN></STRONG></DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT=20
face=3DArial>Powerhouse =
V7.10.G1</FONT></SPAN></STRONG></DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT=20
face=3DArial></FONT></SPAN></STRONG> </DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT face=3DArial>Is it =
possible to=20
have Rdb field comments show up=20
in QSHOW? </FONT></SPAN></STRONG></DIV>
<DIV><STRONG><SPAN =
class=3D499553511-23022004></SPAN></STRONG> </DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT=20
face=3DArial>E.g. </FONT></SPAN></STRONG></DIV>
<DIV><STRONG><SPAN =
class=3D499553511-23022004></SPAN></STRONG> </DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT face=3DArial>$ SQL =
Show table=20
sales_analysis; </FONT></SPAN></STRONG></DIV>
<DIV><STRONG><SPAN =
class=3D499553511-23022004> </SPAN></STRONG></DIV>
<DIV><STRONG><SPAN=20
class=3D499553511-23022004>ROW_IDENT =
=
=20
BIGINT =20
ROW_IDENT_DO<BR> Comment: =
--->=20
This column is updated by the trigger SA_ADD_INDENT. DO NOT=20
UPDATE</SPAN></STRONG></DIV>
<DIV><STRONG><SPAN =
class=3D499553511-23022004></SPAN></STRONG> </DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT =
face=3DArial>Qshow> show=20
rec sales_analysis in database </FONT></SPAN></STRONG></DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT=20
face=3DArial> ROW_IDENT &n=
bsp; &n=
bsp; =20
NUM 0 =
0 =20
0 ^,^^^,^^^,^...</FONT> </SPAN></STRONG></DIV>
<DIV><STRONG><FONT face=3DArial></FONT></STRONG> </DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004><FONT face=3DArial>Thanks =
in advance.=20
</FONT></SPAN></STRONG></DIV>
<DIV><STRONG><SPAN class=3D499553511-23022004> <FONT=20
face=3DArial>David. </FONT></SPAN></STRONG></DIV>
<DIV><STRONG><FONT face=3DArial></FONT></STRONG> </DIV>
<DIV> </DIV>
<STYLE>
<!--
A.psl {
; COLOR: #4e81c4; TEXT-DECORATION:none
}
A:hover {
TEXT-DECORATION: underline
}
A.psl:hover {
COLOR: #999999
}
.noro {
; FONT-SIZE: 8pt; COLOR: #4e81c4; FONT-FAMILY: Verdana,Arial,fixed
}
.tiny {
FONT-SIZE: 1pt
}
.logotext {
TEXT-DECORATION: none; FONT-SIZE: 10pt; COLOR: #ffffff; FONT-FAMILY: =
Verdana,Arial,fixed
}
A.brand {
COLOR: #777777; FONT-SIZE: 7pt; FONT-FAMILY: Verdana,Arial,fixed; =
TEXT-DECORATION: none
}
-->
</STYLE>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D600 border=3D0>
<TBODY>
<TR>
<TD>
<TABLE height=3D80 cellSpacing=3D0 cellPadding=3D0 width=3D600 =
align=3Dright=20
border=3D0>
<TBODY>
<TR>
<TD class=3Dtiny>
<TABLE=20
style=3D"BORDER-RIGHT: #666666 1px solid; BORDER-TOP: =
#666666 1px solid; BORDER-LEFT: #666666 1px solid; BORDER-BOTTOM: =
#666666 1px solid"=20
height=3D"100%" cellSpacing=3D0 width=3D600>
<TBODY>
<TR>
<TD colSpan=3D2>
<TABLE height=3D"100%" cellSpacing=3D2 width=3D"100%" =
align=3Dright=20
border=3D0>
<TBODY>
<TR style=3D"PADDING-BOTTOM: 4px" height=3D1>
<TD class=3Dnoro style=3D"PADDING-LEFT: 4px"=20
vAlign=3Dtop><B>David Gray</B><BR><I>Oracle DBA =
/ OpenVMS=20
Systems Manager</I> </TD>
<TD class=3Dnoro style=3D"PADDING-RIGHT: 4px" =
vAlign=3Dtop=20
align=3Dright><B>Extenza Turpin</B><BR>Blackhorse =
Road<BR>Letchworth<BR>Herts<BR>SG6 3BE =
</TD></TR>
<TR height=3D1>
<TD class=3Dnoro=20
style=3D"PADDING-LEFT: 4px; PADDING-BOTTOM: 4px"=20
vAlign=3Dbottom><A class=3Dpsl=20
href=3D"mailto:david.gray@extenza-turpin.com"=20
=
target=3D_blank>david.gray@extenza-turpin.com</A><BR><A=20
class=3Dpsl =
href=3D"http://www.extenza-turpin.com/"=20
=
target=3D_blank>http://www.extenza-turpin.com/</A> </TD>
<TD class=3Dnoro=20
style=3D"PADDING-RIGHT: 4px; PADDING-BOTTOM: 4px" =
vAlign=3Dbottom align=3Dright>
<TABLE cellSpacing=3D0 align=3Dright =
border=3D0>
<TBODY>
<TR>
<TD class=3Dnoro noWrap align=3Dright>tel: =
<BR>fax:=20
<BR>mobile: </TD>
<TD class=3Dnoro style=3D"PADDING-LEFT: =
4px" noWrap=20
align=3Dright>+44 1462 687531<BR>+44 1462=20
480947<BR>+44 778 926 3270=20
=
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></=
TABLE></TD>
<TD></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD class=3Dtiny colSpan=3D2>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%">
<TBODY>
<TR>
<TD align=3Dleft><A class=3Dbrand =
href=3D"http://www.plaxo.com/signature"=20
target=3D_blank><I>Powered by Plaxo</I></A></TD>
<TD align=3Dright><A class=3Dbrand =
href=3D"http://www.plaxo.com/signature"=20
target=3D_blank><I>Want a signature like=20
this?</I></A></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD align=3Dmiddle colSpan=3D2><A class=3Dbrand=20
=
href=3D"https://www.plaxo.com/add_me?u=3D21474892575&v0=3D104759&=
;k0=3D1015963815"=20
target=3D_blank><I>Add me to your address=20
book...</I></A></TD></TR></TBODY></TABLE>
<DIV> </DIV></BODY></HTML>
------_=_NextPart_001_01C3FA03.8AD64550--