Re: Informix on AIX (newbie).
--0-1706825434-1104795401=:69588
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
You can use this script get an clean data output:
dbaccess sysmaster -<<EOF 2>/dev/null | grep -v ^$ | grep -v name
select name from sysdatabases
where name not in ( "sysmaster", "sysutils" )
order by 1;
Floyd Wellershaus <fwellers@yahoo.com> wrote:
Any ascii terminal, such as vt100 will display dbaccess and onmonitor. Onstat and oncheck don't even have interfaces. They are pure commandline.
Nuno Paquete <nmp@ispgaya.pt> wrote: > onstat -- will show you all the onstat options ( which will apply to your
> instance )
> onmode -- will show you all the onmode options.
> oncheck -- will show you all the oncheck options.
>
> echo "select * from sysdatabases" | dbaccess sysmaster will show you all
> the databases too.
Does this runs on a text environment?
I've read some papers that shows grafical interface when running "dbaccess"
command.
Regards.
========================
-<<Floyd Wellershaus>>-
Database Administrator
Unix Administrator
email: fwellers@yahoo.com
Work: 703-733-4126
Pager: 703-705-9241
Email Pager: 7037059241@my2way.com
Home: 703-430-0805
Cell: 703-477-6045
========================
---------------------------------
Do You Yahoo!?
Yahoo! Net: La mejor conexi'n a internet y 25MB extra a tu correo por $100 al mes.
--0-1706825434-1104795401=:69588
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
<DIV>You can use this script get an clean data output:</DIV>
<DIV> </DIV>
<DIV>dbaccess sysmaster -<<EOF 2>/dev/null | grep -v ^$ | grep -v name</DIV>
<DIV>select name from sysdatabases<BR>where name not in ( "sysmaster", "sysutils" )<BR>order by 1;<BR><BR><B><I>Floyd Wellershaus <fwellers@yahoo.com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<DIV>Any ascii terminal, such as vt100 will display dbaccess and onmonitor. Onstat and oncheck don't even have interfaces. They are pure commandline.<BR><BR><B><I>Nuno Paquete <nmp@ispgaya.pt></I></B> wrote:
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">> onstat -- will show you all the onstat options ( which will apply to your <BR>> instance )<BR>> onmode -- will show you all the onmode options.<BR>> oncheck -- will show you all the oncheck options.<BR>><BR>> echo "select * from sysdatabases" | dbaccess sysmaster will show you all <BR>> the databases too.<BR><BR>Does this runs on a text environment?<BR>I've read some papers that shows grafical interface when running "dbaccess" <BR>command.<BR><BR>Regards. <BR><BR><BR></BLOCKQUOTE></DIV><BR><BR>
<DIV>
<DIV>========================<BR>-<<Floyd Wellershaus>>-<BR>Database Administrator<BR>Unix Administrator</DIV>
<DIV><BR>email: <A href="mailto:fwellers@yahoo.com">fwellers@yahoo.com</A><BR>Work: 703-733-4126</DIV>
<DIV>Pager: 703-705-9241 </DIV>
<DIV>Email Pager: <A href="mailto:7037059241@my2way.com">7037059241@my2way.com</A></DIV>
<DIV>Home: 703-430-0805</DIV>
<DIV>Cell: 703-477-6045<BR>========================</DIV></DIV></BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://net.yahoo.com.mx"><b>Yahoo! Net</b></a>: La mejor conexi'n a internet y 25MB extra a tu correo por
<a href="http://net.yahoo.com.mx/">$100 al mes</a>.<br>
--0-1706825434-1104795401=:69588--
sending to informix-list