Ols table? 
Author Message
 Ols table?

Hello

I would like to know if somebody can help me....there is any way that i can
detect which tables from an specific database has bee updated lately?

Please help me

--
Rosibel P. Gonzalez
System Specialist
DHL Panama, S.A.
Tel:    (507) 271-3400  Ext. 3462
Fax:    (507) 271-3480

_________________________________________________________________
WWW Track: http://www.***.com/

(In the body of the text enter one AWB# per line, your tracking
information will return immediately.)
or Call DHL:  800-DHL1



Sat, 05 Jun 2004 23:52:57 GMT
 Ols table?

On Tue, 18 Dec 2001 10:52:57 -0500, Rosibel Gonzalez

Quote:

>I would like to know if somebody can help me....there is any way that i can
>detect which tables from an specific database has bee updated lately?

Nothing built-in, that I know of. So you'd have to put a timestamp
column in the tables you want to monitor and check manually. What are
you trying to do? Maybe there's another way...


Sun, 06 Jun 2004 00:45:29 GMT
 Ols table?

You can have a look at sysmaster:sysptprof - it will show you number of
updates on tables since the last shutdown of the informix engine.

Dirk

Quote:
-----Original Message-----

Sent: 18 December 2001 17:53

Subject: Ols table?

Hello

I would like to know if somebody can help me....there is any way that i can
detect which tables from an specific database has bee updated lately?

Please help me

--
Rosibel P. Gonzalez
System Specialist
DHL Panama, S.A.
Tel:    (507) 271-3400  Ext. 3462
Fax:    (507) 271-3480

_________________________________________________________________
WWW Track: http://www.dhl.com

(In the body of the text enter one AWB# per line, your tracking information
will return immediately.) or Call DHL:  800-DHL1



Sun, 06 Jun 2004 17:43:45 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. comp.databases.informix.dba-tools: An improved "dspace" program

2. DTS: Using table from Source and table from Destination to create new table in Destination

3. Access 97/SqlServer 7: Appending Access Tables into Sql Server tables doesnt work for big tables

4. How to execute a Create table or alter table table everytime before a data load

5. Joining tables from a table variable with SQL tables

6. CREATE TABLE or Import results in new table being flagged as SYSTEM table

7. Table scan, Table scan, Table scan

8. ALTER TABLE on temp tables, table variables

9. Transactional Replication from a large table to a smaller table using criteria in a related table

10. Access97/Sqlserver7: Appending Access tables into Sql sever tables doesnt work for big tables

11. Definition of Intersection table (cross reference table, linked table)

12. Cross Table (Pivot Table) with Oracle Spread Table Control (MMTX32.OCX)


 
Powered by phpBB® Forum Software