[Info-ingres] Weird problem in Ingres 10

[Mark]

On Fri, 18 May 2018 09:11:26 +1000, "pwhite peercore"
<pwhite at peercore.com.au> wrote:

>This example thanks to Thien.
>
> 
>
>auditdb mydb  -b13-may-2018:07:00 -e14-may-2018:07:00 -table=gl_batch_detail -file 
>
> 
>
>This will create a file ( ‘gl_batch_detail.trl’ ) that contains all the transactions related to ‘gl_batch_detail’ table
>
>Then run this SQL
>
> 
>
>/*create audit structure table for output file from auditdb. Keep this table handy for future use*/
>
>create table aud_structure
>
>       (datetemp ingresdate not null with default,
>
>       username char(32) not null with default,
>
>       operation char(8) not null with default,
>
>       tranid1 integer not null with default,
>
>       tranid2 integer not null with default,
>
>       table_id1 integer not null with default,
>
>       table_id2 integer not null with default) \g
>
> 
>
>create table gl_batch_detail_audit 
>
>as select a.*, b.* from aud_structure a, gl_batch_detail b 
>
>where 1 = 2 \g
>
> 
>
>copy table gl_batch_detail_audit () from 'gl_batch_detail.trl' \g
>
> 
>
>select top 20 * from gl_batch_detail_audit \g

In my case there are only two rows one with operation="begin" and one
with operation="commit".  None of the other columns contain meaningful
data [All string fields are '.' or NULL and numeric data is always 0
or NULL]

>From: info-ingres-bounces at lists.planetingres.org [mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of Alex Hanshaw
>Sent: Friday, 18 May 2018 2:14 AM
>To: Mark; info-ingres at lists.planetingres.org
>Subject: Re: [Info-ingres] Weird problem in Ingres 10
>
> 
>
>See:
>
> 
>
>http://docs.actian.com/ingres/11.0/index.html#page/DatabaseAdmin%2FHow_to_Load_an_Audit_Trail_as_a_Table.htm
>
> 
>
>The example is based on the columns in the example table. You’ll need to define the target table based on the audited table.
>
> 
>
>Alex

-- 
<insert witty sig here>