DB infos
Hello,
1. How can i extract a list of all tables off my DB ? There is a lot
of tabe, and i cant do that using dbaccess..
2. I have a table that get the data from another table, using an
stored procedure.. everyday at 4am. But i dont know the name of the
SP, how can i find that?
Tks
select tabname from systables where tabid>99;
As to the second, I would look to the scheduler on your system to see what
is running at 4am.
crontab -l for unix - although you are going to have to do that as the user
who runs the stored procedure, you could also as root go look in the crontab
directory and grep for 4 in all crontab files.
j.
Sane ego te vocavi. Forsitan capedictum tuum desit.
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]On Behalf Of Paul
Sent: Friday, April 11, 2008 10:54 AM
To: informix-list@iiug.org
Subject: DB infos
Hello,
1. How can i extract a list of all tables off my DB ? There is a lot
of tabe, and i cant do that using dbaccess..
2. I have a table that get the data from another table, using an
stored procedure.. everyday at 4am. But i dont know the name of the
SP, how can i find that?
Tks
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
If you want tables only and not views or synonyms:
select tabname from systables where tabid > 99 and tabtype = 'T'
To search for stored procedures containing a table name:
SQL:
select *
from sysprocedures x1, sysprocbody x2
where x1.procid = x2.procid
and data matches '*table-name*'
O/S:
dbaccess -d database-name
Regards,
Doug Lawry
"Jack Parker" <jack.parker4@verizon.net> wrote in message
news:mailman.939.1207926876.20610.informix-list@iiug.org...
>
> select tabname from systables where tabid>99;>
> As to the second, I would look to the scheduler on your system to see what
> is running at 4am.
>
> crontab -l for unix - although you are going to have to do that as the
> user
> who runs the stored procedure, you could also as root go look in the
> crontab
> directory and grep for 4 in all crontab files.
>
> j.
>
> Sane ego te vocavi. Forsitan capedictum tuum desit.
>
> -----Original Message-----
> From: informix-list-bounces@iiug.org
> [mailto:informix-list-bounces@iiug.org]On Behalf Of Paul
> Sent: Friday, April 11, 2008 10:54 AM
> To: informix-list@iiug.org
> Subject: DB infos
>
>
> Hello,
>
> 1. How can i extract a list of all tables off my DB ? There is a lot
> of tabe, and i cant do that using dbaccess..
>
> 2. I have a table that get the data from another table, using an
> stored procedure.. everyday at 4am. But i dont know the name of the
> SP, how can i find that?
>
> Tks
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>