<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6603.0">
<TITLE>QSHOW: how to show details on an element for a specific database</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi gang,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I am trying to get detailed information about a particular column in a database, using QSHOW.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I am trying things like ...</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">show ele actual_qty of order_detail</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">but I get syntax errors on the [of] verb.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I can do ...</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">show ele actual_qty</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">but it brings me information for the column, from a totally different database</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I also tried ...</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">show ele actual_qty IN order_detail but again I get errors.</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">Thank you all.</FONT>
</P>
<BR>
<BR>
<P><I><FONT COLOR="#0000FF" SIZE=4 FACE="Arial">Fernando Olmos</FONT></I>
<BR><B><FONT SIZE=2 FACE="Arial">M.I.S.</FONT></B>
</P>
<P><SPAN LANG="en-au"><B><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">HPA</FONT></B></SPAN><B><SPAN LANG="en-us"></SPAN></B><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Arial"><BR>
</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000000" SIZE=2 FACE="Arial">Direct: 03 9217 5411</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><BR>
</SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000000" SIZE=2 FACE="Arial">Mobile: 0410 382 857</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Arial"><BR>
</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000000" SIZE=2 FACE="Arial">Fax: 03 9217 5716</FONT><FONT FACE="Arial"></FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> </SPAN>
</P>
<P><SPAN LANG="en-au"></SPAN><A HREF="file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au"><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><U></U></SPAN><SPAN LANG="en-au"><U><B><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.hpa.com.au</FONT></B></U></SPAN><SPAN LANG="en-au"></SPAN></A><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN>
</P>
<BR>
</BODY>
</HTML>